How to optimize database?
Database Optimization
Repair Database if your database is corrupted

Database optimization is required to increase the speed of our application, however database optimization is not easy and we have to careful when we optimize any database.

if you are using the wordpress for your web-site then its really easy to optimize your wordpress database. as you know that wordpress is open source and there is lots of plugin which we need to install to get the functionality. same way there is one plugin named ‘Automatic Database Optimizing’ which you need to install and your database optimization will be done very quick and with accuracy.

Automatic Database Optimizing plugins also repair your database periodically, you just need to insert one line code in your wp-config.php which is located where you install wordpress blog. please insert below code at the end of the wp-config.php file.

define('WP_ALLOW_REPAIR', true);
?>

if you forgot this and your database is corrupted then you can run the code manually as the file is located at /wp-admin/maint/repair.php. so if your site name is www.freelancephpdevelopment.com then you need to run the code like www.freelancephpdevelopment.com/wp-admin/maint/repair.php.

I Hope this will helpful to you.