When it's going fast i'll let you know !

Seriously though I suggest this ...

If you have put in my index additions ( only do this if you have alot of RAM and a big forum)
then you need to set your key buffer to be about 10MB
bigger than the total file size of your *MYI files
( yes these are mine )

390800568 Sep 7 09:40 post.MYD
63578112 Sep 7 09:40 post.MYI
8930 Aug 23 15:10 post.frm

Make sure you have enough RAM to hold the whole of your
files in ram plus your max_connections * all the memory
used per thread. check your sort buffer, join buffer etc

That should then hopefully make it go faster !

Also try both of my hacks - this one and http://forums.gameplay.com/global_hack_pt2.html
will make your db machine happier

in peak load try watching
/usr/bin/vmstat 1

This will let you know if you are swapping like mad. Also
watch top to see whats going on !

Your new machine will help ! Donate the old one to being a web server

Oh and yes i'm using MySQL.

Fodder