Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

[Ton Voon]

Toni, OK, I think we've fixed this now. I think we lost the "stripping of unused contactgroups" logic when we did the notification profiles work. The number of contactgroups generated has now reduced from 20000 to 379. The validation time has dropped from 6 minutes down to 0.5 seconds. The patch is here: https://secure.opsera.com/wsvn/wsvn/opsview?op=comp&compare[]=%2ftr...@4491&compare[]=%2ftr...@4492 I'm not sure if you can just apply onto 3.7.0, but this will be fixed in 3.7.1. Finally, Toni, your database was missing some foreign key constraints. I think this could happen if innodb has a problem. I think you are one of our early users (says 2.9 in your database!), so maybe something happened along the way that caused your database schema to be inconsistent. When I was upgrading your database, it was failing due to these missing key constraints. I've written a process where you can fix your schema: http://docs.opsview.com/doku.php?id=opsview-community:mysql#incorrect_schemas If you follow this before installing 3.7.1, you should get a smooth upgrade. Ton On 27 May 2010, at 07:52, Toni Van Remortel wrote: On 26 May 2010, at 11:37, James Peel wrote:   We're currently investigating this issue: https://secure.opsera.com/jira/browse/OPS-1168   I have just updated this ticket with my findings.   If you have any comments or observations please post here.   I do have some comments about this (as the described problem was triggered by me J) -       Having multiple hostgroups, servicegroups and contacts is quite common in a large distributed setup. My setup can be called an Enterprise setup I guess. -       If you have different sites, each with at least 1 slave, and some local site IT guys responsible for their site but not for the others, you have to limit the access permissions to that site. But some IT guys need to have a full overview of all sites, and some need to access multiple sites but not all. Combine that with a nice global spread of the sites, and I think you need to admit that there is no alternative to get this situation sorted out.   In short: this setup now is the only solution for my situation (I tried several). If there will be an extra option, let’s call it ‘site’, that can be linked to hostgroups, hosts and contacts, then I can reduce the amount of contacts.   One question though: what happens if I do not use the hostgroups or servicegroups to define the access, but only keywords? Would that help?   Regards, Toni   _______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users Ton Voon Product Architect Opsera Limited | Unit 69 Suttons Business Park Reading | Berkshire | RG6 1AZ | UK Phone:   +44 (0) 845 057 7887 Mobile:   +44 (0) 7931 365796 Skype:   tonvoon     Email:   ton.v...@opsera.com www.opsera.com This e-mail is confidential, intended only for the named recipient(s) above and may contain information that is privileged and confidential. If you receive this message in error, or are not the named recipient(s), please notify the sender at the phone number above, do not copy this message, do not disclose its contents to anyone, and delete this e-mail message from your computer. Although Opsera routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Opsera makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Opsera Limited is registered in the UK under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.

_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users