myisamchk: error: myisam_sort_buffer_size is too small

5 (100%) 1 vote

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

 

For any query or issue, feel free to discuss on http://discuss.eduguru.in

One thought on “myisamchk: error: myisam_sort_buffer_size is too small

Comments are closed.

%d bloggers like this: