I have an alert condition on loadAverageFiveMinute that I use for my db server. I want to somehow ignore it if at the same time a specific transaction is active.
So, something like:
SELECT * FROM Transaction, SystemSample WHERE appId = 'appId' and name != 'transactionName' and `hostname` = 'myHostName' AND loadAverageFiveMinute > 3 SINCE 1 day ago
Is this possible or is there any alternative solution to detect this case to not to trigger the load alert if the transaction is active at that time?