We have a similar setup that just queries for the auto increment value every X period of time, creates next to zero additional load to do so.
Thanks.
Yeah that seems sane. The odds of you exceeding your monitoring threshold in 1 interval seems close to impossible too. Such as going from 70% to 100% in 30 seconds or whatever your monitor interval is set to.
This is interesting. I wonder if they query the key size every N seconds as part of their monitor, or if they report the key size to the monitor on write.