No, @vfvalent's issue is a different one--it's a boneheaded bug I introduced in 2.0.5. @vfvalent, if you email me I'll send you a development version which fixes that bug. My apologize. It will be released soon as 2.0.6, in case you don't mind waiting a couple days.
@wohlfordba - I see... it's just copying to a temporary table as one of the join gets too big, not because I use a
create temporary. Could you try running this query?
explain SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('payday loans loan interest lending ohio state lenders capped people states % rate ? financial 36% industry close cap cost')) as bodyscore, (MATCH (post_title) AGAINST ('ohio lenders payday crackdown')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) AS tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) AS catscore, ((MATCH (post_content) AGAINST ('payday loans loan interest lending ohio state lenders capped people states % rate ? financial 36% industry close cap cost')) * 1 + (MATCH (post_title) AGAINST ('ohio lenders payday crackdown')) * 1 + COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1 + COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) AS score
FROM wp_posts left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 499 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 499 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) && ID != '499') and post_password ='' and post_type IN ('post') GROUP BY id having score >= 5 order by score DESC limit 5
This will give me some information on why this query is slow and how large the intermediate joins are.