Repairing and Optimizing MySql databases

A simple and effective command to repair and optimize MySql databases. Be careful though: if you optimize innodb tables and the server isn't set up so that each…

> Archived article from 2015, from the old nutellino.it: commands and versions may be out of date.

> Machine translation from Italian: the original is here.

A simple and effective command to repair and optimize MySql databases. Be careful though: if you optimize innodb tables and the server isn't set up so that each database has its own data files, you risk blowing up the size of the lbdata1 file

mysqlcheck -u root -pPASSWORDROOT --auto-repair --optimize --all-databases

🙂

~/archivio

$ cat ~/archivio/riparare-e-ottimizzare-database-mysql.md

WARNING: this file is from 2015.

I wrote it, but a me from a few years ago: it may no longer reflect what I think or what I can do.

NOTE: machine translation from Italian, the original is here.

Continue? [y/N]

y, read it anywayN, take me away