3 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 11, OS thread handle 123145555853312, query id 2765 localhost root updating update user set name='hehe' where id=3 *** (2) HOLDS THE LOCK(S): RECOR
4 lock struct(s), heap size 1136, 3 row lock(s) MySQL thread id 19, OS thread handle 6384, query id 212 localhost ::1 root TABLE LOCK table `accounts` trx id 3124 lock mode IX RECORD LOCKS space id 53 page no 5 n bits 72 index createtime of table `accounts` trx id 3124 lock...
0 lock struct(s), heap size 1136, 0 row lock(s) --TRANSACTION 351844119368032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) --TRANSACTION 351844119366224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ...
locked 1 3 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 11, OS thread handle 123145555853312, query id 2765 localhost root updating update user set name='hehe' where id=3 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 94 page no 3 n bits 80...
...0lock struct(s),heap size1136,0row lock(s)Hash table size1593643,node heap has273buffer(s)Hash table size1593643,node heap has3buffer(s)Hash table size1593643,node heap has21buffer(s)Hash table size1593643,node heap has54buffer(s)Hash table size1593643,node heap has71buffer(s)Hash ...
##VALUES(19,20,10)1LOCK struct(s), HEAP size1136,0ROW LOCK(s), UNDOLOGentries1MySQL thread id1475203, OS thread handle139581473105664, QUERY id4426152127.0.0.1adminTABLELOCKTABLE`db001`.`tb1001` trx id1454155LOCK MODE IX---TRANSACTION 1454154, ACTIVE 23 sec## SQL ...
0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421305875781456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 31220603, ACTIVE 6 sec 1 lock struct(s), heap size 1136, 0 row lock(s) ...
--终端2mysql>show engine innodb status\G---省略其他输出---TRANSACTION 23076, ACTIVE 96 sec2lock struct(s), heap size1136,1row lock(s) MySQL thread id3, OS thread handle139787704108800, query id44localhost root cleaning upTABLELOCKtable`burn_test`.`t5` trx id23076lock mode IX--在表上...
---TRANSACTION 10909611, ACTIVE 2 sec rollbackmysql tablesinuse1, locked1ROLLING BACK4lock struct(s), heap size1136,316row lock(s) MySQL thread id1, OS thread handle140435435284224, query id0Compressing gtid_executedtable 查看INNODB_TRX表,也能发现有事务在回滚。
* 某些索引访问方法(AMs)可能通过参考num_heap_tuples计算num_index_tuples, * 在这种情况下会拷贝从IndexVacuumInfo中拷贝estimated_count域. */typedefstructIndexBulkDeleteResult{//index中剩下的pagesBlockNumber num_pages;/* pages remaining in index *///在vacuum期间清除的元组数BlockNumber pages_removed;/...