Page 1 of 2

nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 1:27 pm
by 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

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 1:44 pm
by abrist
benhank wrote: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.

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 1:56 pm
by 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)?

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 4:47 pm
by abrist
benhank wrote: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.
benhank wrote: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 . . . :P

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 4:53 pm
by 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...

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 5:09 pm
by abrist
Well, that should work. What is the reason for restoring?

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 5:11 pm
by benhank
it's part of our replication process. back primary and restore to secondary

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 6:15 pm
by BanditBBS
benhank wrote:it's part of our replication process. back primary and restore to secondary
I should probably test that at my site once :roll:

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

Re: nagios files as big as Oprah after the BBQ

Posted: Tue Oct 08, 2013 6:32 pm
by 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!

Re: nagios files as big as Oprah after the BBQ

Posted: Wed Oct 09, 2013 9:15 am
by 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.