mysql中myisamchk: error: myisam_sort_buffer_size is too small错误的解决方法：

D:\ZZphpserver\MySql\MySQL Server 5.6\bin>myisamchk -c -r ../data/zqdata/zz_info

- recovering (with sort) MyISAM-table '../data/zqdata/zz_info'

Data records: 0

- Fixing index 1

- Fixing index 2

myisamchk: error: myisam_sort_buffer_size is too small

MyISAM-table '../data/aixuedata/axcms_gsinfo#P#p11' 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

看到sort_buffer_size这个参数（connect级别的参数，MySQL5.7，默认值是1048576字节，也就是1MB）

解决办法：

myisamchk -c -r ../data/zqdata/zz_info --sort_buffer_size=2G

• myisamchk