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