I'd go with the 4G 4-core server. If you're running apache and a sensible OS, the extra cores can be helpful. So, unless you know you have a need for very large key buffers, 4G should leave the OS plenty for FS cache.
Not that I actually have a clue. I really just wanted to be the first to answer the original question. On 4/21/10 11:17 AM, "shamu...@gmail.com" <shamu...@gmail.com> wrote: > OK, let's get back to the original question. for a database like mine > (1.5GB), will 4GB or 8GB RAM make any difference performance wise? > > On Wed, Apr 21, 2010 at 10:04 AM, Johan Gant <johan.g...@groupgti.com>wrote: > >> I guess this is a DB list, but I strongly disagree with Johan's suggestion >> to avoid using Views or Taxonomy. The advantages far outweigh the >> disadvantages in most cases. >> >> >> -----Original Message----- >> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >> Meersman >> Sent: 21 April 2010 15:44 >> To: shamu...@gmail.com >> Cc: mysql@lists.mysql.com >> Subject: Re: More CPU or More RAM? >> >> Switch CMSes, you'll be better off. I have the pain of running Drupal, too. >> >> Your DB host is probably good enough, unless you're doing insane amounts of >> page views. What you need is Drupal optimisations. Here's just a few: >> >> - drupal keeps both it's sessions and cache in the DB. Change to memcache >> - the views module is horrible. Get rid of it and write your own queries >> - for pete's sake don't turn on the watchdog module, especially on debug. >> That, too goes in your db >> - avoid taxonomy - it does evil hiearchical queries >> >> et cetera ad nauseam :-) >> >> >> On Wed, Apr 21, 2010 at 4:31 PM, shamu...@gmail.com <shamu...@gmail.com >>> wrote: >> >>> 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. >>> >> >> >> >> -- >> Bier met grenadyn >> Is als mosterd by den wyn >> Sy die't drinkt, is eene kwezel >> Hy die't drinkt, is ras een ezel >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=shamu...@gmail.com >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
