https://dev.mysql.com/multiple-server-clients.html
If you normally use a specific socket file or port number, you can place commands to set these environment variables in your .login file so that they apply each time you log in. Start the client with --protocol=TCP to connect using TCP/IP, ...
https://dev.mysql.com/myisam-check.html
This may take a long time for a large table that has many indexes. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. What it cannot find is corruption that involves only the data file (which is ...
https://dev.mysql.com/myisam-key-cache.html
To make this choice easier, the key cache module maintains all used blocks in a special list (LRU chain) ordered by time of use. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems.
https://dev.mysql.com/myisam-repair.html
Stage 1: Checking your tables Run myisamchk *.MYI or myisamchk -e *.MYI if you have more time. The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR ...
https://dev.mysql.com/myisam-start.html
If the repair fails because of an error in the data file (for example, a duplicate-key error), the server tries again, this time re-creating the data file. The following options to mysqld can be used to change the behavior of MyISAM tables.
https://dev.mysql.com/myisam-table-maintenance.html
With myisamchk, you must make sure that the server does not use the tables at the same time so that there is no unwanted interaction between myisamchk and the server. This section discusses how to use myisamchk to check or repair MyISAM tables ...
https://dev.mysql.com/myisamchk-other-options.html
(The first time you use this option to sort a table, it may be very slow.) To determine a table's index numbers, use SHOW INDEX, which displays a table's indexes in the same order that myisamchk sees them. myisamchk supports the following options ...
https://dev.mysql.com/myisamchk-repair-options.html
myisamchk supports the following options for table repair operations (operations performed when an option such as --recover or --safe-recover is given): --backup, -B Make a backup of the .MYD file as file_name-time.BAK --character-sets-dir=dir_name ...--data-file-length=len, -D len The maximum length of the data file (when re-creating data file when it is ...
https://dev.mysql.com/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/myisamlog.html
This option can be given multiple times to produce more and more output. To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: shell> myisamlog [options] [file_name [tbl_name] ...] The default ...
