[consulting] Performance Issues

[Frank Nikola]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20101022/66bdbdaf/attachment.html