Hi
I am having the same problem as the OP here: http://stackoverflow.com/q/2305534/485483
My CPU load goes up to 100+ thanks to a WP query like this one:
# Query_time: 8 Lock_time: 0 Rows_sent: 9 Rows_examined: 1705
SELECT SQL_CALC_FOUND_ROWS wordpress_posts.* FROM wordpress_posts WHERE 1=1 AND wordpress_posts.post_type = 'post' AND (wordpress_posts.post_status = 'publish') ORDER BY wordpress_posts.post_date DESC LIMIT 0, 9;
I'm trying to figure out what I can do about it. I now know how to create an index for a table, but there is already a multi-column index called "type_status_date" for the fields *post_type, post_status, post_date and ID*. Should I remove that index and add a new one for post_date only?
Does anyone else with a large Wordpress site add another Index and how make I SQL use it? USE INDEX (index_name) did not work for me. Pretty new to this...