Manual does not describe Innodb_current_row_locks in any useful way
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Borys Belinsky | |||
5.6 |
Triaged
|
Medium
|
Borys Belinsky | |||
5.7 |
Triaged
|
Medium
|
Borys Belinsky |
Bug Description
Manual page about extended SHOW ENGINE INNODB STATUS in Percona Server 5.6 (http://
...
------------
TRANSACTIONS
------------
Trx id counter 76600
Purge done for trx's n:o < 76600 undo n:o < 0 state: running but idle
History list length 586
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 76596, not started
MySQL thread id 39, OS thread handle 0x7fef74317700, query id 159 localhost root cleaning up
---TRANSACTION 76595, not started
MySQL thread id 38, OS thread handle 0x7fef74358700, query id 161 localhost root init
show engine innodb status
---TRANSACTION 76597, ACTIVE 106 sec
4 lock struct(s), heap size 1184, 7 row lock(s), undo log entries 6
MySQL thread id 40, OS thread handle 0x7fef742d6700, query id 153 localhost root cleaning up
TABLE LOCK table `test`.`t3` trx id 76597 lock mode IX
RECORD LOCKS space id 1416 page no 3 n bits 72 index `PRIMARY` of table `test`.`t3` trx id 76597 lock_mode X
RECORD LOCKS space id 1416 page no 3 n bits 72 index `PRIMARY` of table `test`.`t3` trx id 76597 lock_mode X
RECORD LOCKS space id 1416 page no 3 n bits 72 index `PRIMARY` of table `test`.`t3` trx id 76597 lock_mode X locks rec but not gap
-------
END OF INNODB MONITOR OUTPUT
=======
1 row in set (0,00 sec)
mysql> show global status like 'Innodb_
+------
| Variable_name | Value |
+------
| Innodb_
+------
1 row in set (0,00 sec)
Now, tell my by the manual (or from any other source) what the value of Innodb_
information type: | Public → Public Security |
information type: | Public Security → Public |
Please, make sure to provide example of transactions section that will allow to show and explain values of all status variables mentioned at http:// www.percona. com/doc/ percona- server/ 5.6/diagnostics /innodb_ show_status. html#transactio ns