今天有张表突然打不开了 提示要修复下
/usr/local/mysql/bin/myisamchk -r -f Run_Cache.MYI - recovering (with sort) MyISAM-table 'Run_Cache.MYI' Data records: 0 - Fixing index 1 myisamchk: error: myisam_sort_buffer_size is too small MyISAM-table 'Run_Cache.MYI' 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 |
Run_Cache.MYI 有110M 因为mysql不能重启不能修改参数
用SET GLOBAL myisam_sort_buffer_size=1342177280000; 修改了也没起效果
只能把参数直接接后面
/usr/local/mysql/bin/myisamchk -r -f Run_Cache.MYI --sort_buffer_size=160M --key_buffer_size=160M --read_buffer_size=20M --write_buffer_size=20M |
- 本文固定链接: http://www.saunix.cn/2949.html
- 转载请注明: saunix 于 大话运维 发表