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
