In late 2019 we introduced a system that automatically fine-tuned low-level database settings for all our Managed WordPress Hosting customers. Back then, our auto-optimization routines would run once a week for each customer’s WordPress site, looking for ways to make its database operate more efficiently.
Now, automatic database optimization happens continuously, 24 hours a day.
The MariaDB/MySQL technology and its InnoDB storage engine use data caching to speed up responses to queries. Caches use up chunks of RAM, as do other database actions, like wrangling connections. By tweaking the settings for such processes on the fly, our automated optimization helps ensure customer databases are ready to handle the loads they can expect without gobbling up memory they don’t need.
Additional Tips for WordPress DB Optimization
It’s important to highlight that Kinsta’s automatic database optimization works at a low level and does not involve optimizing tables in the RDBMS. This means there are additional steps you can take to further optimize your WordPress database.
The database behind a WordPress site often ends up with a significant amount of unused records in a table known as wp_options. You might find data from long-removed plugins and themes in that table, taking up space and slowing responses to queries. That’s why we’ve got some tips on cleaning up wp_options auto-loaded data.
On top of this, Kinsta customers can run
wp db optimize on the command line of an SSH session, which copies and rebuilds database tables, loading all the valid records in index order for more efficient querying.
We Make Your WordPress Site Faster
When thinking about WordPress optimization, remember that your hosting platform can affect site performance. Kinsta’s Managed WordPress Hosting is powered by Google Cloud’s lightning-fast C2 and C3D virtual machines and its low-latency Premium Tier network.
Find a Managed WordPress Hosting package here at Kinsta that’s right for you.