WordPress database redundancy? Quick Use optimization plugin WP clean up

WordPress is a PHP language and MySQL database development of the Open source blog system, it has a very powerful extension capabilities. But with the increase in content, the use of WordPress, a drawback is increasingly reflected: the redundancy of the database.

When WordPress writes articles, it defaults to saving revisions and drafts every once in a while. If we write an article about half an hour, in this half an hour, enough for WordPress to generate a lot of redundant data, and then slowly drag down the database. Many webmaster friends respond to WordPress used a long time after why the database capacity becomes very large? Or why is WordPress turning on slowly? such problems, in fact, the culprit is due to the WordPress data redundancy caused.

　　There are many ways to solve such problems , in some WordPress tutorial network will teach webmasters to enter the MySQL database, delete the corresponding table data. Small series that this method is suitable for the WordPress data table has a certain understanding of people, not suitable for the public. Here a small series to recommend a plug-in: WP clean up, download the address:

http://wordpress.org/extend/plugins/wp-clean-up/.

Install this plug-in, the background enabled, click "Set"-> "WP clean up" into the operating interface.

Here you can easily delete the "revision", "Draft", "" Automatic Draft "," Pending Review "," Spam Review "," Recycle Bin comment "These useless data, can be deleted or click the" Remove all "button One key delete all useless data; the second table function is to optimize the database, Here you can optimize all the tables in the database, this function is the same as the "phpmyadmin" effect in the phpMyAdmin, so that you don't have to do it.

Of course, WordPress's revisions and drafts are not entirely without merit. If you accidentally close the page when you write an article, the draft will work. As for the revised version, because WordPress is developed by foreigners, it may be more attention to detail and logic.