| 1 | | Thanks kawauso I have applied simple_groupby_modified_simpler.10964.diff but seems to have no effect on my large database. Mysqld still hogging CPU on hits to index.php. Can you confirm your patch will also work on WP v3.1 ? Or perhaps someone knows what version patch will work for v3.1? |
| | 1 | Eeek just read through this massive thread, apologies for changing version number. |
| | 2 | |
| | 3 | As mentioned in comment 73 by kawauso I applied query.php.r17522.diff. |
| | 4 | |
| | 5 | I was previously getting slow queries with long_query_time = 1 in my.cnf. I'm not anymore so that's good. However mysqld is still eating up CPU so I'm not sure what/where to look at next. Any suggestions? |
| | 6 | |
| | 7 | |