How to optimise your WordPress database

As your site grows, you add posts and pages - your WordPress database will also grow - containing previous versions of posts and pages as well as other 'transient' data. All of this extra weight in the database can slow your site, so it's a good idea to give it a regular clean.

The easiest way to do that is by using a plug-in - we suggest WP-Optimize (external link opens in a new window).

Please be sure to only enable and use the Database Optimisation part of this plug-in - we recommend using the LiteSpeed Cache plug-in for your site caching and image optimisation.

Please also note that this is a third-party plug-in and our suggestion of use here is in no way an endorsement. You should ensure you have good backups of your site in place before using any tool that makes changes to your site/database.
  1. Install the WP-Optimize plug-in
    Plugins > Add New > Search 'wp-optimize' > Click Install Now
    Once installed click Activate
  2. Click WP-Optimize in the left hand menu.
    You'll see the Database optimisation screen.
    Click the Run all selected optimizations button to complete the process.
  3. It is possible to perform additional optimisations - but please note the warning at the bottom of the screen. Please ensure you have reliable, working backups in place before performing these tasks.
  4. You can schedule these basic optimisations to run regularly by clicking the Settings tab and then checking the Enable scheduled clean-up and optimization (Beta feature) box.
    We would only ever recommend optimising the database tables manually after ensuring you have reliable, working backups.
  5. Help and Support for the plug-in and its features is offered by the plug-in author and can be found under the Help tab.

How did we do?

Powered by HelpDocs
© Krystal Hosting Ltd 2003–2019