The configuration community:
myisam_max_sort_file_size
Information
The maximum size of the temporary file that MySQL is allowed to use while re-creating a MyISAM index (during REPAIR TABLE ALTER TABLE or LOAD DATA INFILE). If the file size would be larger than this value the index is created using the key cache instead which is slower. This variable was added in MySQL 3.23.37. Note: The value is given in megabytes before 4.0.3 and in bytes thereafter.
Syntax
Example



