The configuration community:
Search the Site:

myisam_max_extra_sort_file_size

Information

If the temporary file used for fast MyISAM index creation would be larger than using the key cache by the amount specified here prefer the key cache method. This is mainly used to force long character keys in large tables to use the slower key cache method to create the index. 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

728x90