List:General Discussion« Previous MessageNext Message »
From:shamubro@gmail.com Date:April 21 2010 3:02pm
Subject:Re: More CPU or More RAM?
View as plain text  
It seems all Johans are interested on this topic. :D

Thank Johan.

My web server (apache 2) is on the same server. And it looks good to me.

I have no custom module. The most often used modules are CCK, Views and
WebForm. OK my server does send out some mails every day, about 10K.

I tried to enable slow query logs before, but the slow queries are not
limited to some particular queries, it is pretty ramdom, sometimes a single
"select url from url_alias where nid = xxx" took long time.

My current host uses XEN VPS. It is not bad, but I feel the DISKIO is my
bottle neck.
this is a common top output from my server

top - 11:01:09 up 18 days, 16 min,  5 users,  load average: 2.06, 1.97, 2.07
Tasks: 137 total,   1 running, 135 sleeping,   0 stopped,   1 zombie
Cpu(s):  8.8%us,  4.2%sy,  0.0%ni, 86.9%id,  0.1%wa,  0.0%hi,  0.0%si,
0.0%st
Mem:   1452792k total,  1175924k used,   276868k free,    67220k buffers
Swap:   524280k total,     6652k used,   517628k free,   738012k cached
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
18347 mysql     20   0  412m 145m 4556 S   47 10.3  30:19.96 mysqld
22141 apache    20   0  162m  28m  18m S    0  2.0   0:00.84 httpd
22067 apache    20   0  162m  27m  17m S    0  1.9   0:01.15 httpd
22110 apache    20   0  162m  26m  17m S    0  1.9   0:00.87 httpd
and this is from iostat

Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
xvda            623.50         0.00         6.12          0         12
xvdb              0.00         0.00         0.00          0          0
avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          19.48    0.00   16.93   20.32    0.08   43.18
Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
xvda            590.50         0.00         7.95          0         15
xvdb              0.00         0.00         0.00          0          0
avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          25.22    0.00   27.61   29.43    0.19   17.55
Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
xvda            468.00         0.00        13.11          0         26
xvdb              0.00         0.00         0.00          0          0


On Wed, Apr 21, 2010 at 9:47 AM, Johan Gant <Johan.Gant@stripped> wrote:

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