Web Admin console slow to refresh and apply configurations

[Phisith]

When selecting different sections for the Admin Console, it takes a long time to load (over 30 seconds delay when viewing the Hostgroup Summary and Apply Configurations).

Already tried updating my.cnf with the following values:
innodb_thread_concurrency=0
innodb_read_io_threads=64
innodb_write_io_threads=64

Runs a little faster, but still takes a long time to load the hostgroup summary.

[benjaminsmith]

Hi @Phisith,

If you haven't done so already, please follow the steps in the guide below to optimize the PHP settings on this system. That should help improve GUI performance.

Nagios XI - Optimizing The PHP Settings File

If the database is causing performance issues, please upload my.cnf file along with a fresh system profile and we'll review the logs for any issues.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button

Lastly, please post the output of the following query to check the table sizes. Thanks, Benjamin

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

[Phisith]

Followed the suggested PHP.INI settings ... don't see any improvements.

********************************************************************************************
/etc/my.cnf
********************************************************************************************

[mysqld]
innodb_thread_concurrency=0
innodb_read_io_threads=64
innodb_write_io_threads=64
query_cache_size=16M
query_cache_limit=4M
tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=32M
table_open_cache=32
innodb_file_per_table=1

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

********************************************************************************************

[Phisith]

Attached are the table size and system profile. Let me know if you need anything else. Thanks, -Phisih

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum

[Phisith]

and the table sizes query output

[benjaminsmith]

Hi,

Starting 5.7.x, we implemented a new backend database application, and have been making continuous updates to this program, I would recommend taking a full backup and upgrading to 5.8.2.

You're just over 20k host and service checks, did you ever experience issues with the kernel message queues on this system?

The log entries table is pretty large, I would recommend truncating that. You'll find instructions for this on page 5 of the following guide.

https://assets.nagios.com/downloads/nag ... tabase.pdf

Additionally, I would follow the guide below to adjust the performance settings in the Admin area by increasing the multiplier on the refresh rate for the dashlets.

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Then optimize the database settings.
https://assets.nagios.com/downloads/nag ... zation.pdf

Let me know if the performance improves after making those changes.

---Benjamin