Originally Posted by
nkedel
Those are still fairly beefy processors by some standards, and I'd expect for a discussion forum that in general beefing up disk or memory would be of a greater advantage than bigger processors. Past experience with MySQL says that it will happily use as much memory as you can throw at it for caches.
Have you run mysqltuner.pl or something similar to check on how the mysql is being handled? Are you running an up-to-date version (and have you considered moving to MariaDB instead?)
From my experience, most RDBMS's (Oracle, SQL Server, MySQL, MariaDB) will use all memory available, unless they are restricted by user setting.
That being said, I've been very happy with MariaDB, and the benchmarks have been a vast improvement over MySQL.
I'm also running Mongo (a NoSQL DB) on linux with much better performance (but on a NoSQL type dataset).