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:
- 580,000+ users
- 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
Comments
two questions
Beyond that, there are tons of people here who can potentially provide consulting so you should have good luck to fix it.
knaddison blog | Morris Animal Foundation
mysql
Hi,
Have you identified the problematic query? As suggested earlier mytop or show processlist can help. Is the
mysql query cache ( http://dev.mysql.com/doc/refman/5.1/en/query-cache-configuration.html ) turned on?
If there is a problematic query, I would advise looking into optimizing it ( adding more indexes, etc. ). If you are
using MyISAM there could be a possible table locking issue, MyISAM also lacks row cache meaning data is
cached at the OS level unlike InnoDB which does this within engine itself, so you may look into porting to InnoDB
as well.
dbtuner
get the dev version of http://drupal.org/project/dbtuner it should help with tuning your database.