How to optimize a MySQL database?

MySQL is a great database type but the truth is that it is not smart enough to clean itself up the way it should. This is why manual optimization is always a great addition you can make to it.

To optimize a MySQL database or a certain table, log into your 

cPanel -> phpMyAdmin and select the database which tables you wish to optimize.

A list with all the database’s tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.

From the With selected drop-down menu choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.

 

Should you experience any difficulties you can always contact our 24/7 Support Team who will gladly help you out with them.

  • 0 کاربر این را مفید یافتند
آیا این پاسخ به شما کمک کرد؟

مقالات مربوطه

What is php.ini?

Php.ini is one of the essential configuration files in PHP. When PHP starts, this is the file it...

Do you have any setup or hidden fees?

UniqueVPS does not charge any additional or hidden fees. All web hosting solutions, extra...

How many subdomains can I create with UniqueVPS?

You are free to create as many subdomains as you wish and install different site-building...

What is a subdomain?

A subdomain is a domain name that is part of a main domain. It might be a separate website with...

How to access the phpPgAdmin to manage my PostgreSQL?

Accessing phpPgAdmin is very straightforward. It is neatly located in every customers’ cPanel but...

Powered by WHMCompleteSolution