- 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