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

查看sort_buffer_size

 show variables like '%sort_buffer_size%'; 

Variable_name            Value
innodb_sort_buffer_size	1048576
myisam_sort_buffer_size	262144
sort_buffer_size	    868352
2
3
4

解决方案

mysql> SET GLOBAL sort_buffer_size = 1024*1024;  #等号后面要改的  选择自己需求的大小