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