在数据库系统中，InnoDB死锁是一个常见的问题，尤其是在高并发场景下。死锁会导致事务无法正常提交，甚至引发数据库性能下降或服务中断。对于企业用户来说，及时发现和解决InnoDB死锁问题至关重要。本文将从日志分析、事务管理技巧以及预防措施等方面，详细讲解如何排查和解决InnoDB死锁问题。

一、InnoDB死锁的基本概念

InnoDB是MySQL中最常用的存储引擎，支持事务、行级锁和外键约束等功能。然而，事务的并发执行可能导致死锁的发生。死锁是指两个或多个事务彼此等待对方释放资源，导致所有相关事务都无法继续执行的情况。

死锁的常见原因

1. 资源竞争：多个事务同时尝试访问同一资源（如行、锁）。
2. 锁顺序不一致：事务之间锁的获取顺序不一致，导致相互等待。
3. 事务隔离级别过高：高隔离级别可能导致更多的锁竞争。
4. 长事务：长时间未提交或回滚的事务会占用资源，增加死锁风险。

二、InnoDB死锁的日志分析

InnoDB会在错误日志中记录死锁的相关信息，这些信息对于排查问题至关重要。通过分析日志，可以快速定位死锁的根本原因。

1. 查看错误日志

InnoDB会在发生死锁时输出类似以下信息：

2023-10-01 12:34:56 1028 [ERROR] InnoDB: Deadlock found when trying to lock 2 rows.

日志中会包含死锁发生的时间、涉及的事务信息以及锁的详细情况。

2. 解析死锁日志

日志中会提供两个事务的信息，包括事务的undo log和trx id。通过这些信息，可以进一步分析事务的执行路径和锁的分布。

示例：

** Transaction 1 ( trx id 1234, undo log 5678 ):   lock wait timeout for 1 row lock,   heap no 0,   table `users`,   index `PRIMARY`,  trx_started 2023-10-01 12:34:55,  trx_state RUNNING,  trx pymysql 123456,  trx_rows 10,  trx_locks 0x700000000000,  trx_concurrency 0,  trx_isolation level REPEATABLE READ,  trx_unique_trx id 1234,  trx_mysql_thread_id 123456,  trx_prio 0,  trx_wait 0,  trx_wait_age 0,  trx_age 0,  trx_lock_age 0,  trx_lock_waits 0,  trx_lock_rounds 0,  trx_lock_time 0,  trx_lock_deadline 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,  trx_lock_spin_waits 0,  trx_lock_spin_time 0,  trx_lock_spin_age 0,  trx_lock_count 0,  trx_lock_spin_rounds 0,