INNODB STATUS
=====================================
2026-01-16 06:50:06 22849429927680 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 29 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 352962 srv_active, 0 srv_shutdown, 5511784 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 234864
OS WAIT ARRAY INFO: signal count 321965
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2025-11-25 15:41:12 22849737901824
*** (1) TRANSACTION:
TRANSACTION 132954137, ACTIVE 1 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 632 lock struct(s), heap size 90232, 101215 row lock(s), undo log entries 1
MySQL thread id 2577467, OS thread handle 22851108976384, query id 522432169 172.31.45.113 admin executing
UPDATE tblJobRequests j, (SELECT jobid,
sum(CASE when `Status` in ('Confirmed', 'Accepted') then 1 else 0 end ) as `Found`,
sum(CASE when `Status` ='Cancelled' then 1 else 0 end ) as Cancelled,
sum(CASE when `Status` ='Pulled' then 1 else 0 end ) as Pulled,
sum(CASE when `Status` ='Confirmed' then 1 else 0 end ) as Confirmed
from tblPlacements group by jobid ) p
SET j.NursesFound = p.`Found`,
j.NoConfirmed = p.Confirmed,
j.NoPulled = p.Pulled,
j.NoCancelled = p.Cancelled,
ShiftRate1=0
WHERE j.jobid = p.jobid and j.jobid = 5067748
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 3213 n bits 224 index PRIMARY of table `richmond`.`tblPlacements` trx id 132954137 lock_mode X locks rec but not gap
Record lock, heap no 155 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 88520922; asc R ";;
1: len 6; hex 000007ecb819; asc ;;
2: len 7; hex 020000008911b8; asc ;;
3: len 4; hex 804d53e4; asc MS ;;
4: len 7; hex 50533435383820; asc PS4588 ;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: len 0; hex ; asc ;;
10: SQL NULL;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 81; asc ;;
15: len 1; hex 80; asc ;;
16: len 9; hex 436f6e6669726d6564; asc Confirmed;;
17: len 10; hex 31313235363735303032; asc 1125675002;;
18: SQL NULL;
19: len 1; hex 81; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: SQL NULL;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: SQL NULL;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: SQL NULL;
66: SQL NULL;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: SQL NULL;
71: SQL NULL;
72: SQL NULL;
73: SQL NULL;
74: SQL NULL;
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1013 page no 3225 n bits 280 index PRIMARY of table `richmond`.`tblPlacements` trx id 132954137 lock mode S locks rec but not gap waiting
Record lock, heap no 148 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8851d393; asc Q ;;
1: len 6; hex 000007ecb81e; asc ;;
2: len 7; hex 0100000ac62c14; asc , ;;
3: len 4; hex 804d53a8; asc MS ;;
4: len 6; hex 505336333339; asc PS6339;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: len 20; hex 5072652d617272616e67656420426f6f6b696e67; asc Pre-arranged Booking;;
10: SQL NULL;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 81; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 9; hex 43616e63656c6c6564; asc Cancelled;;
17: len 4; hex 30303030; asc 0000;;
18: SQL NULL;
19: len 1; hex 80; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: SQL NULL;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: SQL NULL;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: SQL NULL;
66: SQL NULL;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: SQL NULL;
71: SQL NULL;
72: SQL NULL;
73: SQL NULL;
74: SQL NULL;
*** (2) TRANSACTION:
TRANSACTION 132954142, ACTIVE 1 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 645 lock struct(s), heap size 90232, 105972 row lock(s), undo log entries 1
MySQL thread id 2577488, OS thread handle 22849713575680, query id 522432187 172.31.45.113 admin executing
UPDATE tblJobRequests j, (SELECT jobid,
sum(CASE when `Status` in ('Confirmed', 'Accepted') then 1 else 0 end ) as `Found`,
sum(CASE when `Status` ='Cancelled' then 1 else 0 end ) as Cancelled,
sum(CASE when `Status` ='Pulled' then 1 else 0 end ) as Pulled,
sum(CASE when `Status` ='Confirmed' then 1 else 0 end ) as Confirmed
from tblPlacements group by jobid ) p
SET j.NursesFound = p.`Found`,
j.NoConfirmed = p.Confirmed,
j.NoPulled = p.Pulled,
j.NoCancelled = p.Cancelled,
ShiftRate1=0
WHERE j.jobid = p.jobid and j.jobid = 5067688
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 3225 n bits 280 index PRIMARY of table `richmond`.`tblPlacements` trx id 132954142 lock_mode X locks rec but not gap
Record lock, heap no 148 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8851d393; asc Q ;;
1: len 6; hex 000007ecb81e; asc ;;
2: len 7; hex 0100000ac62c14; asc , ;;
3: len 4; hex 804d53a8; asc MS ;;
4: len 6; hex 505336333339; asc PS6339;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: len 20; hex 5072652d617272616e67656420426f6f6b696e67; asc Pre-arranged Booking;;
10: SQL NULL;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 81; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 9; hex 43616e63656c6c6564; asc Cancelled;;
17: len 4; hex 30303030; asc 0000;;
18: SQL NULL;
19: len 1; hex 80; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: SQL NULL;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: SQL NULL;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: SQL NULL;
66: SQL NULL;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: SQL NULL;
71: SQL NULL;
72: SQL NULL;
73: SQL NULL;
74: SQL NULL;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1013 page no 3213 n bits 224 index PRIMARY of table `richmond`.`tblPlacements` trx id 132954142 lock mode S locks rec but not gap waiting
Record lock, heap no 155 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 88520922; asc R ";;
1: len 6; hex 000007ecb819; asc ;;
2: len 7; hex 020000008911b8; asc ;;
3: len 4; hex 804d53e4; asc MS ;;
4: len 7; hex 50533435383820; asc PS4588 ;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: len 0; hex ; asc ;;
10: SQL NULL;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 81; asc ;;
15: len 1; hex 80; asc ;;
16: len 9; hex 436f6e6669726d6564; asc Confirmed;;
17: len 10; hex 31313235363735303032; asc 1125675002;;
18: SQL NULL;
19: len 1; hex 81; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: SQL NULL;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: SQL NULL;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: SQL NULL;
66: SQL NULL;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: SQL NULL;
71: SQL NULL;
72: SQL NULL;
73: SQL NULL;
74: SQL NULL;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 137539796
Purge done for trx's n:o < 137539794 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304326090169880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090170688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090169072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090168264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090167456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090166648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (read thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (write thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:
Pending flushes (fsync) log: 0; buffer pool: 0
365821 OS file reads, 17369903 OS file writes, 9758637 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.27 writes/s, 0.17 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 12099, seg size 12101, 8792 merges
merged operations:
insert 12148, delete mark 4938, delete 3017
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 1657 buffer(s)
Hash table size 276707, node heap has 264 buffer(s)
Hash table size 276707, node heap has 104 buffer(s)
Hash table size 276707, node heap has 189 buffer(s)
Hash table size 276707, node heap has 39 buffer(s)
Hash table size 276707, node heap has 61 buffer(s)
Hash table size 276707, node heap has 252 buffer(s)
Hash table size 276707, node heap has 173 buffer(s)
11.17 hash searches/s, 11.07 non-hash searches/s
---
LOG
---
Log sequence number 238306151522
Log buffer assigned up to 238306151522
Log buffer completed up to 238306151522
Log written up to 238306151522
Log flushed up to 238306151522
Added dirty pages up to 238306151522
Pages flushed up to 238306151522
Last checkpoint at 238306151522
Log minimum file id is 1624
Log maximum file id is 1638
8912524 log i/o's done, 0.07 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 2454576
Buffer pool size 65531
Free buffers 8199
Database pages 54593
Old database pages 19990
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4221988, not young 8137616
0.14 youngs/s, 0.00 non-youngs/s
Pages read 364956, created 383825, written 5981616
0.00 reads/s, 0.00 creates/s, 0.14 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: 54593, unzip_LRU len: 0
I/O sum[32]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1024
Database pages 6819
Old database pages 2497
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 603271, not young 828442
0.00 youngs/s, 0.00 non-youngs/s
Pages read 44601, created 57999, written 1209260
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: 6819, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8192
Free buffers 1025
Database pages 6839
Old database pages 2504
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 501275, not young 1277307
0.00 youngs/s, 0.00 non-youngs/s
Pages read 48233, created 33859, written 889540
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: 6839, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1026
Database pages 6821
Old database pages 2497
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 675569, not young 562673
0.00 youngs/s, 0.00 non-youngs/s
Pages read 48946, created 54416, written 435816
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: 6821, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1025
Database pages 6828
Old database pages 2500
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 322086, not young 579397
0.00 youngs/s, 0.00 non-youngs/s
Pages read 42407, created 30773, written 310005
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: 6828, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8192
Free buffers 1024
Database pages 6835
Old database pages 2503
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 472528, not young 1760738
0.00 youngs/s, 0.00 non-youngs/s
Pages read 46878, created 54879, written 612645
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: 6835, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1026
Database pages 6822
Old database pages 2498
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 550358, not young 1120894
0.14 youngs/s, 0.00 non-youngs/s
Pages read 45157, created 34550, written 888693
0.00 reads/s, 0.00 creates/s, 0.10 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: 6822, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1025
Database pages 6803
Old database pages 2492
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 617581, not young 1031900
0.00 youngs/s, 0.00 non-youngs/s
Pages read 43263, created 83752, written 497932
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: 6803, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8192
Free buffers 1024
Database pages 6826
Old database pages 2499
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 479320, not young 976265
0.00 youngs/s, 0.00 non-youngs/s
Pages read 45471, created 33597, written 1137725
0.00 reads/s, 0.00 creates/s, 0.03 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: 6826, unzip_LRU len: 0
I/O sum[4]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=978, Main thread ID=22849720932096 , state=sleeping
Number of rows inserted 4731119, updated 1194360, deleted 1818471, read 895194359177
1.62 inserts/s, 0.00 updates/s, 0.00 deletes/s, 79360.30 reads/s
Number of system rows inserted 431008, updated 230262, deleted 339350, read 56908519
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.93 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Process List
|
5 |
event_scheduler |
localhost |
|
Daemon |
5866455 |
Waiting on empty queue |
|
|
2195422 |
rdsadmin |
localhost |
mysql |
Sleep |
6 |
|
|
|
3197667 |
admin |
172.31.45.113:56592 |
richmond |
Sleep |
713 |
|
|
|
4267280 |
admin |
172.31.45.113:45980 |
richmond |
Sleep |
713 |
|
|
|
10353623 |
admin |
172.31.45.113:48398 |
richmond |
Query |
0 |
init |
show full processlist |
|
10353624 |
admin |
172.31.45.113:48402 |
richmond_registrations |
Sleep |
0 |
|
|
|
10353625 |
admin |
172.31.45.113:48418 |
data_warehouse |
Sleep |
0 |
|
|
Running Transactions