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.commailto:jeffrey.dambly@jasper.com> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Friday, June 26, 2015 at 2:10 PM To: Observium Network Observation System <observium@observium.orgmailto: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.orgmailto:adama@memetic.org> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Friday, June 26, 2015 at 12:23 PM To: "observium@observium.orgmailto:observium@observium.org" <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] alerts
tmp_table_size=2G max_heap_table_size=2G