Which Auto Repair Does Not Use Commision

optimize repairing mysql databases with mysqlcheck

In this tutorial, nosotros will testify y'all how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL. We will talk almost mysqlcheck which is a maintenance control-line tool that allows you to cheque, clarify, repair, and optimize MySQL/MariaDB tables and databases. Repairing MySQL database is not a complicated process, merely follow the steps below advisedly.

1. Check one table in the MySQL database

The following control will check the tabular array posts in the database web log:

$ mysqlcheck -c blog posts blog.posts                         OK

If your database is protected by a countersign add -u root -p at the end of the command:

$ mysqlcheck -c blog posts -u root -p Enter password: blog.posts                         OK

ii. Analyze all tables in a MySQL database

The post-obit command will bank check the table posts in the database blog:

$ mysqlcheck -a web log posts blog.posts                         OK

If the MySQL/MariaDB server is running on a remote host, add -h at the finish of the command:

$ mysqlcheck -a blog posts -h remotehost.com blog.posts                         OK

three. Optimize all tables in all MySQL database

$ mysqlcheck -o --all-databases blog.users note     : Tabular array does not support optimize, doing recreate + analyze instead status   : OK mysql.time_zone_transition_type                    Tabular array is already up to date

Tabular array does not support optimize, doing recreate + analyze instead means that we're doing OPTIMIZE on an InnoDB table that doesn't back up this option. When doing OPTIMIZE on an InnoDB tabular array it creates an empty tabular array, copies all rows from the existing table into to the new ane, deletes the quondam ane and renames the new table, and then runs Clarify on the table.
Tabular array is already up to appointment means that the table is already up to engagement and there is no need to check information technology.

4. Repair multiple MySQL databases

The post-obit command volition repair all tables in both blog and blog2 databases:

$ mysqlcheck -r --databases blog blog2

If you lot run into note : The storage engine for the tabular array doesn't support repair it means that y'all are doing REPAIR on an InnoDB.

v. Optimize and repair all tables in all MySQL databases

The post-obit command volition check all tables in all databases and if some table is corrupted it will automatically prepare it that table:

$ mysqlcheck --auto-repair -o --all-databases

6. Nigh used mysqlcheck arguments

`-c, --cheque`	Check table for errors.
`-a, --clarify`	Analyze given tables.
`-o --optimize`	Optimize the tables.
`-r, --repair`	Perform a repair that tin can set up almost anything except unique keys that are not unique.
`--machine-repair`	If a checked table is corrupted, automatically set up it. Repairing will exist done afterward all tables accept been checked.
`-A, --all-databases`	Cheque all the databases. This is the aforementioned as –databases with all databases selected.
`-B, --databases`	Procedure all tables in the named databases. With this pick, all name arguments are regarded as database names, not as tabular array names.
`--tables`	Overrides the –databases or -B pick such that all name arguments following the pick are regarded as tabular array names.
`-g, --cheque-upgrade`	Check tables for version-dependent changes. May be used with –motorcar-repair to correct tables requiring version-dependent updates.

Of grade, if you use one of our Optimized MySQL Hosting services, y'all can always contact and ask our skilful Linux admins (via chat or ticket) about repairing MySQL database and annihilation related to MySQL optimization and how to repair a corrupted database. They are available 24×seven and will provide data or assistance immediately.

PS. If yous liked this mail service on how to utilise mysqlcheck to optimize and repair all tables and databases in MySQL, please share it with your friends on the social networks using the buttons beneath or but leave a reply. Thanks.