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