[WordPress Tips] Instructions on how to delete unused tables in WordPress effectively – One of the causes affecting the performance of the Web site is the database, a database that is optimized for sure. Make sure that the page load speed will be significantly improved. If you are looking for an efficient way to optimize the database for WordPress source code then this is the article for you, you do not need to know SQL statements or interfere with SQL statements.
In the previous article about WordPress tricks, I showed you how to fix the AMP interface error according to Google’s standards so that you can create an SEO standard AMP interface with a beautifully designed interface. Continue in this article. I will show you how to optimize WordPress database by deleting unused tables in WordPress effectively.
Contents
Delete unused tables in WordPress
As you know when you install a new Plugin or theme on WordPress, it will automatically create some tables in the Database, but when you remove the Plugin or theme, some Plugins do not disappear and it remains. in the database this makes your database more and more! And you want to delete these tables but you are not familiar with SQL statements, let’s learn how to delete unused tables in WordPress effectively.
Note: Before performing the method of deleting redundant tables below, please backup the database before any data loss occurs, you can recover it!
To delete unused tables in the WordPress database you can use the plugin wpdbspringclean with this plugin your database will be thoroughly optimized. your plugin is neater (this is a Plugin that was updated more than 2 years ago, but when I use it on WordPress version 4.7.1 it still works well and gives the desired results, so I re-introduced it) .
Install plugin
First, go to this link to download the wpdbspringclean plugin for WordPress to your computer and install the plugin (if you don’t know how to install the plugin for WordPress, you can refer to the article on how to install the plugin for WordPress ) When the installation is complete, activate the Plugin and proceed to delete the unused table as follows.
Delete unused tables
You go to Menu Setting > click WPDBSpringClean , now the Plugin interface will appear with 2 main functions: Unused DB Tables and Optimize DB Tables . To delete redundant tables, select the Unused DB Tables function, then click the “Perform search” button to search for unused tables in the database.
After the search is complete, you will see the unused tables listed below, the rest is to select the tables and delete them . I don’t have a redundant table anymore) .
Database Optimization
To optimize the database, please select the function Optimize DB Tables > Click “Perform search” you can customize the specified search data.
After doing this, you will be listed the tables to be optimized , just select the table > click Optimize . Once done, your database will be cleaned up significantly (you can see an example below) .
As you can see the original database after I have backed up is nearly 5.8MB but after using the plugin my database is only close to 4.4MB so my database has been cleaned. more than 1.4MB is great, isn’t it?
Finally, if you find the article useful, please subscribe to my blog regularly to update the latest articles via Email – Thank you!
