MySQL Forums
Forum List  »  Events (Job Scheduler)

Finding/killing long running InnoDB transactions with Events
Posted by: Edwin DeSouza
Date: August 04, 2011 09:09AM

Finding/killing long running InnoDB transactions with Events
http://www.markleith.co.uk/?p=730

Using the event scheduler to purge the process list
http://datacharmer.blogspot.com/2008/10/using-event-scheduler-to-purge-process.html

`kill_run_aways` Stored Proc
http://forge.mysql.com/tools/tool.php?id=106

Yoshinori: Tracking long running transactions in MySQL
http://yoshinorimatsunobu.blogspot.com/2011/04/tracking-long-running-transactions-in.html

MySQL Utilities: mysqlprocgrep
http://wb.mysql.com/utilities/man/mysqlprocgrep.html

How to debug long-running transactions in MySQL
http://www.mysqlperformanceblog.com/2011/03/08/how-to-debug-long-running-transactions-in-mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
Finding/killing long running InnoDB transactions with Events
8654
August 04, 2011 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.