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

28Nov/100

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.