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

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

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
copyright:author[Brother Xu is still - bjhxcc],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/266/202209230913121663.html