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

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...

FTP - Uploading the Website

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

Webamail Access

How to log into webmail Webmail is a great feature offered by cPanel. You can access email from...

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...

cPanel addon domain creation: ‘The domain already exists in the Apache configuration.’

Scenario: We might get an error when adding an addon or parked domain via cPanel. The domain...