Introduction of Mysqlcheck
The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables.
Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD
Mysqlcheck: the mysqlcheck client can check and repair the MyISAM table. It can also be optimized and analyzed.
The function of mysqlcheck is similar to that of myisamchk, but it works differently. The main difference is that mysqlcheck must be
The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables.
Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD server has to use Mysqlcheck
The Mysqlcheck client tool can examine and fix myisam tables, and can also optimize and analyze tables.
In fact, it integrates the functions of check, repair, analyze, optimize in MySQL tools,
There are 3 different ways to invoke Mysqlcheck:
MySQL has 3 different ways to invoke Mysqlcheck:
shell> mysqlcheck[options] db_name [tables]Shell> Mysqlcheck[options]---database DB1 [DB2 DB3 ...]Shell> Mysqlcheck[options]--all--databaseIf you do not specify any tables or use the---database
Mysqlcheck is a tool that MySQL comes with, the function is the 保养 table, actually is examines, analyzes, fixes and optimizes. Here's an introduction to the simple use of the Mysqlcheck tool, the official documentation here
Original URL:
MySQLDatabaseMysqlcheckThe usage of mysqlcheck is the content we will mainly introduce in this article. We know that mysqlcheck is a mysql-provided mysql table that can be checked and repaired, and it can also be optimized and analyzed, the function
mysql database Mysqlcheck The use of knowledge is the main content of this article, we know, Mysqlcheck, is the MySQL comes with can check and repair MyISAM table, And it can also optimize and analyze tables, mysqlcheck functions like Myisamchk, but
I. OverviewThe Mysqlcheck client tool can examine and repair MyISAM tables, and can also optimize and parse tables. In fact, it integrates the Check,repair,analyze,optimize functionality in the MySQL tool, does not support memory tables for check,
0x001 Issue BackgroundMySQL executes the relevant MySQL command (we performed, show procedure status) When prompted Mysql.proc table crashed, cannot be repaired (marked as crashed and last (automatic?) Repair failed)Error message: MySQL table is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.