MYSQL Error: Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size

MYSQL Error: Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size
The Java interface suddenly reports an error with the error message Out of sort memory, consider increasing server sort buffer size.
The literal meaning is Out of sort memory, consider increasing server sort buffer_size.
mysql> show variables like ‘%sort_buffer_size%’;
+————————-+———+
| Variable_name | Value |
+————————-+———+
| innodb_sort_buffer_size | 1048576 |
| myisam_sort_buffer_size | 8388608 |
| sort_buffer_size | 262144 |
+————————-+———+
3 rows in set (0.01 sec)
You can see the sort_buffer_size, at this time you need to adjust the corresponding data larger
mysql> SET GLOBAL sort_buffer_size = 1024*1024;
Query OK, 0 rows affected (0.00 sec)

Retest

 

Similar Posts: