kingbikram Posted April 23, 2008 Share Posted April 23, 2008 Hello MySQL Guru's, I need some help on mysql and i have no idea about it. I am a sys. admin. I have two files 248296 file1.MYD 108112 file2.MYI These files are occupying some space which is giving hard time to the file system. I want to clean/shrink them. Can I do it and how? Thanks a million in advance Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted May 3, 2008 Share Posted May 3, 2008 Those are data (*.MYD) and index (*.MYI) files for a mysql table. if you delete them, it will delete the mysql table (and probably screw with the database as well). If you need to shrink them, remove some data from the table. If the table is no longer inserted into (i.e. it's read only) you can use myisampack to compress it. You can try and OPTIMIZE the table, but you probably won't get much improvement. http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.