Basic WordPress Hygiene
In the examples we have used the standard wp_ prefix for table names, this may differ between databases.
1. Options table
When the options table is big, it can benefit from having an index on the autoload column.
ALTER TABLE 'wp_options' ADD INDEX ('autoload');
2. Post meta table
The post meta table is actively in use by the ACF (Advanced Custom Fields) plugin, and may result in queries that select data by value. There is no index on this column by default.
ALTER TABLE 'wp_postmeta' ADD INDEX 'sbpmv' ('meta_value'(10));
3. Database maintenance
WordPress triggers wp-cron all to often on high traffic sites, and it should be configured as a normal cron job on server.
Go to your site's Servebolt admin and set up the cron job to run directly from php:
*/5 * * * *
cd /path/to/your/host/public/; /usr/bin/php /path/to/your/host/public/wp-cron.php
Health / Performance Checklist
Make sure there are no plugins that compress content (that will make WordPress PHP compress it, apache pagespeed decompress it and recompress it, and nginx to decompress and compress it). Nginx compresses output automatically for all relevant
- Check log files for Errors
- Check that there is no extensive logging (wp-logging etc)
Check .htaccess file for directives overriding normal server config (change cache policy, compression etc)
- Amplification requests
- Settings on Servebolt - static caching of elements