MySQL が盛大にクラッシュしたので myisamchk ユーティリティを使って修復する作業まとめ

mysql -u root -p

use hoge;
REPAIR TABLE posts;

+------+------+-----------+------+---------+-------+----------------------+--------------------------+
| Id   | User | Host      | db   | Command | Time  | State                | Info                     |
+------+------+-----------+------+---------+-------+----------------------+--------------------------+
|    2 | root | localhost | hoge | Query   | 61998 | Repair with keycache | REPAIR TABLE posts       |
| 1040 | root | localhost | NULL | Query   |     0 | NULL                 | SHOW PROCESSLIST         |
+------+------+-----------+------+---------+-------+----------------------+--------------------------+

myisamchk /データベースのパス/*.MYI

sudo find / -name '*posts*'
/var/lib/mysql/hoge/posts.frm
/var/lib/mysql/hoge/posts.MYD
/var/lib/mysql/hoge/posts.MYI

sudo myisamchk /var/lib/mysql/hoge/posts.MYI
Checking MyISAM file: /var/lib/mysql/hoge/posts.MYI
Data records:  111016   Deleted blocks:       0
myisamchk: warning: Table is marked as crashed and last repair failed
myisamchk: warning: 2 clients are using or haven't closed the table properly
- check file-size
myisamchk: warning: Size of datafile is: 13600153700       Should be: 13512913956
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: warning: Auto-increment value: 136262 is smaller than max used value: 136263
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4

sudo myisamchk -r -q /var/lib/mysql/hoge/posts
- check record delete-chain
- recovering (with sort) MyISAM-table '/var/lib/mysql/hoge/posts'
Data records: 111016
- Fixing index 1
MyISAM-table '/var/lib/mysql/hoge/posts' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

sudo myisamchk -r /var/lib/mysql/hoge/posts
- recovering (with sort) MyISAM-table '/var/lib/mysql/hoge/posts'
Data records: 43547
- Fixing index 1
Found link that points at 4195162663727884602 (outside data file) at 5311977880
- Fixing index 2
- Fixing index 3
- Fixing index 4
myisamchk: error: myisam_sort_buffer_size is too small
MyISAM-table '/var/lib/mysql/hoge/posts' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

sudo myisamchk -o /var/lib/mysql/hoge/posts

myisamchk