Nagios Support Forum

Hello,

We have made the changes to the below databases as per your suggestion, we will get back to you if we see any improvement in performance:

mysql> select count(*) from nagios_logentries;
+----------+
| count(*) |
+----------+
| 227410 |
+----------+
1 row in set (0.00 sec)


mysql> TRUNCATE TABLE nagios_logentries;
Query OK, 0 rows affected (0.01 sec)

mysql> select count(*) from nagios_logentries;
+----------+
| count(*) |
+----------+
| 12 |
+----------+
1 row in set (0.00 sec)



mysql> select count(*) from nagios_notifications;
+----------+
| count(*) |
+----------+
| 70246 |
+----------+
1 row in set (0.00 sec)


mysql> TRUNCATE TABLE nagios_notifications;
Query OK, 0 rows affected (0.01 sec)


mysql> select count(*) from nagios_statehistory;
+----------+
| count(*) |
+----------+
| 5377 |
+----------+
1 row in set (0.00 sec)


mysql> select count(*) from nagios_statehistory;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)


Please suggest if any additional changes can be performed.

Also, we checked for the storage part and we are using the fastest storage that can be used.
We are using Premium SSD storage with size 158 GiB and Max IOPS is 1100.

Please PM me a fresh copy of your profile from the system and I'll see what we can find.

Hello,

I tried executing the commands provided by you in another Nagios xi server for downgrading NDO3 to NDO2DB. I was unable to perform those, getting below error:

[root@HO1-NAGIOSxi tmp]# rm -rf /tmp/nagiosxi
[root@HO1-NAGIOSxi tmp]# wget https://assets.nagios.com/downloads/nag ... .14.tar.gz
--2020-09-03 20:04:11-- https://assets.nagios.com/downloads/nag ... .14.tar.gz
Resolving assets.nagios.com (assets.nagios.com)... 72.14.181.71, 2600:f03c:91ff:fedf:b821
Connecting to assets.nagios.com (assets.nagios.com)|72.14.181.71|:443... connected.
GnuTLS: Error in the pull function.
Unable to establish SSL connection.
[root@HO1-NAGIOSxi tmp]# tar zxf xi-5.6.14.tar.gz
tar (child): xi-5.6.14.tar.gz: Cannot open: No such file or directory
tar (child): Error is not recoverable: exiting now
tar: Child returned status 2
tar: Error is not recoverable: exiting now
[root@HO1-NAGIOSxi tmp]# cd /tmp/nagiosxi
-bash: cd: /tmp/nagiosxi: No such file or directory
[root@HO1-NAGIOSxi tmp]# systemctl start nagios


So, I simply started back nagios service.

Please help me on it.

What xi version is that system running?

What OS/Version?

Hmm, I haven't seen this before:
Try using this curl command instead of the wget command:
Please create separate posts/tickets for unrelated systems.