[consulting] Performance Issues

[Christopher M. Jones]

Hi, Frank. Here's a free consultation:

Your server specs are relevant here, plus whatever else you might be 
running. I find that large sites need, depending on what other services 
are used, about 4G of RAM. I've see large, high traffic sites crash in 
2G, though those servers also ran varnish, and some other things.

You're half of the way there, if you know about the bad query. These 
often can be solved simply by adding an index on the offending table. 
Menu and taxonomy related tables are likely offenders.

I'm guessing you need to do both the above: increase your server's RAM 
and optimize tables.

On 10/22/2010 11:55 AM, Frank Nikola wrote:
>
>
> Hi,
>
> We are running a web site that is experiencing some intermittent
> performance issues and would like to hire a performance consultant to
> assist with troubleshooting and resolution.
>
> Our initial review of this issue is that the database server slows while
> processing a large query which in turn blocks other requests from the
> web server and then the web server hangs and is unresponsive (Apache
> processes quickly go through the roof in iowait). At this point we must
> log on the web server and restart the httpd service - it usually takes
> about 5-10 minutes to log on and restart the service because of the slow
> response time of the server.
>
> We have a web server and a MySQL database. The database is about 5GB in
> total size, with the bulk of that being Drupal nodes and search. Caching
> is in place with memcache and the database has been optimized for
> performance.
>
> At a high level here are some details regarding the site:
>
> - 340,000 nodes
>
> - 68,000+ forum topics
>
> - 220,000+ comments (mostly from forum topics)
>
> - 560,000+ visits per month
>
> - 740,000+ page views per month
>
> Please contact me for further details regarding this short term project
> and your availability.
>
> Thanks,
>
> Frank
>
>
>
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting