LP #1404565: SHOW ENGINE INNODB STATUS has two TRANSACTIONS sections

**Comment from Launchpad by: Nilnandan Joshi on: 31-12-2014 08:02:11

Verified with PS 5.6.21

nilnandan@desktop:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.6.21-70.1 Percona Server (GPL), Release 70.1, Revision 698

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show engine innodb status \G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2014-12-31 13:29:23 7ff2e009f700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 25 seconds
----------------- BACKGROUND THREAD
----------------- srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 21600 srv_idle
srv_master_thread log flush and writes: 21598
---------- SEMAPHORES
---------- OS WAIT ARRAY INFO: reservation count 3
OS WAIT ARRAY INFO: signal count 3
Mutex spin waits 60, rounds 140, OS waits 1
RW-shared spins 2, rounds 60, OS waits 2
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 2.33 mutex, 30.00 RW-shared, 0.00 RW-excl
------------ TRANSACTIONS
------------ Trx id counter 4868
Purge done for trx's n:o < 2917 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7ff2e009f700, query id 110 localhost root init
show engine innodb status
-------- FILE I/O
-------- ..
------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX
------------------------------------- ..
—
LOG
—
..
---------------------- BUFFER POOL AND MEMORY
---------------------- ..
-------------- ROW OPERATIONS
-------------- ..
------------ TRANSACTIONS
------------ Trx id counter 4868
Purge done for trx's n:o < 2917 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7ff2e009f700, query id 110 localhost root init
show engine innodb status
---------------------------- END OF INNODB MONITOR OUTPUT
============================

1 row in set (0.01 sec)

mysql>