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--
Angela liu [ Mo, 10 Oktober 2011 20:16 ] [ ID #2065452 ]

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 <yyll2087 [at] yahoo.com> wrote:

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




--
- michael dykman
- mdykman [at] gmail.com

May the Source be with you.

--0015176f0e3ecaa09b04aef6310e--
Michael Dykman [ Mo, 10 Oktober 2011 20:45 ] [ ID #2065453 ]

Re: Monitor Locked query

On 2011-10-10, Angela liu <yyll2087 [at] yahoo.com> 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 [at] 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 [at] m.gmane.org
Keith Keller [ Mo, 10 Oktober 2011 21:14 ] [ ID #2065454 ]
Datenbanken » gmane.comp.db.mysql.general » Monitor Locked query

Vorheriges Thema: import database
Nächstes Thema: Weird UPDATE Problem