在线db show innodb status显示如下信息(2) TRANSACTION:
TRANSACTION 1 617222768, ACTIVE 0 sec, process no 31064, OS thread id 1180895552 inserting, thread declared inside InnoDB 479
mysql tables in use 1, locked 1
1348 lock struct(s), heap size 178160, undo log entries 52
MySQL thread id 328348, query id 5940809681 192.168.10.30 betbrain update
insert into ahistory ( id.....
............数据省略
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 577937 n bits 904 index `idx_EP_participantId_history` of table `oddsmatrixdb/EventParticipant_history` trx id 1 617222768 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;Record lock, heap no 64 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011b3eb0b; asc ;;Record lock, heap no 68 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a5528e; asc R ;;Record lock, heap no 69 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a4cd33; asc 3;;Record lock, heap no 70 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a55290; asc R ;;Record lock, heap no 71 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3e7fc; asc ;;Record lock, heap no 72 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3eac5; asc ;;Record lock, heap no 73 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3f908; asc ;;Record lock, heap no 74 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3fb15; asc ;;Record lock, heap no 75 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40275; asc u;;Record lock, heap no 76 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40767; asc g;;Record lock, heap no 77 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40859; asc Y;;Record lock, heap no 78 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40acf; asc ;;Record lock, heap no 79 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a41863; asc c;;Record lock, heap no 80 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a42f9c; asc / ;;Record lock, heap no 81 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a4358b; asc 5 ;;Record lock, heap no 82 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a43fb2; asc ? ;;Record lock, heap no 83 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a445c4; asc E ;;Record lock, heap no 84 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a48bcd; asc ;;Record lock, heap no 85 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a4c4f2; asc ;;Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc ;;
-------下面重复还有几十条这里
Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc 出现太多次
是否意味着 死锁频繁1天内发生? (在线mysql , 以前确实没有看到这么多的
Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc
以前最多几条
) Record lock, heap no 87 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a51d7b; asc
TRANSACTION 1 617222768, ACTIVE 0 sec, process no 31064, OS thread id 1180895552 inserting, thread declared inside InnoDB 479
mysql tables in use 1, locked 1
1348 lock struct(s), heap size 178160, undo log entries 52
MySQL thread id 328348, query id 5940809681 192.168.10.30 betbrain update
insert into ahistory ( id.....
............数据省略
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 577937 n bits 904 index `idx_EP_participantId_history` of table `oddsmatrixdb/EventParticipant_history` trx id 1 617222768 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;Record lock, heap no 64 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011b3eb0b; asc ;;Record lock, heap no 68 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a5528e; asc R ;;Record lock, heap no 69 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a4cd33; asc 3;;Record lock, heap no 70 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000011a55290; asc R ;;Record lock, heap no 71 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3e7fc; asc ;;Record lock, heap no 72 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3eac5; asc ;;Record lock, heap no 73 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3f908; asc ;;Record lock, heap no 74 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a3fb15; asc ;;Record lock, heap no 75 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40275; asc u;;Record lock, heap no 76 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40767; asc g;;Record lock, heap no 77 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40859; asc Y;;Record lock, heap no 78 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a40acf; asc ;;Record lock, heap no 79 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a41863; asc c;;Record lock, heap no 80 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a42f9c; asc / ;;Record lock, heap no 81 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a4358b; asc 5 ;;Record lock, heap no 82 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a43fb2; asc ? ;;Record lock, heap no 83 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a445c4; asc E ;;Record lock, heap no 84 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a48bcd; asc ;;Record lock, heap no 85 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a4c4f2; asc ;;Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc ;;
-------下面重复还有几十条这里
Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc 出现太多次
是否意味着 死锁频繁1天内发生? (在线mysql , 以前确实没有看到这么多的
Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc
以前最多几条
) Record lock, heap no 87 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a51d7b; asc
把你的(1) TRANSACTION:
(2) TRANSACTION:都贴出来,看看是什么语句造成的死锁。
量对那个单个大表是 150多万的 原因知道哦啊 只是需要确认下 Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 000000000000004c; asc L;; 1: len 6; hex 000000a512b7; asc 出现太多次
是否意味着 死锁频繁1天内发生?
791965586 lock_mode X
select * from E_history where id=791965586
empty*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 311608 n bits 336 index `GEN_CLUST_INDEX` of table `db`.`E_history` trx id 0 791965586 lock_mode X locks rec but not gap waiting
Record lock, heap no 128 PHYSICAL RECORD: n_fields 10; compact format; info bits 0
0: len 6; hex 00000c937a43; asc zC;; 1: len 6; hex 00002f346f88; asc /4o ;; 2: len 7; hex 000003c0830b99; asc ;; 3: len 8; hex 000000000b1efd8e; asc ;; 4: len 8; hex 000000000000d9df; asc ;; 5: len 1; hex 83; asc ;; 6: len 8; hex 0000000001eadd7c; asc |;; 7: len 1; hex 44; asc D;; 8: len 1; hex 59; asc Y;; 9: len 1; hex 59; asc Y;;