Kevin McCarthy writing on Bostinno.com has posted an interesting article “MySQL Tips For WordPress That Don’t Suck” that is well worth a read if you want to get the best from a WordPress site.
“MySQL is almost always the bottleneck for WordPress sites. There are many posts written about MySQL optimization for the CMS, but they generally fall into two buckets: too basic (“reduce the number of plugins”) or only contain one good nugget of info.
Here is a collection of not-too-obvious MySQL optimizations you can make if you are looking for a fast WordPress site”
