ODW should be truncated by Opsview. See the retention setting in Opsview web frontend at [Server]->[System Preferences]->[ODW].
-- kind regards, Henry On Do, 2010-08-26 at 09:47 -0400, Ingo Hoffmann wrote: > 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 _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
