Logging queries affected by table locks in MySQL

Question

Is it possible to create a log of queries that are slowed down by MyISAM table locks? I'm trying to convince my boss that we need to convert to InnoDB to improve site performance, but need to know what sort of gains would be made.

Thanks

http://stackoverflow.com/questions/20148/myisam-versus-innodb — Mitch Wheat, Feb 23 '11 at 00:38

score 0 · Accepted Answer · answered Feb 23 '11 at 02:50

0

Never mind, I found http://dev.mysql.com/doc/refman/5.1/en/mysqldumpslow.html

Slow query log keeps record of lock time.

answered Feb 23 '11 at 02:50

Noodles

900
4
14
30

Logging queries affected by table locks in MySQL

1 Answers1