Empulse Group a collection of notes from a sys admin, musician, and father


Optimize all MySQL tables using MyISAM

A common cause of slow sites and high server load is the MySQL server.  Many times I find the cause to be database tables that need to be optimized.

[root@www ~]# for i in `mysql -e 'select concat(table_schema,".",table_name) from information_schema.tables where engine="MyISAM"'`; do mysql -e "optimize table $i"; done
Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

No trackbacks yet.

Copyright © 2018 Empulse Group · Powered by WordPress
Lightword Theme by Andrei Luca Go to top ↑