[sqlmike]

Pankaj,

 

Thank you for your reply.  Seems Monyog could handle the error condition a little better and provide the same information you just did.

 

Thanks!

[sqlmike]

Thank you for the reply.  I think in the long run the need to use the Performance Schema will win out over process list for collecting data, but I do see your point.   There really needs to be something separate for monitoring blockers by time and by count in my opinion. 

 

 

edit:

 

I’m a long time dba, but fairly new to mysql and something that I would really like to see in monyog is something like percona’s pmp-check-mysql-innodb that will allow alerts to fire for waiter_count or waiter_duration.  Detecting sleeping connections that are still holding locks and blocking is really important.  Note that I have no relationship with percona, just went looking for a blocker monitoring solution.

[sqlmike]

Thank you.  Are there plans to allow the Sniffer mode to be Performance Schema when enabling the Monitor Long Running Query?  A feature to alert on the number of blocked processes instead of just time?

[sqlmike]

Understood, thanks Peter.

[sqlmike]

Saurabh, What about a locked query alert?  I would like to know when there are X number of processes waiting on a lock resource and fire an alert.

[Author]

Posts