nagios files as big as Oprah after the BBQ

[benhank]

commercial break from snmptt ...

Is it safe to delete the following:

Code: Select all

1.1G    /var/lib/phpMyAdmin/save/nagios.csv
1.7G    /var/lib/mysql/nagios/nagios_commenthistory.MYD
205M    /var/lib/mysql/nagios/nagios_commenthistory.MYI
120M    /usr/local/nagios/share/perfdata/CON-330-3750-1/If_StackPort2.rrd
116M    /usr/local/nagios/share/perfdata/SMG-3750-1/If_StackPort2.rrd
288M    /usr/local/nagios/share/perfdata/KEN-6509-3/Interface_Table_Status.rrd
288M    /usr/local/nagios/share/perfdata/KEN-6509-4/Interface_Table_Status.rrd

[abrist]

1.1G /var/lib/phpMyAdmin/save/nagios.csv

Yes, unless you use phpmyadmin

1.7G /var/lib/mysql/nagios/nagios_commenthistory.MYD
205M /var/lib/mysql/nagios/nagios_commenthistory.MYI

These are you comment history database tables. My suggestion would be to not remove them. Though you may want to truncate them.

120M /usr/local/nagios/share/perfdata/CON-330-3750-1/If_StackPort2.rrd
116M /usr/local/nagios/share/perfdata/SMG-3750-1/If_StackPort2.rrd
288M /usr/local/nagios/share/perfdata/KEN-6509-3/Interface_Table_Status.rrd
288M /usr/local/nagios/share/perfdata/KEN-6509-4/Interface_Table_Status.rrd

These can be deleted as long as you don't care about the performance data for these objects.

[benhank]

thanks, now if I truncate the files won't that delete all of the data stored in em? I have a specific string of words that will reduce that filesize, but I hesitate.

If I backup "nagios-sourse-server" using the

Code: Select all

/usr/local/nagiosxi/scripts/backup_xi.sh

and then delete the files listed on nagiostargetserver. And after, deletining them I restore Nagios-source-server's backup to Nagios-target-server with

Code: Select all

/usr/local/nagiosxi/restore_xi.sh

will there be any adverse ramifications (<- dictionary .com daily words)?

[abrist]

thanks, now if I truncate the files won't that delete all of the data stored in em? I have a specific string of words that will reduce that filesize, but I hesitate.

It indeed will delete those entries.

will there be any adverse ramifications (<- dictionary .com daily words)?

But why delete those files if you are going to just restore them?
Color me confused . . .

[benhank]

because when I run the restore, and it untars the files, I get disk full errors. So I am thinking that if I cut the fat before I gain it again, maybe I wont have that problem. Silly but other than that I got nuthin...

[abrist]

Well, that should work. What is the reason for restoring?

[benhank]

it's part of our replication process. back primary and restore to secondary

[BanditBBS]

it's part of our replication process. back primary and restore to secondary

I should probably test that at my site once

benhank, you missed a heck of a time at the conference, I was hoping you were there, I was going to put you on the spot and make you do some stand-up, lol

[benhank]

Yeah, I really wanted to be there as well but it didnt work out that way. my loss =( cause we woulda had us some FUN!

[slansing]

I'd go for it, if you are placing a completely different XI server on the system there is no sense in keeping the log files around on that system, or any old data that is not pertinent.