Analyze Tables with "mysqlcheck" Command in MySQL

Q

How To Analyze Tables with "mysqlcheck" in MySQL?

✍: FYIcenter.com

A

If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database:

>cd \mysql\bin
>mysqlcheck -u root --analyze mysql
mysql.columns_priv              Table is already up to date
mysql.db                        Table is already up to date
mysql.func                      Table is already up to date
mysql.help_category             Table is already up to date
mysql.help_keyword              Table is already up to date
mysql.help_relation             Table is already up to date
mysql.help_topic                Table is already up to date
mysql.host                      Table is already up to date
mysql.proc                      Table is already up to date
mysql.tables_priv               Table is already up to date
mysql.time_zone                 Table is already up to date
mysql.time_zone_leap_second     Table is already up to date
mysql.time_zone_name            Table is already up to date
mysql.time_zone_transition      Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user                      Table is already up to date

 

What Is "mysqlshow" Command in MySQL

What Is "mysqlcheck" Command in MySQL

Administrator Tools for Managing MySQL Server

⇑⇑ MySQL Database Tutorials

2018-02-28, 1903🔥, 0💬