I agree; the raw output of INNODB_LOCKS is very useful for things like aggregating by table or schema, and the raw output of INNODB_TRX is necessary because SHOW ENGINE INNODB STATUS truncates queries, and SHOW PROCESSLIST doesn't include the innodb transaction id.
I agree; the raw output of INNODB_LOCKS is very useful for things like aggregating by table or schema, and the raw output of INNODB_TRX is necessary because SHOW ENGINE INNODB STATUS truncates queries, and SHOW PROCESSLIST doesn't include the innodb transaction id.