Monitor Locked query

---1196836486-258327331-1318270580=:12598
Content-Type: text/plain; charset=us-ascii

Hi, Folks:

Have any idea how to monitor Locked queries with Nagios?

Thanks
---1196836486-258327331-1318270580=:12598--

Re: Monitor Locked query

--0015176f0e3ecaa09b04aef6310e
Content-Type: text/plain; charset=ISO-8859-1

Your instrumentation script should be invoking "SHOW PROCESSLIST" and
parsing the status fields.

- md

On Mon, Oct 10, 2011 at 2:16 PM, Angela liu wrote:

> Hi, Folks:
>
> Have any idea how to monitor Locked queries with Nagios?
>
> Thanks




--
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--0015176f0e3ecaa09b04aef6310e--

Re: Monitor Locked query

On 2011-10-10, Angela liu wrote:
>
> Have any idea how to monitor Locked queries with Nagios?

You might be able to use and/or modify this plugin (untested by me):

http://exchange.nagios.org/directory/MySQL/check_mysql_healt h/details

--keith

--
kkeller-usenet@wombat.san-francisco.ca.us
(try just my userid to email me)
AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt
see X- headers for PGP signature information



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org