List:General Discussion« Previous MessageNext Message »
From:Tom Worster Date:April 21 2010 6:21pm
Subject:Re: More CPU or More RAM?
View as plain text  
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, "shamubro@stripped" <shamubro@stripped> 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.Gant@stripped>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: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De
>> Meersman
>> Sent: 21 April 2010 15:44
>> To: shamubro@stripped
>> Cc: mysql@stripped
>> 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, shamubro@stripped <shamubro@stripped
>>> 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=1
>> 
>> 


Thread
More CPU or More RAM?shamubro@gmail.com21 Apr
  • Re: More CPU or More RAM?Johan De Meersman21 Apr
    • Re: More CPU or More RAM?shamubro@gmail.com21 Apr
      • Re: More CPU or More RAM?Johan De Meersman22 Apr
        • Re: More CPU or More RAM?Johan De Meersman22 Apr
    • RE: More CPU or More RAM?Johan Gant21 Apr
      • Re: More CPU or More RAM?shamubro@gmail.com21 Apr
        • Re: More CPU or More RAM?Perrin Harkins21 Apr
          • Re: More CPU or More RAM?shamubro@gmail.com21 Apr
      • Re: More CPU or More RAM?shamubro@gmail.com21 Apr
        • Re: More CPU or More RAM?Tom Worster21 Apr
          • Re: More CPU or More RAM?Rudy Lippan22 Apr
  • RE: More CPU or More RAM?Johan Gant21 Apr
    • Re: More CPU or More RAM?shamubro@gmail.com21 Apr
Re: More CPU or More RAM?shamubro@gmail.com21 Apr