Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Analyze Tables with "mysqlcheck" Command

By: FYIcenter.com

(Continued from previous topic...)

How To Analyze Tables with "mysqlcheck"?

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

(Continued on next topic...)

  1. What Tools Available for Managing MySQL Server?
  2. What Is "mysqld"?
  3. What Is "mysqladmin"?
  4. How To Check Server Status with "mysqladmin"?
  5. How To Shut Down the Server with "mysqladmin"?
  6. What Is "mysql"?
  7. How To Use "mysql" to Run SQL Statements?
  8. How To Show All Tables with "mysql"?
  9. What Is "mysqlcheck"?
  10. How To Analyze Tables with "mysqlcheck"?
  11. What Is "mysqlshow"?
  12. How To Show Table Names with "mysqlshow"?
  13. What Is "mysqldump"?
  14. How To Dump a Table to a File with "mysqldump"?
  15. What Is "mysqlimport"?
  16. How To Load Data Files into Tables with "mysqlimport"?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...