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.g...@groupgti.com> 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: shamu...@gmail.com [mailto:shamu...@gmail.com] > Sent: 21 April 2010 15:31 > To: mysql@lists.mysql.com > 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=shamu...@gmail.com > >