2.修改myisam_max_sort_file_size mysql> set global myisam_max_sort_file_size=10*1024*1024*1024; Query OK, 0 rows affected (0.00 sec) mysql> SHOW VARIABLES LIKE 'myisam_max_sort_file_size'; +---+---+ | Variable_name | Value | +---+---+ | myisam_max_sort_file_size | 107...
在MySQL 中,myisam_max_sort_file_size 参数指定在进行 MyISAM 索引排序时允许使用的最大内存量。它的单位是字节,这里设置为 64GB。 MyISAM 是 MySQL 中的一种存储引擎,用于管理表。当对一个 MyISAM 表进行查询时,MySQL 会根据查询条件从磁盘中读取数据,并根据需要对数据进行排序、分组、计算等操作。在执行这...
Version:4.0.12OS:Linux (Linux) Assigned to:CPU Architecture:Any [29 Apr 2003 3:38] Peter Zaitsev Description:REPAIR TABLE QUICK seems to fail to use values fo myisam_max_sort_file_size if they have been set online using SET command: | myisam_max_extra_sort_file_size | 100000000000 |...
seems to indicate that you can set myisam_max_sort_file_size and myisam_max_extra_sort_file_size to a value higher than available memory (but lower than available tmp disk) to force the DB to do a “repair by sort” on disk. I cannot find anything in the docs about this. It this...
Description:Assigning a value to myisam_max_sort_file_size produces no warning, but also has no effect.How to repeat:Server version: 5.1.24-rc-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SHOW VARIABLES LIKE 'myisam_max_sort_file_size'; +--...
Description:The 'myisam_max_extra_sort_file_size' variable is never actually used. It sets the C-level global variable myisam_max_extra_temp_length, but then that value is never used by mi_too_big_key_for_sort().How to repeat:This behavior was changed with this changeset: ChangeSet@1.1...