script to monitor and email us when Mysql Semaphore and dead lock occurance happen.

Hi,
from command line Show Engine Innodb status

will show you if there is any Semaphore occurance or if there is any dead lock occurance in the server..
but i m trying to find out a script or trying to build a script which will monitor mysql .. and let us know if there is any occurance of semaphore or dead lock..

it can by by bash or python..

but dont know where to start or how to start of if there is any free script is out out there

if any one useing this kind of script , can you please help me with this
thanks
LVL 29
fosiul01Asked:
Who is Participating?
 
johanntagleConnect With a Mentor Commented:
Yes that means you need to run innotop over and over again in a loop.  If you build your own script you will need to call show engine innodb status over and over again too, so it's practically the same thing though with less overhead since you'll be querying mysql directly.

Or maybe you can browse the code of innotop and see how it parses for locks and semaphore occurances.  Think I'll have time to look at it later (you got me curious)
0
 
johanntagleCommented:
Maybe you can build a script that further processes the output of innotop.  I haven't tried its non-interactive option but the documentation says its output can be further processed by other scripts.  You can check out the documentation at http://innotop.googlecode.com/svn/html/index.html
0
 
fosiul01Author Commented:
no the problem is different..

Semaphore and dead lock will only aprear on the output if it happend

just normal output capture will not work
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.