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: shamu...@gmail.com [mailto:shamu...@gmail.com] Sent: 21 April 2010 15:31 To: mysql@lists.mysql.com 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org