How To Optimize Your WordPress Database

I am looking at a number of WordPress plugins to optimize my databases.  I did run across the WordPress method of optimizing a database.

First backup your database.

http://yourdomain.com/wp-admin/maint/repair.php

Click on the Repair Database button to have WordPress internally executes two SQL queries on each WordPress database table: CHECK TABLE and REPAIR TABLE

Click on the Repair and Optimize Database button to have WordPress internally executes the two SQL queries above and two additional SQL queries on each WordPress database table: ANALYZE TABLE  and OPTIMIZE TABLE

I hope this improves my WordPress performance.

Leave a Reply