Reporting Tab performance in large scale Monitoring
Posted: Wed Sep 26, 2018 4:07 am
Hi,
I have Nagios XI 5.4.13 with 12K Host. I offloading DB to remote Linux centos 7 with 10 core CPU and 8 GB RAM on MariaDB 5.5. I need to create Reports about availability in Reports Tab but when I select a host or hostgroup and run the report, avail.cgi process runs but nothing has been generated for a long time. Is it possible to have better performance in reporting Tab?
my.cnf file is as below:
I have Nagios XI 5.4.13 with 12K Host. I offloading DB to remote Linux centos 7 with 10 core CPU and 8 GB RAM on MariaDB 5.5. I need to create Reports about availability in Reports Tab but when I select a host or hostgroup and run the report, avail.cgi process runs but nothing has been generated for a long time. Is it possible to have better performance in reporting Tab?
my.cnf file is as below:
Code: Select all
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
bind-address={mysql_IP_Address}
port=3306
skip_name_resolve
key-buffer-size = 32M
myisam-recover-options = FORCE,BACKUP
max-allowed-packet = 16M
max-connect-errors = 1000000
expire-logs-days = 14
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 2G
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-size = 1024M
max-connections = 2000
thread-cache-size = 512
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid