Defragment and Optimize MySQL and MariaDB Databases

Bilgi Bankası

If your MySQL or MariaDB install has been a bit sluggish, chances are your databases or tables are defragmented. This happens over time and is completely normal but causes MySQL or MariaDB to become slow as the software needs to located the information on the disk that is no longer close together. Just like a computer drive that has data fragmented over time, the same thing happens to databases. To fix this, we optimize and defragment the tables. This will move all the data so that it is closer together on the hard drives resulting in faster read and write times.

As root, run the following command to automatically optimize, repair, and defragment your MySQL or MariaDB tables and databases:

mysqlcheck -u <username> -p --auto-repair --optimize --all-databases

Be sure to replace <username> with the root username you installed MySQL as. You will be prompted for the password to enter securely so it is not available when running the history program. This command will work with any Linux system running either MySQL or MariaDB. If you are a enterprise managed VPS customer, Mean Servers does this procedure free of charge for you on request, just open a support ticket requesting a MySQL defragmentation!

Bilgi Bankası

Kategoriler

Kategoriler

İlgili diğer dökümanlar

Etiket Bulutu

Destek

Bilgi Bankası

Kategoriler

Kategoriler