If you're new here, you may want to subscribe to my RSS feed or learn more about me, Ben Hamilton or link to me via LinkedIn. Thanks for visiting!
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.
