peps974

Hey guys,
I have found that in another post but I tried to run it and it doesn’t seem to end. ANyone has found a nice, sleek mysql query for that purpose (bulk delete of unused tags):

SELECT * FROM wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id
INNER JOIN wp_term_relationships wtr ON wtr.term_taxonomy_id=wtt.term_taxonomy_id
LEFT JOIN wp_posts wp ON wp.ID=wtr.object_id
WHERE
taxonomy='post_tag'
AND ID IS NULL
AND NOT EXISTS(SELECT * FROM wp_terms wt2
                INNER JOIN wp_term_taxonomy wtt2 ON wt2.term_id=wtt2.term_id WHERE wtt2.parent=wt.term_id)

ORDER BY name

Hi mate,
I would be really interested to hear on what you did to improve those ‘slow mysql queries’.
The site I manage goes to about ~15K to 20K pageviews daily and it seems to go ok usually, but if we break a big story and there is a massive spike, the site goes down (even though we run WP_Super Cahce) & the sql db clogs up; the hosting admin has to restart the mysql process.

Any tips?