在现代数据库应用中，MySQL作为一款广泛使用的开源关系型数据库，为企业提供了高效的数据存储和管理能力。然而，随着数据库负载的增加和复杂度的提升，MySQL死锁问题逐渐成为影响系统性能和稳定性的重要因素。本文将深入探讨MySQL死锁的成因、检测方法以及处理策略，帮助企业更好地应对这一挑战。

什么是MySQL死锁？

MySQL死锁是指两个或多个事务在访问共享资源时发生相互等待，导致所有相关事务都无法继续执行的现象。这种情况下，数据库系统会检测到死锁并回滚其中一个或多个事务，以释放被锁定的资源。

死锁的典型场景

1. 事务间的资源竞争事务A持有资源X，事务B持有资源Y，两者都需要对方的资源才能继续执行，从而陷入僵局。

2. 锁等待链事务1等待事务2释放锁，事务2又在等待事务1释放锁，形成循环依赖。

3. 锁超时当事务等待锁的时间超过系统配置的超时阈值时，MySQL会主动检测并回滚其中一个事务。

死锁对数据库的影响

1. 事务回滚死锁发生时，MySQL会回滚其中一个事务，导致数据一致性受到影响。

2. 性能下降死锁会导致事务等待时间增加，进而影响数据库的整体响应速度。

3. 用户体验问题业务系统可能会因为事务回滚而出现数据不一致或错误提示，影响用户体验。

4. 资源浪费死锁会占用数据库连接和锁资源，导致资源浪费。

MySQL死锁的检测方法

1. 锁等待事件

MySQL通过INNODB_LOCKS和INNODB_LOCK_WAITS系统表记录锁等待事件。可以通过以下查询获取死锁信息：

SELECT     r.trx_id AS blocking_trx_id,    r.trx_state AS blocking_trx_state,    r.trx_started,    r.trx_wait_start,    r.trx_wait_end,    r.trx_wait_time,    r.trx_wait_count,    r.trx_mysql_thread_id,    r.trx_isolation_level,    r.trx_unique_id,    r.trx_lock_mode,    r.trx_lock_type,    r.trx_lock_table,    r.trx_lock_index,    r.trx_lock_page,    r.trx_lock_row,    r.trx_lock_status,    r.trx_lock_duration,    r.trx_lock_count,    r.trx_lock_memory,    r.trx_lock_memory_free,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,    r.trx_lock_memory_internal,    r.trx_lock_memory_external,    r.trx_lock_memory_total,    r.trx_lock_memory_used,    r.trx_lock_memory_wasted,    r.trx_lock_memory_fragmentation,    r.trx_lock_memory_high_water,    r.trx_lock_memory_low_water,    r.trx_lock_memory_max,    r.trx_lock_memory_min,    r.trx_lock_memory_step,    r.trx_lock_memory_overhead,