List:General Discussion« Previous MessageNext Message »
From:shamubro@gmail.com Date:April 21 2010 2:52pm
Subject:Re: More CPU or More RAM?
View as plain text  
Thanks Johan,

Unfortunately I run into all 4 issues you have mentioned. And the views is
my huge part of my site.

I got about 50k-60k page view per day, about 40k nodes. It is really a pain
to make drupal run fast. I feel drupal query the db tooooooo much.

I understand I can get some performance boost by writing my own code, find
replacement etc, but that costs me too much if I can use hardware to solve
the same problem. and Yes I know I will run to same problem again when the
site grows to some point.

I will definitely try your advice, such as memcache. Thanks!

If anyone else has more advice on the 2 server options,  please let me know.

On Wed, Apr 21, 2010 at 9:43 AM, Johan De Meersman <vegivamp@stripped>wrote:

> 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
>

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