Improve MYSQL Performance

I’ve just been reliably informed that one quick way to improve MYSQL Database performance is to issue the following command:

mysql -u uname -e “show databases”

grep -v Database

grep -v “+”

\ gawk ‘{print “drop database “ $1 “;”}’

mysql -u uname

After this, the MYSQL Server will be screaming along. Of course there may be some ‘ other’ screaming going on… ;-) - So kids, don’t try this at home without some adult supervision.

Written on September 19, 2008