myisamchk: error: myisam_sort_buffer_size is too small

myisamchk: error: myisam_sort_buffer_size is too small

MySQL Error while repair with myisamchk utility

- recovering (with sort) MyISAM-table 'tableName' Data records: 10662929483 - Fixing index 1 myisamchk: error: myisam_sort_buffer_size is too small MyISAM-table 'tableName' 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

To Fix this run the below command:

myisamchk -r -q TABLENAME.MYI –sort_buffer_size=2G

 

2 thoughts on “myisamchk: error: myisam_sort_buffer_size is too small

Comments are closed.