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
