I still seem some alerts in the state other, does this mean I need to use a number larger than 2gb?


Ok		 Fail Delay Supp Other
Alerts 56642 174 3 0 745

From: Jeffrey <jeffrey.dambly@jasper.com>
Reply-To: Observium Network Observation System <observium@observium.org>
Date: Friday, June 26, 2015 at 2:10 PM
To: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] alerts

I’m not sure what is considered a large deployment, we have 566 devices, 35018 ports, and 14198 sensors.

I made the change you suggested, restart mysqld, and ran alerter.php –h all 

This seems to resolve the issue. I can see the alerts in state other going down.

—Jeff

From: Adam Armstrong <adama@memetic.org>
Reply-To: Observium Network Observation System <observium@observium.org>
Date: Friday, June 26, 2015 at 12:23 PM
To: "observium@observium.org" <observium@observium.org>
Subject: Re: [Observium] alerts

tmp_table_size=2G
max_heap_table_size=2G