MySQL运维24-SHOW ENGINE INNODB STATUS解析

MySQL运维24-SHOW ENGINE INNODB STATUS解析

目录

• MySQL运维24-SHOW ENGINE INNODB STATUS解析
  • 1、SHOW ENGINE INNODB STATUS概述
  • 2、信号量（Semaphores）
    • 2.1、信号量信息示例
    • 2.2、信号量信息说明
    • 2.3、知识点：CPU自旋(SPIN)
    • 2.3、信号量中的OS WAIT ARRAY INFO
  • 3、死锁
    • 3.1、死锁信息示例
    • 3.2、死锁信息说明
  • 4、外键冲突
    • 4.1、外键冲突信息示例
    • 4.2、外键冲突信息说明
  • 5、事务信息
    • 5.1、事务信息示例
    • 5.2、事务信息说明
      • 5.2.1、Trx id counter ...
      • 5.2.2、Purge done for trx's n:o < ...
      • 5.2.3、undo n:o < ...
      • 5.2.4、state: running but idle
      • 5.2.5、History list length ...
      • 5.2.6、LIST OF TRANSACTIONS FOR EACH SESSION: ...
  • 6、I/O信息
    • 6.1、I/O信息示例
    • 6.2、I/O信息说明
  • 7、插入缓存和自适应索引信息
    • 7.1、插入缓存和自适应索引信息示例
    • 7.2、插入缓存和自适应索引信息说明
    • 7.3、Insert Buffer（插入缓存）
  • 8、LOG
    • 8.1、LOG信息示例
    • 8.2、LOG信息说明
  • 9、缓冲池信息
    • 9.1、缓冲池信息示例
  • 10、ROW OPERATIONS信息
    • 10.1、ROW OPERATIONS信息示例
    • 10.2、ROW OPERATIONS信息说明
  • 11、总结

1、SHOW ENGINE INNODB STATUS概述

MySQL的SHOW ENGINE INNODB STATUS命令用于显示InnoDB存储引擎的状态信息，包括在途事务、锁、缓冲池和日志文件等，从而帮助诊断数据库性能问题。

MySQL的SHOW ENGINE INNODB STATUS命令用于显示InnoDB存储引擎的状态信息，包括在途事务、锁、缓冲池和日志文件等，从而帮助诊断数据库性能问题。

2、信号量（Semaphores）

2.1、信号量信息示例

----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 966159
OS WAIT ARRAY INFO: signal count 977049
RW-shared spins 0, rounds 1931889, OS waits 956497
RW-excl spins 0, rounds 87774, OS waits 1228
RW-sx spins 11669, rounds 180155, OS waits 3364
Spin rounds per wait: 1931889.00 RW-shared, 87774.00 RW-excl, 15.44 RW-sx

2.2、信号量信息说明

- “OS WAIT ARRAY INFO”：提供了关于InnoDB存储引擎等待操作系统的信息。
- “reservation count”：当前已经在等待操作系统资源的请求数量。
- “signal count”：InnoDB已经完成等待并收到来自操作系统的信号的数量。"reservation count"和"signal count"这两个值的差异通常表示正在等待的请求数量。
- “RW-shared spins 0, rounds 1931889, OS waits 956497”：表示已经有1931889次获取共享读锁，其中没有自旋等待（即"RW-shared spins"的值为0），操作系统层面等待（即上下文切换）次数为为956497次（即"OS waits"的值为956497）。之所以有操作系统层面等待，是由于锁资源被其他事务占用，共享锁的获取请求需要在操作系统层面等待。
- “RW-excl spins 0, rounds 87774, OS waits 1228”：表示已经有87774次获取排它锁，其中没有自旋等待（即"RW-excl spins"的值为0），操作系统层面等待次数为1228次。
- “RW-sx spins 11669, rounds 180155, OS waits 3364”：表示已经有180155次获取意向锁，其中自旋等待次数为11669次，操作系统层面等待有3364次。
- “Spin rounds per wait: 1931889.00 RW-shared, 87774.00 RW-excl, 15.44 RW-sx”：“Spin rounds per wait”

2.3、知识点：CPU自旋(SPIN)

- CPU的自旋用于等待共享资源的可用性。当一个线程需要使用一个共享资源时，如果该资源当前正在被另一个线程占用，那么该线程可以选择自旋等待，而不是立即挂起或进入睡眠状态。在自旋等待期间，线程会反复执行一个短小的循环，检查共享资源是否已经可用。如果该资源仍然不可用，线程会继续自旋，直到该资源变得可用或达到了一定的自旋次数后再挂起或进入睡眠状态进行等待（OS WAIT）。
- 自旋等待的优点：可以避免线程上下文切换的开销，从而提高程序的性能。
- 自旋等待的缺点：会占用CPU的时间，导致其他线程无法获得CPU时间片，从而影响整个程序的性能。所以有时我们看到系统的CPU利用率很高，但也许并不是真正地在做事，而是CPU正在空转等待资源。
- 自旋等待适用于共享资源的竞争情况较少，且自旋等待时间较短的情况下，可以提高程序的性能。而在竞争激烈或自旋等待时间较长的情况下，应该避免使用自旋等待，而选择其他的同步机制，如信号量、互斥锁等。

2.3、信号量中的OS WAIT ARRAY INFO

- OS WAIT ARRAY INFO表示当前的操作系统等待，如果每秒有几万次的OS WAIT，那么很可能系统中存在性能问题。对数据库有高并发访问时，可能会看到这部分信息，因为InnoDB自旋等待超过了阈值，就会触发操作系统等待，如果等待通过自旋能够解决，那么这些信息就不会显示了。通过检查这部分信息，可以大致判断负荷的热点在哪里。
- 由于输出行只包含了一些文件名，因此还需要有一些源码的知识，才能判断出现等待的真实原因。reservation count和signal count的值表征了InnoDB需要OS WAIT的频率。也可以使用操作系统命令，如vmstat，通过检查上下文切换（context switch）的频率来确认OS WAIT的严重程度。
- 大量的spin waits和spin rounds，意味着CPU在空转而没有实际做事，这会消耗大量的CPU资源。
- 通过调整innodb_sync_spin_loops参数，可以在CPU资源消耗和上下文切换之间找到平衡点。

3、死锁

3.1、死锁信息示例

以下是一个SHOW ENGINE INNODB STATUS中的死锁信息示例：

------------------------
LATEST DETECTED DEADLOCK
------------------------
2024-04-02 15:12:50 140542058202880
*** (1) TRANSACTION:
TRANSACTION 2882883969, ACTIVE 0 sec
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 6
MySQL thread id 8304843, OS thread handle 140519686805248, query id 3612643601 192.168.205.89 oper_dc updating
delete from yts_task_lock where expire_time<1712041970561 limit 100

*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 375337 page no 6 n bits 792 index idx_expire_time of table `fiecc`.`yts_task_lock` trx id 2882883969 lock_mode X locks rec but not gap
Record lock, heap no 674 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 8; hex 8000018e9d9797e5; asc         ;;
 1: len 8; hex 000000000027296e; asc      ')n;;


*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 375337 page no 9 n bits 200 index PRIMARY of table `fiecc`.`yts_task_lock` trx id 2882883969 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 000000000027297d; asc      ')};;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f09a9; asc        ;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 68 bytes);
 4: len 8; hex 8000018e9d969499; asc         ;;
 5: len 17; hex 796f6e6269702d66692d6570636d776562; asc yonbip-fi-epcmweb;;


*** (2) TRANSACTION:
TRANSACTION 2882883965, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 6
MySQL thread id 8284300, OS thread handle 140520170850048, query id 3612643593 192.168.205.89 oper_dc updating
delete from yts_task_lock where expire_time<1712041970559 limit 100

*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 375337 page no 9 n bits 200 index PRIMARY of table `fiecc`.`yts_task_lock` trx id 2882883965 lock_mode X locks rec but not gap
Record lock, heap no 20 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 000000000027297d; asc      ')};;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f09a9; asc        ;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 68 bytes);
 4: len 8; hex 8000018e9d969499; asc         ;;
 5: len 17; hex 796f6e6269702d66692d6570636d776562; asc yonbip-fi-epcmweb;;

Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 000000000027297e; asc      ')~;;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f0a26; asc       &;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 70 bytes);
 4: len 8; hex 8000018e9d9694a1; asc         ;;
 5: len 17; hex 796f6e6269702d66692d6570636d776562; asc yonbip-fi-epcmweb;;

Record lock, heap no 22 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 000000000027297f; asc      ') ;;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f0aa5; asc        ;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 68 bytes);
 4: len 8; hex 8000018e9d9698fb; asc         ;;
 5: len 13; hex 796f6e6269702d66692d656363; asc yonbip-fi-ecc;;

Record lock, heap no 23 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 0000000000272980; asc      ') ;;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f0b22; asc       ";;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 70 bytes);
 4: len 8; hex 8000018e9d969902; asc         ;;
 5: len 13; hex 796f6e6269702d66692d656363; asc yonbip-fi-ecc;;

Record lock, heap no 24 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 0000000000272981; asc      ') ;;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f0ba1; asc        ;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 68 bytes);
 4: len 8; hex 8000018e9d96bfbd; asc         ;;
 5: len 13; hex 796f6e6269702d66692d656d6c; asc yonbip-fi-eml;;

Record lock, heap no 25 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 8; hex 0000000000272982; asc      ') ;;
 1: len 6; hex 0000abd5517d; asc     Q};;
 2: len 7; hex 020000c00f0c1e; asc        ;;
 3: len 30; hex 636f6d2e796f6e796f752e636c6f75642e7974732e7363686564756c6572; asc com.yonyou.cloud.yts.scheduler; (total 70 bytes);
 4: len 8; hex 8000018e9d96bfc5; asc         ;;
 5: len 13; hex 796f6e6269702d66692d656d6c; asc yonbip-fi-eml;;


*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 375337 page no 6 n bits 792 index idx_expire_time of table `fiecc`.`yts_task_lock` trx id 2882883965 lock_mode X locks rec but not gap waiting
Record lock, heap no 674 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 8; hex 8000018e9d9797e5; asc         ;;
 1: len 8; hex 000000000027296e; asc      ')n;;

*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 2883518659
Purge done for trx's n:o < 2883451231 undo n:o < 0 state: running but idle
History list length 28104
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422059629081496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628974032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628969992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628991000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629069376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629020088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628915048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628909392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628851216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628855256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628830208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629212392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629033824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629049984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629028168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629003120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628934440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629178456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628975648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628957872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629175224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628884344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629209160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629208352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629206736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629205120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628902928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629204312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629202696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629201080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629201888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629200272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629198656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629196232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629195424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628847176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629194616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629193000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629191384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629190576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628890808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629189768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629188152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629187344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629167144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629186536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629184920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629184112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629180880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629180072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629121088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629110584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628859296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629054832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629179264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629177648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629176032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629172800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629171992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629163104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629152600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629163912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629111392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629148560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628893232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629151792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629043520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629041096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629010392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628872224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628879496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628828592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629162296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629150984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629039480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629146944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628970800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628940904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628961104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628901312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629146136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629138864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629096040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629119472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628941712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629138056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629136440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629132400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629133208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629131592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629030592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629129168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629126744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629124320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629123512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629058872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629052408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629118664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629116240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629113008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629037056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628889192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629112200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629108160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628999888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629107352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629106544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629075032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629104928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629085536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628898080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628926360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628997464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629104120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629102504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629063720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629059680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628853640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629087960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628946560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629066144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628942520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629022512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629083112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629096848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628944136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628927976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629095232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628902120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628955448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628852832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629094424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629092808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628967568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628986152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628915856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629086344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629053216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628911008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628887576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628881920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628871416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629079880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629079072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629066952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628862528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628843944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629027360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628882728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628877880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629058064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628936864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628876264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628834248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629021704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628912624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628954640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629075840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629067760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628962720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629042712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628993424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629012008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628938480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628956256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628937672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629035440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628987768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628904544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628864144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628840712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628923936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628971608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628963528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628949792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628868184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628965144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628838288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628936056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628929592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628861720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628842328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628827784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629181688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628899696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628858488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628880304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629169568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629160680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629161488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628974840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629037864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629159064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629142904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628951408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629125936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629120280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629048368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629016048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628948176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628835056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629077456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629071800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629036248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628973224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628865760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628843136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629007160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629040288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628995848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628986960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628886768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628839096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628870608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628961912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629049176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628952216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629099272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629000696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628826976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629051600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629047560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629008776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628940096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629045136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628978072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628914240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628907776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628898888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629024936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629018472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628988576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628964336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628935248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628945752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628890000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629026552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628966760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628989384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628910200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628885152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628867376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628923128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629210776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629176840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629174416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628875456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629171184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629173608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629097656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629170376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629164720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629156640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629083920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628885960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629155832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629155024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629034632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628930400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628895656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628841520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629050792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629129976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628960296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629020896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629114624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629072608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629014432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629013624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628846368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628913432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628868992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628833440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628897272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629070184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629029784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629193808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629113816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629333592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629332784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629327936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629326320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628863336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629325512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629324704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629323088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628958680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629154216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629323896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629321472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629320664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629277840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628957064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628927168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629316624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629315816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629314200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629308544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629305312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629306120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629302888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629301272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629300464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629006352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629302080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629299656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629298848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628891616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629322280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629296424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629295616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629294808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629298040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629297232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629293192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629292384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629291576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629290768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629289960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629287536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629288344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629289152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629286728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629285920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629285112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629284304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629283496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629282688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629281880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629279456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629280264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629278648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629277032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629276224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629275416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629274608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629273800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629272992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629272184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629270568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629269760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629268952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629268144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629267336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629266528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629264912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629261680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629262488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629260064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629259256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629258448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629256024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629252792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629254408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629251984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628982920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629249560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629253600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629003928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629256832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629271376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629251176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629250368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628911816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629248752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629247944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629247136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629246328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629244712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629245520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629243904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629240672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629237440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629239056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629222896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629214008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629167952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628903736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628839904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629121896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629243096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629242288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628922320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628943328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629241480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628978880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628881112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628959488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629239864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628831824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629235016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629221280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629219664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629215624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629214816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629183304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629182496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628835864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629150176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629149368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628894040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628990192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628892424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629143712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629137248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629140480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629033016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629128360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629127552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629065336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628921512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628847984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629055640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629041904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629025744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629016856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628950600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628981304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629115432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629105736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629103312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629100888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629100080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629091192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629084728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628933632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629038672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629064528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629031400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629007968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628918280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628869800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628832632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628856064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628836672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628878688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629089576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629088768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629078264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628831016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628919088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629062912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628998272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629056448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628984536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628906968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628837480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628972416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629076648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629017664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628852024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629145328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628894848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629045944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628896464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628877072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628999080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628983728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628985344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628947368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628928784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629134016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629090384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628996656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628976456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629082304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628919896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629068568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629046752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629023320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629002312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628939288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628845560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628991808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629117048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628995040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628857680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628849600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628906160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628917472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629061296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629199464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629197040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629188960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629101696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629139672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629122704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629054024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629062104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629057256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629044328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628953832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628888384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628932016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629032208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628864952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629093616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629074224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628944944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628848792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629230976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628920704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629165528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629229360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629228552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628873032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628931208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628874648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628866568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628856872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629207544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629203504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629197848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629185728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629168760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629166336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629144520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629159872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629158256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629157448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628883536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629142096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629147752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629135632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629134824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629109776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628844752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628969184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628965952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628925552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628860104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628916664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628924744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628854448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628948984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629092000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629087152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629060488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628953024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629015240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629011200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628980496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629024128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628977264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628994232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629080688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629192192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628968376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629153408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629130784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629125128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629073416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629005544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628992616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628932824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628873840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629028976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629001504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628850408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628905352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629070992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629386112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629009584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629225320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628860912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629019280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628908584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628979688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628900504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628982112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629236632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629233400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629226936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629223704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629220472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629218856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629213200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629211584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629209968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629012816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629205928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059629294000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628829400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422059628826168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)

3.2、死锁信息说明

• 死锁信息展示了是哪些事务导致了死锁、死锁过程中它们的状态、它们持有的锁、要等待的锁、回退到哪个事务等内容。需要留意的是，死锁信息这里只显示了事务中最近的语句，而实际上占据资源的可能是事务中前面的语句。在一些简单情况下，可以通过SHOW ENGINE INNODB STATUS的输出确认导致死锁的原因；在复杂的情况下，则需要打开通用日志，检查具体各个事务是如何互相等待资源从而导致死锁的。MySQL 5.6可以通过参数innodb_print_all_deadlocks将死锁信息打印到错误日志中。
• 这里由输出的最后一行可以得知，回退到了事务1。

4、外键冲突

4.1、外键冲突信息示例

------------------------
LATEST FOREIGN KEY ERROR
------------------------
2024-04-01 16:14:33 140519512168192 Transaction:
TRANSACTION 2852435340, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1
MySQL thread id 7885902, OS thread handle 140519512168192, query id 3416325072 192.168.205.134 oper_dc update
INSERT INTO t_ds_task_instance  ( name,
task_type,
process_instance_id,
task_code,
task_definition_version,
state,
first_submit_time,
submit_time,
retry_times,
alert_flag,
pid,
flag,
max_retry_times,
retry_interval,
task_instance_priority,
worker_group,
environment_code,
executor_id,
delay_time,
task_params,
dry_run,
task_group_id,
cpu_quota,
memory_max,
task_execute_type,
job_id,
project_id,
sql_source,
bussiness_id,
executable )  VALUES  ( '上缴管理费用明细_goldkinn_data_flow_11',
'SHELL',
614953,
2691351714103296,
74,
0,
'2024-04-01 16:14:33.44',
'2024-04-01 16:14:33.44',



Foreign key constraint fails for table `iuap_data_dolphinscheduler`.`t_ds_task_instance`:
,
  CONSTRAINT `foreign_key_instance_id` FOREIGN KEY (`process_instance_id`) REFERENCES `t_ds_process_instance` (`id`) ON DELETE CASCADE
Trying to add in child table, in index process_instance_id tuple:
DATA TUPLE: 2 fields;
 0: len 4; hex 80096229; asc   b);;
 1: len 4; hex c419a2bd; asc     ;;

But in parent table `iuap_data_dolphinscheduler`.`t_ds_process_instance`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 45; compact format; info bits 0
 0: len 4; hex 8009623a; asc   b:;;
 1: len 6; hex 0000aa00d673; asc      s;;
 2: len 7; hex 02000053330c9a; asc    S3  ;;
 3: len 30; hex e68a95e8b584e99b86e59ba24e43e587bae6b996e4bbbbe58aa1e7babf5f; asc             NC               _; (total 70 bytes);
 4: len 8; hex 80000a4916f6a180; asc    I    ;;
 5: len 4; hex 80000016; asc     ;;
 6: len 1; hex 87; asc  ;;
 7: len 30; hex 5b7b2274696d65223a22323032342d30342d30312031363a30323a303022; asc [{"time":"2024-04-01 16:02:00"; (total 271 bytes);
 8: len 1; hex 80; asc  ;;
 9: len 5; hex 99b3030080; asc      ;;
 10: len 5; hex 99b30300b9; asc      ;;
 11: len 4; hex 80000001; asc     ;;
 12: len 20; hex 3139322e3136382e3230352e3132343a38373635; asc 192.168.205.124:8765;;
 13: len 1; hex 86; asc  ;;
 14: len 30; hex 7b227363686564756c655f74696d657a6f6e65223a22417369612f536861; asc {"schedule_timezone":"Asia/Sha; (total 37 bytes);
 15: len 1; hex 82; asc  ;;
 16: len 1; hex 80; asc  ;;
 17: len 1; hex 81; asc  ;;
 18: len 1; hex 81; asc  ;;
 19: len 4; hex 80000000; asc     ;;
 20: len 5; hex 99b3030080; asc      ;;
 21: len 5; hex 99b3030080; asc      ;;
 22: len 30; hex 5b7b2270726f70223a227974656e616e746964222c22646972656374223a; asc [{"prop":"ytenantid","direct":; (total 67 bytes);
 23: len 1; hex 81; asc  ;;
 24: len 4; hex 660a6a31; asc f j1;;
 25: len 4; hex 80000000; asc     ;;
 26: len 4; hex 80000002; asc     ;;
 27: len 9; hex 5343484544554c4552; asc SCHEDULER;;
 28: len 4; hex 80000002; asc     ;;
 29: len 7; hex 64656661756c74; asc default;;
 30: len 8; hex 7fffffffffffffff; asc         ;;
 31: len 4; hex 80000000; asc     ;;
 32: len 4; hex 7fffffff; asc     ;;
 33: len 2; hex 5b5d; asc [];;
 34: len 1; hex 80; asc  ;;
 35: len 4; hex 80000000; asc     ;;
 36: len 5; hex 99b3030080; asc      ;;
 37: len 4; hex 80000000; asc     ;;
 38: len 8; hex 8424225329d96214; asc  $"S) b ;;
 39: len 8; hex 840427435abbc2d0; asc   'CZ   ;;
 40: len 2; hex 3138; asc 18;;
 41: SQL NULL;
 42: len 1; hex 33; asc 3;;
 43: len 1; hex 30; asc 0;;
 44: SQL NULL;

4.2、外键冲突信息说明

外键冲突信息主要需要开发人员注意。

5、事务信息

SHOW ENGINE INNOD STATUS一般只显示部分事务，因为事务列表可能会很长。

5.1、事务信息示例

------------
TRANSACTIONS
------------
Trx id counter 1752317
Purge done for trx's n:o < 1747534 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421837837867744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421837837866832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421837837872304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421837837870480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421837837869568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421837837868656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)

5.2、事务信息说明

5.2.1、Trx id counter ...

Trx id counter后面跟的事当前事务号。trx id counter其实表示已分配的事务ID（transaction ID）计数器的值，每新增一个事务就加1，直到达到最大值，然后重新循环使用。

5.2.2、Purge done for trx's n:o < ...

• "<"后的值是最近一次进行线程清理的事务号，这个值表示已经完成了所有小于该事务ID的清理操作。
• 事务如果过期，则可以被清除，清除的标准是这些事务已经提交，且不会再被其他的事务所需要。在InnoDB存储引擎中，Purge操作是一个重要的后台任务，它负责删除已经标记为已提交的事务的undo log和版本。因为undo log是用来撤消事务所做的更改，而版本是用来实现多版本并发控制（MVCC）的机制，所以Purge操作的完成很重要，可以释放磁盘空间并保持系统的稳定性。
• 我们可以检查当前事务号和最近一次进行线程清理的事务号的差异，例如，0（64位）80154573（32位）与0（64位）80157601（32位），如果差异很大，则可能有大量事务或者长事务，可能会导致UNDO空间暴涨。
• "Purge done for trx’s n:o < 1747534"表示已经完成了所有小于事务ID 1747534 的Purge操作。这意味着所有小于1747534的已提交事务的版本和undo log都已经被删除。

5.2.3、undo n:o < ...

• "<"后的值是最近一次进行线程清理的UNDO日志号。注意，这里不是事务号，而是UNDO日志号。
• "undo n:o < 0"表示所有的undo log都已经被清理。这是因为在InnoDB存储引擎中，所有的undo log都是从事务ID 1 开始创建的，而"undo n:o < 0"的意思是所有小于事务ID 0 的undo log都已经被清理，这实际上就是所有的undo log都已经被清理了。

5.2.4、state: running but idle

• "state: running but idle"意味着InnoDB存储引擎当前没有正在执行的查询或事务，但它仍在运行并等待下一个操作，意味着InnoDB引擎正在运行但处于空闲状态，这通常是一个正常的状态。

5.2.5、History list length ...

• "History list length"表示InnoDB存储引擎中的历史记录列表长度。InnoDB使用历史记录列表（history list）来跟踪每个数据页的修改历史记录。当一个数据页发生修改时，InnoDB会将修改前的数据页复制到历史记录列表中，以便在需要回滚时可以使用。

• 如果这个值比较大，说明系统中有很多数据页发生过修改，因此历史记录列表中的数据页也比较多。这可能会导致一些性能问题，因为历史记录列表的长度会影响InnoDB存储引擎的内存使用和性能。

• LIST OF TRANSACTIONS FOR EACH SESSION：每个事务都有两个状态，即not started或active。在生产系统中，同时运行的线程一般最多只有几个，所以大部分事务都是not started。如果SHOW INNODB STATUS显示有很多线程在等待（wai ting in InnoDB queue或sleeping before joining InnoDB queue）进入队列，那么往往是有性能上的问题，导致系统挂死。

5.2.6、LIST OF TRANSACTIONS FOR EACH SESSION: ...

• "LIST OF TRANSACTIONS FOR EACH SESSION:"会列出正在运行的事务的列表，但通常只显示部分事务，因为整个列表可能很长。
• 每个事务都有两个状态，即not started或active。在生产系统中，同时运行的线程一般最多只有几个，所以大部分事务都是not started。
• "lock struct(s)"表示当前系统中的锁定结构数量，"heap size"表示锁定结构在内存中的大小，"row lock(s)"表示当前系统中的行锁数量。

6、I/O信息

6.1、I/O信息示例

FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests ((null))
I/O thread 1 state: waiting for completed aio requests (insert buffer thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:
Pending flushes (fsync) log: 0; buffer pool: 0
190176908 OS file reads, 1306222192 OS file writes, 328918883 OS fsyncs
8.68 reads/s, 16384 avg bytes/read, 774.35 writes/s, 369.94 fsyncs/s

6.2、I/O信息说明

• “Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0]”："aio"是异步输入输出（Asynchronous I/O）的缩写。“Pending normal aio reads"表示当前等待完成的异步读请求数量，每个数字对应不同的线程池。例如，”[0, 0, 0, 0]"表示四个线程池中没有等待完成的异步读请求。同样地，“aio writes"表示当前等待完成的异步写请求数量，每个数字对应不同的线程池。例如，”[0, 0, 0, 0]"表示四个线程池中没有等待完成的异步写请求。如果为非零值，则可能存在I/O瓶颈。
• “Pending flushes (fsync) log: 0; buffer pool: 0”："Pending flushes"表示待刷新的数据页数量，"fsync"是一种同步刷新磁盘缓存的方式，"log"和"buffer pool"分别表示日志和缓冲池。"Pending flushes (fsync) log"表示待刷新到磁盘的日志页数量，如果该数字过高，可能意味着系统出现了日志写入瓶颈，需要进行进一步的调优。同样地，"Pending flushes (fsync) buffer pool"表示待刷新到磁盘的缓冲池页数量，如果该数字过高，可能意味着系统出现了缓冲池写入瓶颈，需要进行进一步的调优。

7、插入缓存和自适应索引信息

7.1、插入缓存和自适应索引信息示例

-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 932, seg size 934, 884500 merges
merged operations:
 insert 2183814, delete mark 54378971, delete 2070188
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 9562499, node heap has 123121 buffer(s)
Hash table size 9562499, node heap has 5365 buffer(s)
Hash table size 9562499, node heap has 2099 buffer(s)
Hash table size 9562499, node heap has 3057 buffer(s)
Hash table size 9562499, node heap has 2241 buffer(s)
Hash table size 9562499, node heap has 2037 buffer(s)
Hash table size 9562499, node heap has 1226 buffer(s)
Hash table size 9562499, node heap has 1719 buffer(s)
367751.28 hash searches/s, 10089.84 non-hash searches/s

7.2、插入缓存和自适应索引信息说明

“Ibuf: size 1, free list len 932, seg size 2, 884500 merges”："Ibuf"表示Insert Buffer，"size 1"表示当前Insert Buffer的大小，"free list len 932"表示空闲列表的长度，"seg size 934"表示Insert Buffer中每个段的大小，"884500 merges"表示已经执行的合并次数。

7.3、Insert Buffer（插入缓存）

Insert Buffer是一种用于缓存插入操作的数据结构，可以减少磁盘I/O的次数，提高插入性能。在执行插入操作时，Insert Buffer首先将数据写入内存中的缓存，然后在合适的时机将缓存中的数据刷新到磁盘上。由于磁盘I/O的速度比内存慢很多，Insert Buffer可以大大提高插入操作的效率。

8、LOG

8.1、LOG信息示例

---
LOG
---
Log sequence number          11073658273573
Log buffer assigned up to    11073658273573
Log buffer completed up to   11073658273573
Log written up to            11073658273573
Log flushed up to            11073658273573
Added dirty pages up to      11073658273573
Pages flushed up to          11073129383327
Last checkpoint at           11073083240522
Log minimum file id is       4783
Log maximum file id is       4794
1074834999 log i/o's done, 326.45 log i/o's/second

8.2、LOG信息说明

• “Log sequence number 1676631265”：表空间创建后写入log buffer的字节数，这个值可以用来衡量日志的写入速度。通过多次采样Log sequence number的输出，可以获取每秒写入的日志量。如果我们要设置InnoDB事务日志的大小，那么能保持连续写入日志30~60分钟为佳。
• “Log flushed up to 1676631265”：最近刷写到事务日志文件的位置。由此可以计算还有多少未刷新到日志文件（logfile）的数据。如果这些数据大于innodb_log_buffer_size的30%，那么就要考虑是否应增加日志缓冲（log buffer）了。
• “Pages flushed up to 1676631265”：最近刷写到磁盘的数据页的位置。
• “Last checkpoint at 1676631256”：最近一次检查点的位置。
• “0 pending log flushes, 0 pending chkp writes”：pending如果大于0，则可能有I/O瓶颈。

9、缓冲池信息

9.1、缓冲池信息示例

----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 73000004
Buffer pool size   2359081
Free buffers       16339
Database pages     2201877
Old database pages 812785
Modified db pages  20691
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 49854833, not young 8831466968
27.37 youngs/s, 236.96 non-youngs/s
Pages read 190108371, created 183500333, written 216251212
8.68 reads/s, 7.71 creates/s, 350.94 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 2201877, unzip_LRU len: 0
I/O sum[39544]:cur[48], unzip sum[0]:cur[0]

9.2、缓冲池信息说明

• “Total large memory allocated”、“Dictionary memory allocated”、“Buffer pool size”、"Free buffers "单位都是字节。
• "xx pages"的单位都是页面个数
• “Buffer pool hit rate”（缓冲池命中率）：这是这段信息里最重要的指标。在这个例子中，缓冲池命中率为1000/1000，表示所有请求都可以从缓冲池中得到所需的页面，这是非常理想的情况。如果命中率较低，可能意味着缓冲池设置过小或者存在过多的数据读取请求，需要进一步进行调整和优化。

10、ROW OPERATIONS信息

10.1、ROW OPERATIONS信息示例

--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=17149, Main thread ID=140362560964352, state: sleeping
Number of rows inserted 11021637, updated 592, deleted 376466, read 233292619921
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

10.2、ROW OPERATIONS信息说明

ROW OPERATIONS是行操作信息，需要留意的是如果“0 queries in queue”不为0，则是有查询需要等待，可能意味着系统忙，你需要做进一步的诊断。

11、总结

SHOW ENGINE INNODB STATUS会提供关于InnoDB引擎的很多有用信息，包括操作系统等待、死锁、外键冲突、在途事务、I/O、插入缓存、自适应索引、日志、缓冲池和行操作等信息。
特别要注意事务中Undo清理是否足够及时（不会导致Undo空间暴涨）、输入输出是否存在Pending、日志刷写是否及时等。

————————————————
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
原文链接：https://blog.csdn.net/oddrock/article/details/130201152