Download our 28+ free optimization plugins for WordPress!  Click here

MySQL Optimize

  • change to InnoDB as much as possible
  • add index to wp_options autoload
  • delete unused tables from deleted plugins
  • delete unused options from wp_options
  • delete expired transients
  • delete duplicate indexes on any given table
  • ensure there is an index on all appropriate tables
  • check FULLTEXT only used when appropriate
Last modified:  14 Sep, 2017