Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By kionae on
I recently launched a site using Drupal 6, and am finding it to be a huge resource hog. CPU is almost always at of very near 100% even when traffic is relatively low. Load average regularly rises to the 20s and 30s, sometimes going as high as 50 or 60. I've enabled eAccelerator and Memcache on the server, and they've helped, but the site is still nearly inaccessible during peak traffic times. It's not shared hosting, and has only one other site running on it (and as soon as I put the Drupal site into maintenance mode, load average and CPU usage drops back to normal, so it's definitely something in the Drupal site). Traffic rarely exceeds 10000 unique visitors a day.
There must be a bottleneck somewhere, but I just can't seem to find it. I've tried Devel, and pulled items with slow queries. I've tried disabling modules. I'm at a loss at this point. Can anyone point me in the right direction for diagnosing the problem?
Comments
enable drupal cache
You need to enable the Drupal cache, if you haven't already done this.
Only anonymous pages are cached, so it probably won't help if you have a lot of logged-in users.
Regards
John
wait, there is a module which might help you
Authenticated User Page Caching (Authcache) caches both anonymous and logged-in users.
Haven't tried it myself, just came across it when I was googling for Drupal caching solutions.
The module page is here -> http://drupal.org/project/authcache
hope it helps.
Caching is enabled, and most
Caching is enabled, and most of the traffic to the site is anonymous users. I'll look into Authcache, and see if it makes a difference, but it seems to me that the demand is entirely too high to begin with. I'm afraid adding more caching is just covering up the root cause.
How many concurrent users do
How many concurrent users do you have on your site? What kind of monthly unique visits do you get?
This will really tell us what kind of server is needed.
Arnold
Approximately 100,000 to
Approximately 100,000 to 110,000 unique visits per month (in a good month), concurrent users varies but can get up to 100 to 150 during peak traffic hours, mostly anonymous.
database lag?
Drupal needs a fast connection to a MySQL database. If there is any network latency, perfomance can be crippled because the latency is magnified because of the large number of ( small ) database queries involved in building up a web page.
Don't know if this is causing your problem, but running MySQL on the same server as your Drupal website might help?
MySQL Cache
You can also investigate whether the MySQL cache is enabled.
This is an external link which explains the process pretty well;
http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-m...
can u post a link?
can u post a link?
how many RAM do u have?
Database is already on the
Database is already on the same server, and query caching is enabled in mySQL. We've got 8GB of RAM on the server.
http://www.dailyillini.com
Do you have comments enables,
Do you have comments enables, but noting like CAPTCHA or Mollom? I just had this one one site... the comments table grew to over 80000 records and looks in it were grinding mysql to a halt with some queries taking over 300 seconds to complete. Check your MySQL slow query log.
--
Tom
www.systemseed.com - drupal development. drupal training. drupal support.