Type Name Status
InnoDB
=====================================
2022-11-21 23:07:27 0x7f8c6e09c700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 3214636 srv_idle
srv_master_thread log flush and writes: 3214636
----------
SEMAPHORES
----------
------------------------
LATEST DETECTED DEADLOCK
------------------------
2022-11-19 17:16:36 0x7f8c747b0700
*** (1) TRANSACTION:
TRANSACTION 27644779809, ACTIVE 0 sec starting index read
mysql tables in use 57, locked 57
LOCK WAIT 131 lock struct(s), heap size 24696, 74 row lock(s), undo log entries 1
MariaDB thread id 2420673, OS thread handle 140241226368768, query id 160191658825 10.48.111.130 dudeuser Updating
UPDATE `2022-11-19` SET `msg_status` = GREATEST(0, `msg_status`), `dlr_received_parts` = `dlr_received_parts` + 1 WHERE `message_id` = "66ccff98-d8ff-4976-91d1-5d13567ae97e"
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 20409 page no 25312 n bits 336 index message_id of table `esms_mis`.`2022-11-19` /* Partition `O11` */ trx id 27644779809 lock_mode X waiting
Record lock, heap no 106 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 36366363666639382d643866662d343937362d393164312d356431333536; asc 66ccff98-d8ff-4976-91d1-5d1356; (total 36 bytes);
1: len 6; hex 0000d4d9d4fb; asc ;;
*** CONFLICTING WITH:
RECORD LOCKS space id 20409 page no 25312 n bits 336 index message_id of table `esms_mis`.`2022-11-19` /* Partition `O11` */ trx id 27644779763 lock_mode X
Record lock, heap no 106 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 36366363666639382d643866662d343937362d393164312d356431333536; asc 66ccff98-d8ff-4976-91d1-5d1356; (total 36 bytes);
1: len 6; hex 0000d4d9d4fb; asc ;;
Record lock, heap no 107 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 36366363666639382d643866662d343937362d393164312d356431333536; asc 66ccff98-d8ff-4976-91d1-5d1356; (total 36 bytes);
1: len 6; hex 0000d4d9d525; asc %;;
*** (2) TRANSACTION:
TRANSACTION 27644779763, ACTIVE 0 sec fetching rows
mysql tables in use 57, locked 57
LOCK WAIT 179 lock struct(s), heap size 24696, 121 row lock(s), undo log entries 2
MariaDB thread id 2420674, OS thread handle 140241102825216, query id 160191658430 10.48.111.130 dudeuser Updating
UPDATE `2022-11-19` SET `msg_status` = GREATEST(0, `msg_status`), `dlr_received_parts` = `dlr_received_parts` + 1 WHERE `message_id` = "66ccff98-d8ff-4976-91d1-5d13567ae97e"
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 20409 page no 70029 n bits 32 index GEN_CLUST_INDEX of table `esms_mis`.`2022-11-19` /* Partition `O11` */ trx id 27644779763 lock_mode X locks rec but not gap waiting
Record lock, heap no 29 PHYSICAL RECORD: n_fields 48; compact format; info bits 0
0: len 6; hex 0000d4d9d525; asc %;;
1: len 6; hex 00066fc1dd21; asc o !;;
2: len 7; hex 720029f90417aa; asc r ) ;;
3: len 8; hex 80000000ffa8b6df; asc ;;
4: len 4; hex 80000001; asc ;;
5: len 4; hex 8000000c; asc ;;
6: len 4; hex 8000000d; asc ;;
7: len 3; hex 800000; asc ;;
8: len 3; hex 800000; asc ;;
9: len 2; hex 0005; asc ;;
10: len 2; hex 000b; asc ;;
11: len 2; hex 0000; asc ;;
12: len 1; hex 02; asc ;;
13: len 1; hex 02; asc ;;
14: len 1; hex 02; asc ;;
15: len 1; hex 00; asc ;;
16: len 1; hex 01; asc ;;
17: len 1; hex 00; asc ;;
18: len 1; hex 01; asc ;;
19: len 1; hex 02; asc ;;
20: len 1; hex 01; asc ;;
21: len 8; hex 99ae6713f100c006; asc g ;;
22: len 5; hex 99ae6713f1; asc g ;;
23: len 8; hex 99ae6713f208dea9; asc g ;;
24: len 5; hex 99ae6713f0; asc g ;;
25: len 5; hex 99ae671400; asc g ;;
26: len 8; hex 99ae671403000000; asc g ;;
27: len 8; hex 99ae6714240351ca; asc g $ Q ;;
28: SQL NULL;
29: SQL NULL;
30: len 8; hex 99ae6713f208e550; asc g P;;
31: len 8; hex 99ae6714240351ca; asc g $ Q ;;
32: SQL NULL;
33: len 30; hex 36366363666639382d643866662d343937362d393164312d356431333536; asc 66ccff98-d8ff-4976-91d1-5d1356; (total 36 bytes);
34: len 19; hex 31303633373332323137313534383632313937; asc 1063732217154862197;;
35: len 24; hex 5a303870766f54476630667438746b596f43357434513d3d; asc Z08pvoTGf0ft8tkYoC5t4Q==;;
36: len 19; hex 31313037313631353732343038363633343531; asc 1107161572408663451;;
37: len 12; hex 313130313030303031353133; asc 110100001513;;
38: len 6; hex 534249505347; asc SBIPSG;;
39: len 4; hex 30303030; asc 0000;;
40: len 8; hex 546573745375626a; asc TestSubj;;
41: SQL NULL;
42: len 30; hex 6769643a31312069643a3130363337333232313731353438363231393720; asc gid:11 id:1063732217154862197 ; (total 122 bytes);
43: len 14; hex 31302e34382e3131312e36372c31; asc 10.48.111.67,1;;
44: SQL NULL;
45: SQL NULL;
46: len 30; hex 623866376338303332616631346265643836356264613932643731643964; asc b8f7c8032af14bed865bda92d71d9d; (total 32 bytes);
47: len 4; hex 80116406; asc d ;;
*** CONFLICTING WITH:
RECORD LOCKS space id 20409 page no 70029 n bits 32 index GEN_CLUST_INDEX of table `esms_mis`.`2022-11-19` /* Partition `O11` */ trx id 27644779809 lock_mode X locks rec but not gap
Record lock, heap no 29 PHYSICAL RECORD: n_fields 48; compact format; info bits 0
0: len 6; hex 0000d4d9d525; asc %;;
1: len 6; hex 00066fc1dd21; asc o !;;
2: len 7; hex 720029f90417aa; asc r ) ;;
3: len 8; hex 80000000ffa8b6df; asc ;;
4: len 4; hex 80000001; asc ;;
5: len 4; hex 8000000c; asc ;;
6: len 4; hex 8000000d; asc ;;
7: len 3; hex 800000; asc ;;
8: len 3; hex 800000; asc ;;
9: len 2; hex 0005; asc ;;
10: len 2; hex 000b; asc ;;
11: len 2; hex 0000; asc ;;
12: len 1; hex 02; asc ;;
13: len 1; hex 02; asc ;;
14: len 1; hex 02; asc ;;
15: len 1; hex 00; asc ;;
16: len 1; hex 01; asc ;;
17: len 1; hex 00; asc ;;
18: len 1; hex 01; asc ;;
19: len 1; hex 02; asc ;;
20: len 1; hex 01; asc ;;
21: len 8; hex 99ae6713f100c006; asc g ;;
22: len 5; hex 99ae6713f1; asc g ;;
23: len 8; hex 99ae6713f208dea9; asc g ;;
24: len 5; hex 99ae6713f0; asc g ;;
25: len 5; hex 99ae671400; asc g ;;
26: len 8; hex 99ae671403000000; asc g ;;
27: len 8; hex 99ae6714240351ca; asc g $ Q ;;
28: SQL NULL;
29: SQL NULL;
30: len 8; hex 99ae6713f208e550; asc g P;;
31: len 8; hex 99ae6714240351ca; asc g $ Q ;;
32: SQL NULL;
33: len 30; hex 36366363666639382d643866662d343937362d393164312d356431333536; asc 66ccff98-d8ff-4976-91d1-5d1356; (total 36 bytes);
34: len 19; hex 31303633373332323137313534383632313937; asc 1063732217154862197;;
35: len 24; hex 5a303870766f54476630667438746b596f43357434513d3d; asc Z08pvoTGf0ft8tkYoC5t4Q==;;
36: len 19; hex 31313037313631353732343038363633343531; asc 1107161572408663451;;
37: len 12; hex 313130313030303031353133; asc 110100001513;;
38: len 6; hex 534249505347; asc SBIPSG;;
39: len 4; hex 30303030; asc 0000;;
40: len 8; hex 546573745375626a; asc TestSubj;;
41: SQL NULL;
42: len 30; hex 6769643a31312069643a3130363337333232313731353438363231393720; asc gid:11 id:1063732217154862197 ; (total 122 bytes);
43: len 14; hex 31302e34382e3131312e36372c31; asc 10.48.111.67,1;;
44: SQL NULL;
45: SQL NULL;
46: len 30; hex 623866376338303332616631346265643836356264613932643731643964; asc b8f7c8032af14bed865bda92d71d9d; (total 32 bytes);
47: len 4; hex 80116406; asc d ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 29254101861
Purge done for trx's n:o < 28998067264 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION (0x7f8c7ca17b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
19098431 OS file reads, 3454609078 OS file writes, 81064586 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 9873586199387
Log flushed up to 9873586199387
Pages flushed up to 9872480458375
Last checkpoint at 9872480458375
0 pending log flushes, 0 pending chkp writes
3119787127 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 71672266752
Dictionary memory allocated 552391752
Buffer pool size 4266912
Free buffers 0
Database pages 4266912
Old database pages 1575077
Modified db pages 91010
Percent of dirty pages(LRU & free pages): 2.133
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 18174283, not young 644432311
0.00 youngs/s, 0.00 non-youngs/s
Pages read 19077516, created 87458669, written 332250630
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4266912, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 1027550792, updated 1815127152, deleted 660384080, read 2394190832630
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================