Remark : mysql memory increase
Warning : mysqli_query(): (HY001/1038): Out of sort memory, consider increasing server sort buffer size in /var/……..
sort_buffer_size 주석제거 및 필요시 5M 로 설정
|
1 2 3 4 5 6 7 8 9 10 11 |
sudo vi /etc/my.cnf # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M sort_buffer_size = 2M # 주석제거 # read_rnd_buffer_size = 2M |
|
1 2 3 |
systemctl restart mysqld |