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 <[email protected]> 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: [email protected] [mailto:[email protected]]
> Sent: 21 April 2010 15:31
> To: [email protected]
> 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/[email protected]
>
>
