Remove Unused Database Tables

How to Delete Unused Database Tables in WordPress

In Plugin Problems by Fathi Arfaoui0 CommentsLast Updated: April 20th, 2018

No matter how you’re optimizing your WordPress website, and what you’re doing to make it clean, and well coded, if you have lots of database tables, things will be complicated in the end. The most important factor in the modern web crawling is the speed of your web page, for that reason, you don’t have a choice other than optimizing your database for better crawling and faster loading time.

In today’s post, I’ll show you the easiest way to remove the database tables that you don’t need in WordPress. These tables and data are stored in plugins or themes you’ve installed and removed previously. So, after that, the tables still there in the MySQL database without any reason or benefit, it’s a junk data that slows down the website or the blog.

Removing unused tables in WordPress

To get started, you need to install a great plugin from the WordPress’s official plugins directory, it’s called “WPDBSpringClean“. Don’t worry about the last plugin update, it works with the latest WordPress version at this time and it will easily scan your entire database for unused tables.

Also, you can install the plugin from your WordPress dashboard, just click on “Plugins”, then, “Add New” and type the plugin’s name in the search box. You’ll find it and you only need to click on “install”.

After installing and activating the plugin, you’ll find its menu under the “Setting” menu in your WordPress admin area.

Now, click the “Perform Search” button as it looks like the next screenshot.

Delete Unused Database Tables in WordPress


Next, wait a few moments, or even minutes if you have a large website size, and then, you’ll get a list of the unused tables that are in your WordPress database.

Now, check all the tables, select “delete, and click the “apply” button as the following screenshot.

Remove database tables from uninstalled plugins


Finally, the tables will be removed completely from the database. That means a lot in terms of speed and optimization and you’ll save a lot of time and effort looking for ways to get rid of the junk data on your blog.

Related:  How to Repair Corrupted WordPress Database Tables Using phpMyAdmin

The WordPress database size matters

In WordPress, as any other PHP and MySQL software, the execution time in the server is what makes the difference in the page loading time. As a result, the Google crawlers will be able to reach the files faster and understand them better, that means a huge impact on SEO and ranking in the SERP.

In other words, when you have a database that’s not optimized and full of junk data, the website will load slower, and Google crawlers won’t be able to understand your content well because of the long crawling time, and also, because of the errors that can be found.

The more options you add on your website, the more problems you’ll cause. If you have multiple plugins, for example, that work for multiple functions, you can combine them all into a single tool. That’s the case of the JetPack WordPress plugin that does a great job. It does multiple jobs at once and you’ll save lots of time managing multiple plugins with their settings and update when you have this trusted tool.

Optimizing your database is not enough in these days, you need to focus on images and the files you’re sharing. Just make sure to use the exact image dimensions of your website layout to avoid large file sizes for nothing. Also, ensure the quality of plugins you’re installing, the same thing applies to themes. You can find reviews about any WordPress tool online. That will save a lot of time and effort, but also, it will make your site clean from junk files that no one use.

Leave a Comment