There are no reviews yet. Be the first to send feedback to the community and the maintainers!
Repository Details
A tool to print MySQL transactions that take more than <n> milliseconds
MySlowTransactionCapture - A tool to print MySQL transactions that take
more than <n> milliseconds
Reasons for developing this tool was described here: http://yoshinorimatsunobu.blogspot.com/2011/04/tracking-long-running-transactions-in.html
How to use:
* Install libpcap, libpcap-devel, boost, and boost-devel if not installed
* make
* make install
* Run myslowtrancapture
--
[root]# myslowtrancapture -i bond0
Tips:
* Use -i "interface name" to listen to specific NIC.
--- example ---
[root]# myslowtrancapture -i eth1
Monitoring eth1 interface..
Listening port 3306..
Logging transactions that take more than 4000 milliseconds..
---------------
* Use -f "filtering rules" to listen to specific IP addresses/ports.
Filtering syntax is the same as that of tcpdump.
--- example ---
[root]# myslowtrancapture -f "tcp port 5508"
Monitoring any interface..
Filtering rule: tcp port 5508
Logging transactions that take more than 4000 milliseconds..
---------------
* Use -t milliseconds to change printing criteria.
--- example ---
[root]# myslowtrancapture -i eth0 -t 10000
Monitoring eth0 interface..
Listening port 3306..
Logging transactions that take more than 10000 milliseconds..
---------------
* Use -o when your MySQL server speaks old MySQL protocols.
--- example ---
[root]# myslowtrancapture -i eth0 -t 10000 -o
Monitoring eth0 interface..
Listening port 3306..
Logging transactions that take more than 10000 milliseconds..
Capturing MySQL old protocols..
---------------
Limitations:
* Implicit commit by DDL is not supported (not handled as transaction ends).
* MySQL Server-Side Prepared Statement protocol is not supported.
License: GNU General Public License version 2
Author: DeNA Co.,Ltd. <[email protected]>
* MySQL protocol command constants were taken from MySQL source code
* local_address.c, local_address.h were taken from tcprstat(http://github.com/Lowercases/tcprstat/) authored by Ignacio Nin under GNU General Public License version 2.
* sll.h was taken from libpcap under BSD 4.3 license.
