sort pt-stalk transactions()

[MikeG]

--- /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() {

[MikeG (mikegriffin)]

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_SCHEMA.INNODB_LOCKS ORDER BY lock_trx_id\G

[Frank Cizmich (frank-cizmich)]

that's not spam :-)

Thank's Mike

( this is spam: https://www.youtube.com/watch?v=anwy2MPT5RE )

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-828