Thank you so much Emilio. I think I'll need to rotate ODW by hand. Any ideas?
From: [email protected] [mailto:[email protected]] On Behalf Of Emilio Scalise Sent: Thursday, August 26, 2010 10:44 AM To: Opsview Users Subject: Re: [opsview-users] 3.7.2 upgrade issues The runtime db is the one that the nagios ndo plugin uses to store check data from the nagios.log file. The opsview web interface for example uses it to display status tables. Nagvis uses also the runtime db. ODW is a long term storage for the runtime data. Periodically, a cron perl script populate the odw database taking data from the runtime db.You can use odw to query the history of your check results for example. Opsview takes care to rotate the runtime db data and to trim the odw tables according to the data retention settings provided. Bye, Emilio 2010/8/26 Ingo Hoffmann <[email protected]> Can anyone tell me what runs on runtime and ODW database? I never got ODW and what it means and I think I'm wasting tons of disk space on those. Thanks, Ingo -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ingo Hoffmann Sent: Wednesday, August 25, 2010 9:28 AM To: Opsview Users Subject: Re: [opsview-users] 3.7.2 upgrade issues Not cool :( I'll see if I can schedule a maintenance window to do this. Thanks Stu -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stu Teasdale Sent: Wednesday, August 25, 2010 9:00 AM To: Opsview Users Subject: Re: [opsview-users] 3.7.2 upgrade issues Opsview benefits greatly from file_per_table. If you do the truncate you'll lose whatever hasn't been successfully sent to ODW. In my case I didn't care, we purely use opsview for alerting. Personally I'd shutdown opsview completely, truncate the table, change mysql to use file_per_table, then dump and restore all my databases. This may well take a long time though, and will result in data loss. I wonder if any opsview people have less time consuming and painful suggestions? On Wed, Aug 25, 2010 at 07:40:40AM -0400, Ingo Hoffmann wrote: > Same thing here Stu, but I don't have file_per_table setup. > When truncating, how much history will I loose? > This table is about 14GB and I'm sure I can forget about 6 months of it. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Stu Teasdale > Sent: Wednesday, August 25, 2010 8:32 AM > To: Opsview Users > Subject: Re: [opsview-users] 3.7.2 upgrade issues > > On Wed, Aug 25, 2010 at 07:02:45AM -0400, Ingo Hoffmann wrote: > > Hi, > > > > > > > > When I upgraded to 3.7.2, the upgrade process took about 9 hours to > complete > > due to a big database and now I'm seeing the web interface out of sync with > > the notifications I'm getting. > > > > How can I shrink the database and make the web interface on sync again? > > I had similar issues, connected to the nagios_servicechecks table in > runtime ending up enormous (a bug in an earlier 3.7 release I believe). > I ended up simply truncating the table and restarting everything, but > this could easily result in a loss of check history. Out of interest > have you configured mysql to use file_per_table? > > Stu > > -- > From the prompt of Stu Teasdale > > Never explain. Your friends do not need it and your enemies will never > believe you anyway. > -- Elbert Hubbard > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > -- >From the prompt of Stu Teasdale You will lose an important tape file. _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
