SHOW ENGINE INNODB STATUS has two TRANSACTIONS sections
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
Initially reported as https:/
SHOW ENGINE INNODB STATUS in 5.6 displays two identical TRANSACTIONS sections.
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.22-71.0-debug Source distribution
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [test]> show engine innodb status \G
*******
Type: InnoDB
Name:
Status:
=======
2014-12-21 02:22:22 7faa1f5af700 INNODB MONITOR OUTPUT
=======
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
...
----------
SEMAPHORES
----------
----------
MUTEX INFO
----------
...
-------------
RW-LATCH INFO
-------------
...
------------
TRANSACTIONS
------------
Trx id counter 1282
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
History list length 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7faa1f5af700, query id 7 localhost ::1 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 1282
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
History list length 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7faa1f5af700, query id 7 localhost ::1 root init
show engine innodb status
-------
END OF INNODB MONITOR OUTPUT
=======
1 row in set (0.01 sec)
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 19 lines (+0/-9)1 file modifiedstorage/innobase/srv/srv0srv.cc (+0/-9)
tags: | added: xtradb |
tags: | added: low-hanging-fruit merge-regression |
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>