The myisam_sort_buffer_size variable sets the amount of memory for a buffer that is allocated when indexes are created using CREATE INDEX or ALTER TABLE or during a REPAIR TABLE operation on a MyISAM table.
Releem automatically tunes myisam_sort_buffer_size and 44 other variables
to improve MySQL performance. Try Releem for Free
, or deepen your understanding by reading our detailed article.