-
MySQL死锁检查处理的正常方法(2)
- 作者：孙紫潇 分类：win10 发布时间：2021-07-25 09:32:00
+ -------------------+-------------------+-----------------+------------------+ | requesting_trx_id | requested_lock_id | blocking_trx_id | blocking_lock_id | + -------------------+-------------------...
+-------------------+-------------------+-----------------+------------------+| requesting_trx_id | requested_lock_id | blocking_trx_id | blocking_lock_id |+-------------------+-------------------+-----------------+------------------+| 130718499 | 130718499:65:3:4 | 130718500 | 130718500:65:3:4 |+-------------------+-------------------+-----------------+------------------+ #查看当前未提交的事务（如果死锁等待超时,事务可能还没有关闭）mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;+--------------------------------------------------------------------------------------------------------+| trx_id | trx_state | trx_started | trx_requested_lock_id | trx_wait_started | trx_weight |+-----------+-----------+---------------------+-----------------------+---------------------+------------+| 130718500 | RUNNING | 2018-03-12 09:28:10 | NULL | NULL | 3 || 130718499 | LOCK WAIT | 2018-03-12 09:27:59 | 130718499:65:3:4 | 2018-03-12 09:32:48 | 5 |==========================================================================================================| trx_mysql_thread_id | trx_query | trx_operation_state | trx_tables_in_use |+---------------------+---------------------------------------+---------------------+-------------------+| 4 | NULL | NULL | 0 || 5 | update bb set name='bbb' | starting index read | 1 |=========================================================================================================| trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified |+-------------------+------------------+-----------------------+-----------------+-------------------+| 0 | 2 | 360 | 3 | 1 || 1 | 4 | 1184 | 4 | 1 |===========================================================================================================================| trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error |+-------------------------+---------------------+-------------------+------------------------+----------------------------+| 0 | REPEATABLE READ | 1 | 1 | NULL || 0 | REPEATABLE READ | 1 | 1 | NULL |===========================================================================================================================| trx_adaptive_hash_latched | trx_adaptive_hash_timeout | trx_is_read_only | trx_autocommit_non_locking |+---------------------------+---------------------------+------------------+----------------------------+| 0 | 10000 | 0 | 0 || 0 | 10000 | 0 | 0 |+---------------------------+---------------------------+------------------+----------------------------+ #查看正在被访问的表mysql> show OPEN TABLES
猜您喜欢
- 轻松掌握win10看配置技巧，如何检查你..2024-03-26
- 揭秘！如何检查Windows 10是否已成功激..2024-03-24
- Win10提示无法连接打印机？检查打印机..2024-03-12
- Win10磁盘检查卡住？进不去系统？只需..2024-02-25
- 轻松一招：如何检查Win10是否激活，让..2024-02-24
- Win10小技巧：轻松关闭磁盘修复检查..2024-02-02
相关推荐
- win10截屏是黑色怎么回事？..2022-05-15
- nrg是什么格式文件 NRG文件用什么方式..2021-10-03
- 微软Windows10应用商店正式统一：实现跨..2023-06-27
- Win10 PC一周年更新14388有哪些已修复内..2023-03-23
- win10 蓝屏driver power state failure win10笔记..2022-02-28
- win10系统下md格式文件怎么打开 win10系..2021-01-03
