-
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纯净版系统怎么调出帧数?..2021-05-22
- Win10如何安全的给移动硬盘分区?win..2022-09-07
- win10打开屏幕键盘快捷键 windows打开屏..2023-09-17
- win10怎样进入vga模式 win10vga模式怎么进..2022-02-06
- 电脑键盘全图详细图片 键盘108键位对..2023-10-12
- 大师讲解win102004更新总是重启卡死,w..2017-09-19