问题描述:

I have a database and that contain many tables , but all of them store text and full tables size is less than 10 MB , but the database file on server have larger than 1 GB

The tables uses MyIASM , where is the problem ?

thanks

网友答案:

You can use OPTIMIZE TABLE for reducing disk usage on MyISAM tables (usually after deleting lot of data from them or doing major changes in structure).

For InnoDB, that is quite more challenging, see Howto: Clean a mysql InnoDB storage engine?

相关阅读:
Top