Keep WordPress database leaner by removing autoloaded options from wp_options table
In WordPress a number of autoloaded options are loaded on every page, this gathers over time with deleted themes, plugins etc and can slow down a site. Typically most options that are installed in the database are permanently stored. These options which are autoloaded are loaded on very WordPress page. To see the total size…
Read MoreUsing wp-cli commands to create and import WordPress databases
You can use wp-cli to do a number of tasks around the WordPress database including creation and importing, below are a few commands and what they do. Remove all existing WordPress tables wp db reset This will remove all existing WordPress tables and leave the db empty, but you still have a db. Delete the…
Read MoreChange and Update WordPress URLS in Database When Site is Moved to new Host
After migrating a WordPress site to a new URL either to a live production site or a testing development server, the new URL strings in the MySQL database need to be changed and updated in the various MySQL database tables. This method just uses the whole MySQL database rather than a WordPress export/import from within and…
Read MoreOptimise wp_postmeta table and remove custom fields meta keys
Overtime a wp_postmeta WordPress database table may become bloated and use redundant custom field meta_keys. The table may have thousands of rows worth of dead data such as old custom fields. You can remove these keys quite quickly in the MySQL database once you know the key format, I recently took over a site that previously…
Read MoreFind out how many database queries per pageload in WordPress
To find out how many WordPress mysql database queries a page requests and how long it takes the page to load whilst querying the database, you can add in a PHP function to a WordPress hook to find out. This can be displayed in either the source code of the html or rendered on the…
Read More