The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk实用程序获取有关数据库表的信息，或检查、修复或优化它们。myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes).myisamchk用于MyISAM表（具有用于存储数据和索引的.MYD和.MYI文件的表）。

You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. 您还可以使用CHECK TABLE和REPAIR TABLE语句来检查和修复MyISAM表。See Section 13.7.3.2, “CHECK TABLE Statement”, and Section 13.7.3.5, “REPAIR TABLE Statement”.请参阅第13.7.3.2节，“CHECK TABLE语句”和第13.7.3.5节，“REPAIR TABLE语句”。

The use of myisamchk with partitioned tables is not supported.不支持在分区表中使用myisamchk。

Invoke myisamchk like this:像这样调用myisamchk：

myisamchk [options] tbl_name ...

The options specify what you want myisamchk to do. 这些options指定了您希望myisamchk执行的操作。They are described in the following sections. You can also get a list of options by invoking myisamchk --help.以下章节将对其进行描述。您还可以通过调用myisamchk -help来获取选项列表。

With no options, myisamchk simply checks your table as the default operation. 没有选项，myisamchk只是将您的表作为默认操作进行检查。To get more information or to tell myisamchk to take corrective action, specify options as described in the following discussion.要获取更多信息或告诉myisamchk采取纠正措施，请按照以下讨论中的描述指定选项。

tbl_name is the database table you want to check or repair. tbl_name是您要检查或修复的数据库表。If you run myisamchk somewhere other than in the database directory, you must specify the path to the database directory, because myisamchk has no idea where the database is located. 如果在数据库目录之外的其他位置运行myisamchk，则必须指定数据库目录的路径，因为myisamck不知道数据库的位置。In fact, myisamchk does not actually care whether the files you are working on are located in a database directory. 事实上，myisamchk实际上并不关心您正在处理的文件是否位于数据库目录中。You can copy the files that correspond to a database table into some other location and perform recovery operations on them there.您可以将与数据库表对应的文件复制到其他位置，并在那里对其执行恢复操作。

You can name several tables on the myisamchk command line if you wish. 如果你愿意，你可以在myisamchk命令行上命名几个表。You can also specify a table by naming its index file (the file with the .MYI suffix). 您还可以通过命名表的索引文件（后缀为.MYI的文件）来指定表。This enables you to specify all tables in a directory by using the pattern *.MYI. For example, if you are in a database directory, you can check all the MyISAM tables in that directory like this:这使您能够使用模式*.MYI指定目录中的所有表。例如，如果你在数据库目录中，你可以像这样检查该目录中的所有MyISAM表：

myisamchk *.MYI

If you are not in the database directory, you can check all the tables there by specifying the path to the directory:如果您不在数据库目录中，可以通过指定目录的路径来检查那里的所有表：

myisamchk /path/to/database_dir/*.MYI

You can even check all tables in all databases by specifying a wildcard with the path to the MySQL data directory:您甚至可以通过在MySQL数据目录的路径中指定通配符来检查所有数据库中的所有表：

myisamchk /path/to/datadir/*/*.MYI

The recommended way to quickly check all MyISAM tables is:快速检查所有MyISAM表的推荐方法是：

myisamchk --silent --fast /path/to/datadir/*/*.MYI

If you want to check all MyISAM tables and repair any that are corrupted, you can use the following command:如果要检查所有MyISAM表并修复损坏的表，可以使用以下命令：

myisamchk --silent --force --fast --update-state \
          --key_buffer_size=64M --myisam_sort_buffer_size=64M \
          --read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI

This command assumes that you have more than 64MB free. 此命令假定您有超过64MB的可用空间。For more information about memory allocation with myisamchk, see Section 4.6.4.6, “myisamchk Memory Usage”.有关使用myisamchk进行内存分配的更多信息，请参阅第4.6.4.6节，“myisamchn内存使用情况”。

For additional information about using myisamchk, see Section 7.6, “MyISAM Table Maintenance and Crash Recovery”.有关使用myisamchk的更多信息，请参阅第7.6节，“MyISAM表维护和崩溃恢复”。

warning: clients are using or haven't closed the table properly

myisamchk supports the following options, which can be specified on the command line or in the [myisamchk] group of an option file. myisamchk支持以下选项，这些选项可以在命令行或选项文件的[mysimchk]组中指定。For information about option files used by MySQL programs, see Section 4.2.2.2, “Using Option Files”.有关MySQL程序使用的选项文件的信息，请参阅第4.2.2.2节，“使用选项文件”。