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
