Dracoy,
I am in a similar situation and the sql below is causing my db to be shutdown:
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND
wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’)
ORDER BY wp_posts.post_date DESC LIMIT 0, 10
were you able to find out which plugin was running this sql?
Does anyone have a clue?