Hi Friends, Some days ago I was searching to optimize tips of database for wordpress blog and got so many tips to make it optimized and also got so many plugins to make it optimize and then finally I got one tip from wordpress codex for “Automatic Database Optimizing” and I was not aware of this thing before and might be you also not knowing this thing that WordPress providing functionality by which your database automatically repair periodically to optimize database.

So if you want to enable this functionality just open wp-config.php file exists in root of wordpress site and then simply added below line anywhere :

define('WP_ALLOW_REPAIR', true);

The script can be found at {$your_site}/wp-admin/maint/repair.php, So If you want to run it manually you can run it by go to http://www.yoursite.com/wp-admin/maint/repair.php.

Also Please Note: That this define enables the functionality, The user does not need to be logged in to access this functionality when this define is set. This is because its main intent is to repair a corrupted database, Users can often not login when the database is corrupt.

I hope this post helpful for someone. If you have any question then you can ask me anytime or post it in comment.

Also I am PHP Freelancer, Freelance PHP Developer having more than 4 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).