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.
