Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
MySQL Blocked Transaction Alarm Generator alarms with very high wait times
설명
Blocked Transaction Alarm Generator alarms show very high wait times (70000+ seconds).
E.g. "This transaction has been waiting to complete for 70012 seconds, since 2023-06-14 14:59:29"
원인
The way this metric is calculated has been recently improved, but the underlying issue is due to mismatching Server Time Zone Override and Client Time Zone Override in the MySQLAgent agent properties. When these two parameters have different custom values, the wait time metric calculations will be inaccurate.
해결 방안
Make sure that if either Server Time Zone Override or Client Time Zone Override agent properties for MySQLAgent has a custom value, the other property needs to be updated to the same value as well.
For valid time zone names and instructions please review KB 4299883.
