Monday, August 11, 2008

Configuring MySQL - LAMP for Drupal

A Benchmarking exercise for Solr search and Drupal 6 search for a search intensive website is underway. We have encountered many Mysql issues while populating the database and scaling concurrent users.

We have identified and configured most MySql parameters, we are still stuck with the slow query problem.

The Slow Query problem is more prominent in the mixed transaction Scenario. We need to identify which of the transactions is causing this problem and analyze the query.

Some of the unresolved issues in Benchmarking exercise:

- Configuring InnoDb

- Understanding all Mysql parameters

- Cause of slow queries

More about the problems faced at

No comments:

Post a Comment

Search This Blog

Chennai Drupal Community - Community plumbing

Shyamala's Drupal SEO