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
