Many VHXN users are asking to optimize their database so today we have to discuss about the optimization. For the beginners handing the MySql is a dangerous work. The size of the database is very important to manage it easily. Optimization can reduce the size of our whole database. Optimization can’t delete the data but it does defragmentation for our database. As the database, getting older it can be deleted or added. This can provide the results in number of empty rows.

Optimization can be used to delete the “Overhead” and to give the results in better arrangement of data in our database. To open the MySql database using myphpadmin link in our hosting panel. Select database from the dropdown menu on the left. Then check for size mentioned under “overhead” column next to every table in the database. Ideally, an optimized database will have ZERO overhead.

Optimizing the database is quite easy but before optimizing, you have to backup your data. Choose one or all tables in your database and check for dropdown with label ‘with selected’ at the bottom. After that selecting, the Optimize Table is enough. So whenever we see the “Overhead” building we have to perform a quick optimization to keep the data intact.

[ Thank You ]