wordpress_optimize_tables.sql

DELETE
  FROM wp_posts
WHERE post_type = 'revision'
  AND post_date < NOW() - INTERVAL 90 DAY;

DELETE
  FROM wp_postmeta
WHERE post_ID NOT IN (SELECT
    ID
  FROM wp_posts);

DELETE
  FROM wp_term_relationships
WHERE object_id NOT IN (SELECT
    ID
  FROM wp_posts);

DELETE
  FROM wp_comments
WHERE comment_post_ID NOT IN (SELECT
    ID
  FROM wp_posts);

DELETE
  FROM wp_commentmeta
WHERE comment_id NOT IN (SELECT
    comment_id
  FROM wp_comments);

OPTIMIZE TABLE wp_commentmeta, wp_comments, wp_links, wp_options, wp_postmeta, wp_posts, wp_term_relationships, wp_term_taxonomy, wp_terms, wp_usermeta, wp_users