It is always good practice to optimize your blog’s database to improve blog’s performance. Many are not aware about WordPress’s built-in database repair and optimize functionality, as it is not available in admin back-end.
You can check this by visiting http://yourdomain.com/wp-admin/maint/repair.php (replace http://yourdomain.com/ with your actual blog/site url ).
Below is a step by step guide on how to optimize WordPress database :
- First login to admin section of WordPress blog by visiting http://yourdomain.com/wp-login.php .
- Then go to http://yourdomain.com/wp-admin/maint/repair.php .You can see screen as show below. It ask you to add a line of code to WordPress’s wp-config.php file.
- Add below code to your WordPress wp-config.php file and reload/refresh page.
- After refreshing you can see page with options to ‘Repair Database’ and to ‘Repair and Optimize Database’. Just click on one of the option.
- If you click on ‘Repair Database’ button, WordPress can automatically look for some common database problems and repair them. Internally it executes two sql queries on each WordPress database tables in loop and these queries are CHECK TABLE table_name and REPAIR TABLE table_name .
- If you click on ‘Repair and Optimize Database’ button, WordPress can also attempt to optimize the database. This improves performance in some situations. Repairing and optimizing the database can take a long time and the database will be locked while optimizing. Internally it executes four sql queries along with above two queries on each WordPress database tables in loop and other two queries are ANALYZE TABLE table_name and OPTIMIZE TABLE table_name .
define('WP_ALLOW_REPAIR', true);
Hope this will improve your WordPress blog’s performance. Drop in your comments!
(P.S. : Please take backup of your WordPress database before making any action on database)
7 replies on “Repair and optimize WordPress database”
Do I need to remove
define('WP_ALLOW_REPAIR', true);after optimizing?@Renji its not necessary to keep define(‘WP_ALLOW_REPAIR’, true); you can remove it once you done with optimization.
[…] Once you do that, you’ll see dual options on that page: correct database, correct and optimize database. Simply click the choice of your choice and WordPress will do the rest. If you’re looking for a step-by-step beam on this, you can find it on WPveda. […]
which is the best way to optimize wordpress, phpmyadmin or using your tutorial??
both are options and not the optimization utility. using both option you can perform the same operation, as mentioned in post
1. CHECK TABLE
2. REPAIR TABLE
3. ANALYZE TABLE
4. OPTIMIZE TABLE
Thanks! i did it but there is still something wrong on my database… subscribers can not see their profile, they get an error message telling that they don’t have enough privileges to see the page… any idea of what maybe the problem?
Thanks for showing me how to do this. Valuable. Im surprise WP admin doesn’t have a button to do this. I never knew it existed.
Cheers
Brendan