Page 1 of 1
Notification Page Giving SQL Error
Posted: Fri Dec 11, 2020 3:11 pm
by ncrvision
Hi,
I'm getting the below error on GUI as soon as I navigate to the "Notification" page:
SQL Error [ndoutils] : Out of sort memory, consider increasing server sort buffer size
This is on with 5.7.5 Nagios XI and on CentOS 8 version.
Regards,
Vision
Re: Notification Page Giving SQL Error
Posted: Fri Dec 11, 2020 5:43 pm
by dchurch
Try increasing the
sort_buffer_size variable.
The default for
sort_buffer_size in CentOS 7 was 2097152.
The default in CentOS 8 is 262144,
a mere 12% of what it was in CentOS 7.
Here's how you increase it:
Code: Select all
echo 'sort_buffer_size = 256000000' >>/etc/my.cnf.d/mysql-server.cnf
service mysqld restart
Re: Notification Page Giving SQL Error
Posted: Sat Dec 12, 2020 6:47 am
by ncrvision
I don't think so by changing the MySQL
sort_buffer_size would resolve the issue. I did a bit more analysis and found out that more than 70% of the allocated memory is consuming by the php-fpm service.
The
process manager value by default set to
dynamic instead of
ondemand. Changing this value, restarting the php-fpm brought down the memory consumption on the box to significantly low.
Now, I'm able to access the Notification page.
Anyhow, thanks for the advice!!
I'm currently monitoring the environment and leave for a day/week to see if it spikes back again.