Hi,
Have you looked at tuning Drupal first? What processes are slowing your server down and
are there any other applications sharing the machine that might be contributing to the
problem? Assuming you haven't got any wacky contrib modules have you considered improving
your application caching, or if you have any custom modules - look at whether you can add
an appropriate index to any of the tables. Of course, if you want to throw more hardware
at the problem it might help in the short run but it might be masking the original
problem.
Regards,
Johan
-----Original Message-----
From: shamubro@stripped [mailto:shamubro@stripped]
Sent: 21 April 2010 15:31
To: mysql@stripped
Subject: More CPU or More RAM?
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO
and CPU are high. So I am planning to upgrade it to a dedicated serer.
Here are two choice of my server:
1. Intel Pentium G6950 (Dual Core), 2xSATA Drive (no RAID), 8G RAM
2. Intel Xeon X3210 (Quad Core), 2XSATA drive (no RAID), 4G RAM.
I know the best way to do this is to benchmark the two servers, but I can't
do that, can only pick one. Could anyone of you tell me which one is better
for higher MySQL performance, based on your experience?
Thanks.
