Skip to content

Instantly share code, notes, and snippets.

@nojimage
Created November 5, 2009 09:28
Show Gist options
  • Save nojimage/226930 to your computer and use it in GitHub Desktop.
Save nojimage/226930 to your computer and use it in GitHub Desktop.
mt4-mysql-analyze-tables
ANALYZE TABLE mt_as_ua_cache;
ANALYZE TABLE mt_asset;
ANALYZE TABLE mt_asset_meta;
ANALYZE TABLE mt_association;
ANALYZE TABLE mt_author;
ANALYZE TABLE mt_author_meta;
ANALYZE TABLE mt_blog;
ANALYZE TABLE mt_blog_meta;
ANALYZE TABLE mt_cacheblock_cache;
ANALYZE TABLE mt_category;
ANALYZE TABLE mt_category_meta;
ANALYZE TABLE mt_comment;
ANALYZE TABLE mt_comment_meta;
ANALYZE TABLE mt_config;
ANALYZE TABLE mt_entry;
ANALYZE TABLE mt_entry_meta;
ANALYZE TABLE mt_field;
ANALYZE TABLE mt_fileinfo;
ANALYZE TABLE mt_ipbanlist;
ANALYZE TABLE mt_log;
ANALYZE TABLE mt_notification;
ANALYZE TABLE mt_objectasset;
ANALYZE TABLE mt_objectscore;
ANALYZE TABLE mt_objecttag;
ANALYZE TABLE mt_permission;
ANALYZE TABLE mt_placement;
ANALYZE TABLE mt_plugindata;
ANALYZE TABLE mt_profileevent;
ANALYZE TABLE mt_profileevent_meta;
ANALYZE TABLE mt_role;
ANALYZE TABLE mt_session;
ANALYZE TABLE mt_tag;
ANALYZE TABLE mt_tbping;
ANALYZE TABLE mt_tbping_meta;
ANALYZE TABLE mt_template;
ANALYZE TABLE mt_template_meta;
ANALYZE TABLE mt_templatemap;
ANALYZE TABLE mt_touch;
ANALYZE TABLE mt_trackback;
ANALYZE TABLE mt_ts_error;
ANALYZE TABLE mt_ts_exitstatus;
ANALYZE TABLE mt_ts_funcmap;
ANALYZE TABLE mt_ts_job;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment