--- /usr/bin/pt-stalk.dist 2015-11-06 14:56:25.000000000 -0500
+++ /usr/bin/pt-stalk 2016-01-23 19:52:44.206878087 -0500
@@ -1052,9 +1052,9 @@
}
transactions() {
- $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_TRX\G"
- $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCKS\G"
- $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS\G"
+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_TRX ORDER BY trx_id\G"
+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCKS ORDER BY lock_id\G"
+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS ORDER BY blocking_trx_id, requesting_trx_id\G"
}
tokudb_status() {
Sorry for the spam. Probably this is a little lighter on the INNODB_LOCKS table with the same result: (instead of the wider lock_id column)
SELECT SQL_NO_CACHE * FROM INFORMATION_