The configuration community:
Search the Site:

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

728x90