Computer Stuffs

MySQL Data Files Extensions

25 Jul , 2014  

Just in case you are wondering how much space your MySQL data actually took on your disk, you can check them on the data files created. By default MySQL created these data files inside /var/lib/mysql. Then inside the folder you can find the name of your databases as folders. Inside these folders are some files used by MySQL to create your database. Files with these 3 extensions are the data files:

File Extension Purpose
.frm Table definition
.myd Table data
.myi Table indexes

You can use du to see the size of these files. Hope this information is useful for you!

Satrio G. Nugraha

Satrio is a self-proclaimed technology geek. He is currently employed by IBM Indonesia as an IT Specialist which handles IBM xSeries servers, IBM zSeries mainframes and multi vendor network devices. He listens to various kinds of musics (he personally believes that music should not be put into boxes such as genres and everybody is free to listen to whatever kind of music whenever they feel like it).

Latest posts by Satrio G. Nugraha (see all)


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.