- Every time you save a new post or page, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copies of that post as revisions. Imagine if your posts or pages are long and big. It’s a huge number of bytes that is on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing unnecessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you might have 50MB database space wasted.
- Similar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click.
- WP-Optimize reports which database tables have overhead and wasted space. It also allows you to shrink and get rid of that wasted space.
I’m afraid that this is not possible. Please ensure that you make a backup of your entire database before using WP-Optimize for the first time, and when you upgrade to a major new version of it. We recommend UpdraftPlus.
The process for optimizing InnoDB tables before MySQL version 5.7 is, at default, ineffective as it essentially rebuilds the entire table. However MySQL version 5.7 or greater or MariaDB is fine as this is resolved and not affected. We know some hosting companies have a configuration that will allow for correct optimization before 5.7 but that’s few and far between. However, we have implemented an override option for the user as long as they are aware of the risks.
What is/are wp_commentmeta, wp_postmeta and all the other tables mentioned in the Table information tab?
These are the database tables in your WordPress install… To find out more see the WordPress codex here: https://codex.wordpress.org/Database_Description
This is very difficult to say as every site is different… Keep an eye on the Table Information tab and you will see how the data usage grows over time. Select an appropriate schedule based on your own site. There is no one size fits all in the is case.
This is a “how long is string?” sort of question. It depends completely on your site – how big it is, how many users interact on it, how long it has been running, and when you last optimised it. However, the savings and speed-ups can be substantial; it is always worth making sure that your database is optimized.
Over time your WordPress database accumulates extra data such as revisions and spam comments and many more.
Removing this unnecessary data from the database will help reduce your database size and speed up your site.
The process of optimization is the removal of these unwanted/old database entries and the reorganising of the remaining data and associated indexes.
Lazy loading is the technique of only loading parts of a web-page when it is visible to the user.
The parts, usually images or videos, are replaced by placeholder elements until they are needed.
The advantage of lazy loading is that the initial page load is much faster. Rather than waiting for everything on the page to load, the user can start viewing visible content quickly.
WP-Optimize gives a simple and easy method to set your images and videos to lazy load.
- Open the WP-Optimize Images tab
- Open the Lazy Load Images sub-tab
- From here, you can enable lazy loading for both Images and Videos/Iframes
If you need to disable lazy loading for certain images, videos or iframes just add no-lazy class to the specific HTML element.
For a detailed walk-through on how to use the WP-Optimize Database Cleaning feature, we put together a video that takes you through all the necessary steps:
Optimization Preview gives WP-Optimize Premium users the ability to preview, select and remove data and records available for optimization from the database. This preview process lets the user check the relevant data before running the optimization, which helps avoid mistakes such as removing potentially useful information.
- Open the WP-Optimize tab
- View the preview information (see arrow below) on what files are available to be optimized or deleted