MySQL 8.0设置sort_buffer_size

SET sort_buffer_size = 1024*1024

———————————————————————————————————————————

Java程序报错如下：

java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size

———————————————————————————————————————————使用命令查看当前的设置：

show variables like '%sort_buffer_size%'; 

设置的命令

SET GLOBAL sort_buffer_size = 1024*1024 or SET sort_buffer_size = 1024*1024