Notification Page Giving SQL Error

[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

[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

[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.