Hopefully threadsdev.com will be back up soon. We have a dedicated mysql forum there where users have posted alot of tips on tweaking mysql, adjusting the mysql.cnf file, etc. This is an area that I'm not extremely experienced in but Brett does offer some very good tips.
I believe by default mysql.cnf file is setup for a medium sized site. On most installs of mysql they also have sample config files for large or huge sites which will adjust the mysql settings accordingly.
-------------------
Rick Baker
UBBThreads developer
