How to Repair and Optimize Database for Website performance?

People with unoptimized database always face slow website response and performance. Below are the steps to repair and optimize MySql databases.

It is recommended that it should be done atleast one in a week.

1. Login to cPanel

2. Click on the phpMyAdmin button in the Databases section.

3. Select the database you want to optimize and repair from the list in the left column, which should take you to the "structure" tab for the database.

4. Select the tables you wish to optimize by checking the check box in front of each one, or clicking on Select All if you want to optimize all of them.

5. On the drop down box that says "with selected..." select "Repair Table."  This will repair the table and take you to a new screen.

6. Again do step 3 to 5 and on the drop down box that says "with selected..." select "Optimize Table."  This will optimize the table and take you to a new screen.

Was this answer helpful?

 Print this Article

Also Read

URL Redirect/Rewrite using the .htaccess file

Summary By default your website can be accessed with both www.example.com and example.com....

cPanel Exim How To Clear The Mail Queue

Here’s the proper way to clear the exim mail queue on a cpanel server. /etc/init.d/exim...

FTP - Uploading the Website

There are many ways that you can transfer files and folder to and from your hosting account. We...

Unable to see my website

We have sometime receive clients complain of server not reachable, while their IP are blocked by...

How can I limit the number of emails a domain can send out per hour?

Click on the "Tweak Settings" link under "Server Setup". Within the "Mail" section is a text box...

Powered by WHMCompleteSolution