Optimize only fragmented tables in MySQL

Sharing is caring!

MySQL tables are often fragmented and most of the clients/devs don’t give a f’ about it! They ‘re happy just to blame the sysadmin. So since you’re not a DBA you can’t do magic, but you can optimize these tables for them.

For that puprose I use mysqltuner which is written in perl, download it from here. This tool will give you a good overview about your mysql server’s condition.

Of course you can use

but it will take more time than optimizing the specific tables that are fragmented. In order to do that, you can use this bash script  (I originally found it here). Before using any script or modify anything in mysql consider use mysqltuner, it will give you a good overview of your mysql server.

 

 

Comment:

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