Nagios Support Forum

Box293 wrote:

raamardhani7 wrote:/usr/local/nagios/share/perfdata/ there are lot of files in this files, acn these files be deleted? If I delete them will I have historical graphs? There is 80GB space still available..

It does not appear that space is the issue.
[root@lussvpnagiosxi00 nagios]# mysql -pnagiosxi
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9950091
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use nagios;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> repair table nagios_logentries use_frm;
+--------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+--------+----------+----------+
| nagios.nagios_logentries | repair | status | OK |
+--------------------------+--------+----------+----------+
1 row in set (0.05 sec)

mysql> quit;
Bye

If you delete the files in /usr/local/nagios/share/perfdata/ you will lose all of your historical performance data.

Try this:

Code: Select all

cd /var/lib/mysql/nagios/
mkdir /tmp/nagios_TMD
mv *.TMD /tmp/nagios_TMD/
mysql -pnagiosxi
use nagios;
repair table nagios_logentries use_frm;
quit;