MySQL (1038, 'Out of sort memory, consider increasing server sort buffer size')

Brother Xu is still - bjhxcc 2022-09-23 09:21:06 阅读数:336

mysqlsortmemoryconsiderincreasing

insert image description here
View sort_buffer_size

 show variables like '%sort_buffer_size%';
Variable_name Valueinnodb_sort_buffer_size 1048576myisam_sort_buffer_size 262144sort_buffer_size 868352

Solution

mysql> SET GLOBAL sort_buffer_size = 1024*1024; #You need to change the size after the equal sign
版权声明:本文为[Brother Xu is still - bjhxcc]所创,转载请带上原文链接,感谢。 https://javamana.com/2022/266/202209230913121663.html