FlyerTalk Forums - View Single Post - Whoa, $250 to go from 2.6GHz to 2.7GHz Quad-core Intel Core i7 (Macbook)?
Old Jan 21, 2014 | 8:14 pm
  #23  
HDQDD
30 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: Dec 2009
Location: RDU
Programs: DL DM+(segs)/MM, UA Ag, Hilton DM, Marriott Ti (life Pt), TSA Opt-out Platinum
Posts: 3,366
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).
HDQDD is offline