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

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


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


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