Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Monitor Locked query

Posted on 2011-10-10 20:16:20 by Angela liu

---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--

Report this message

#2: Re: Monitor Locked query

Posted on 2011-10-10 20:45:27 by Michael Dykman

--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@yahoo.com> 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--

Report this message

#3: Re: Monitor Locked query

Posted on 2011-10-10 21:14:19 by Keith Keller

On 2011-10-10, Angela liu <yyll2087@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@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

Report this message