Shulou(Shulou.com)06/02 Report--

This article mainly introduces the methods of optimizing and cleaning up redundant data in wordpress database. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

How to optimize and clean up redundant data in wordpress database

Tip: please back up the database before cleaning to prevent accidents.

Through practice, it is found that as long as the execution of the following five statements in turn, you can clean up relatively clean. Especially for the wp_posts table, see how many records there are in this table. The number of records should be equal to the number of articles + pages you see in the background management interface.

DELETE FROM `wp_ posts`WHERE `wp_ posts`.`post _ content` =''; DELETE FROM `posts`WHERE `wp_ posts`.`post _ title` =''; DELETE FROM `posts`WHERE `post_ type` = 'revision';DELETE FROM `wp_ postmeta`WHERE `meta_ key` =' _ edit_lock';DELETE FROM `wp_ postmeta`WHERE `meta_ key` ='_ edit_last'

In addition, for a table not mentioned above, wp_commentmeta, this table is the spam record saved by the Akismet plug-in. If this table is not cleaned for a long time, you will find that it is much larger than other tables, so, like this table, my suggestion is to clear it regularly, and the SQL statement is as follows:

TRUNCATE TABLE `commentmeta` is all about the methods of optimizing and cleaning up redundant data in wordpress database. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.