Error “1038 Out of sort memory, consider increasing sort buffer size

March 21, 2023 by Tarik

Just run mysql query

SET GLOBAL sort_buffer_size = 256000000 // It'll reset after server restart

To set permanent

Edit below file and add

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

sort_buffer_size = 256000000

sudo service mysql restart