INNODB STATUS
=====================================
2025-08-31 12:08:27 22772276250368 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 39 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 756847 srv_active, 0 srv_shutdown, 10742003 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 469977
OS WAIT ARRAY INFO: signal count 747643
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-08-15 11:44:54 22770906212096
*** (1) TRANSACTION:
TRANSACTION 123125363, ACTIVE 0 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 679 lock struct(s), heap size 90232, 107184 row lock(s), undo log entries 1
MySQL thread id 17531074, OS thread handle 22771709490944, query id 4258591886 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 = 5033166
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 3511 n bits 304 index PRIMARY of table `richmond`.`tblPlacements` trx id 123125363 lock_mode X locks rec but not gap
Record lock, heap no 239 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8841fead; asc A ;;
1: len 6; hex 00000756be73; asc V s;;
2: len 7; hex 01000017c10d4e; asc N;;
3: len 4; hex 804cccce; asc L ;;
4: len 6; hex 505336353234; asc PS6524;;
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: len 4; hex 80000000; asc ;;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 8; hex 4163636570746564; asc Accepted;;
17: SQL NULL;
18: len 11; hex 4c44417661696c61626c65; asc LDAvailable;;
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 3511 n bits 312 index PRIMARY of table `richmond`.`tblPlacements` trx id 123125363 lock mode S locks rec but not gap waiting
Record lock, heap no 240 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8841fe9c; asc A ;;
1: len 6; hex 00000756be78; asc V x;;
2: len 7; hex 0100000dec2129; asc !);;
3: len 4; hex 804cccb1; asc L ;;
4: len 6; hex 505336383532; asc PS6852;;
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: len 4; hex 80000000; asc ;;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 8; hex 4163636570746564; asc Accepted;;
17: SQL NULL;
18: len 11; hex 4c44417661696c61626c65; asc LDAvailable;;
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;
*** (2) TRANSACTION:
TRANSACTION 123125368, ACTIVE 0 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 679 lock struct(s), heap size 90232, 107461 row lock(s), undo log entries 1
MySQL thread id 17531081, OS thread handle 22770840487680, query id 4258591901 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 = 5033137
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 3511 n bits 312 index PRIMARY of table `richmond`.`tblPlacements` trx id 123125368 lock_mode X locks rec but not gap
Record lock, heap no 240 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8841fe9c; asc A ;;
1: len 6; hex 00000756be78; asc V x;;
2: len 7; hex 0100000dec2129; asc !);;
3: len 4; hex 804cccb1; asc L ;;
4: len 6; hex 505336383532; asc PS6852;;
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: len 4; hex 80000000; asc ;;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 8; hex 4163636570746564; asc Accepted;;
17: SQL NULL;
18: len 11; hex 4c44417661696c61626c65; asc LDAvailable;;
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;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1013 page no 3511 n bits 312 index PRIMARY of table `richmond`.`tblPlacements` trx id 123125368 lock mode S locks rec but not gap waiting
Record lock, heap no 239 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 8841fead; asc A ;;
1: len 6; hex 00000756be73; asc V s;;
2: len 7; hex 01000017c10d4e; asc N;;
3: len 4; hex 804cccce; asc L ;;
4: len 6; hex 505336353234; asc PS6524;;
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: len 4; hex 80000000; asc ;;
11: SQL NULL;
12: len 1; hex 80; asc ;;
13: len 1; hex 80; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 80; asc ;;
16: len 8; hex 4163636570746564; asc Accepted;;
17: SQL NULL;
18: len 11; hex 4c44417661696c61626c65; asc LDAvailable;;
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 (2)
------------
TRANSACTIONS
------------
Trx id counter 124708325
Purge done for trx's n:o < 124708324 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304247258224024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304247258224832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304247258223216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304247258222408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304247258221600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304247258220792, 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
662638 OS file reads, 38689196 OS file writes, 21093780 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.66 writes/s, 0.48 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 12099, seg size 12101, 20117 merges
merged operations:
insert 27370, delete mark 8273, delete 5175
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 1669 buffer(s)
Hash table size 276707, node heap has 274 buffer(s)
Hash table size 276707, node heap has 129 buffer(s)
Hash table size 276707, node heap has 197 buffer(s)
Hash table size 276707, node heap has 48 buffer(s)
Hash table size 276707, node heap has 72 buffer(s)
Hash table size 276707, node heap has 251 buffer(s)
Hash table size 276707, node heap has 170 buffer(s)
1048.23 hash searches/s, 275.92 non-hash searches/s
---
LOG
---
Log sequence number 226551040790
Log buffer assigned up to 226551040790
Log buffer completed up to 226551040790
Log written up to 226551040790
Log flushed up to 226551040790
Added dirty pages up to 226551040790
Pages flushed up to 226551040790
Last checkpoint at 226551040790
Log minimum file id is 1442
Log maximum file id is 1463
19244706 log i/o's done, 0.26 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 2914296
Buffer pool size 65530
Free buffers 8202
Database pages 54518
Old database pages 19962
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7726545, not young 14594935
0.03 youngs/s, 0.00 non-youngs/s
Pages read 662161, created 758154, written 13886749
0.00 reads/s, 0.00 creates/s, 0.20 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: 54518, unzip_LRU len: 0
I/O sum[64]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1026
Database pages 6809
Old database pages 2493
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1020237, not young 1875975
0.00 youngs/s, 0.00 non-youngs/s
Pages read 84858, created 116281, written 2677146
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: 6809, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8192
Free buffers 1025
Database pages 6813
Old database pages 2494
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 827081, not young 2218608
0.00 youngs/s, 0.00 non-youngs/s
Pages read 85647, created 68442, written 2014114
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: 6813, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1025
Database pages 6816
Old database pages 2496
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1358726, not young 1061520
0.03 youngs/s, 0.00 non-youngs/s
Pages read 87207, created 110610, written 981848
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: 6816, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1025
Database pages 6816
Old database pages 2496
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 680748, not young 1290140
0.00 youngs/s, 0.00 non-youngs/s
Pages read 78415, created 64310, written 926432
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: 6816, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8191
Free buffers 1025
Database pages 6808
Old database pages 2493
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 896351, not young 3164712
0.00 youngs/s, 0.00 non-youngs/s
Pages read 85601, created 110443, written 1555396
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: 6808, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8192
Free buffers 1025
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 973796, not young 1948563
0.00 youngs/s, 0.00 non-youngs/s
Pages read 75835, created 70595, written 2005345
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: 6822, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1025
Database pages 6816
Old database pages 2496
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1202677, not young 1718758
0.00 youngs/s, 0.00 non-youngs/s
Pages read 83739, created 151258, written 1189817
0.00 reads/s, 0.00 creates/s, 0.05 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: 6816, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8191
Free buffers 1026
Database pages 6818
Old database pages 2496
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 766929, not young 1316659
0.00 youngs/s, 0.00 non-youngs/s
Pages read 80859, created 66215, written 2536651
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: 6818, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=878, Main thread ID=22770888988416 , state=sleeping
Number of rows inserted 10777207, updated 5939113, deleted 5874478, read 1514762051533
0.00 inserts/s, 0.05 updates/s, 0.00 deletes/s, 115419.22 reads/s
Number of system rows inserted 844978, updated 450449, deleted 665411, read 123150765
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 31.10 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Process List
|
5 |
event_scheduler |
localhost |
|
Daemon |
11501368 |
Waiting on empty queue |
|
|
17743535 |
rdsadmin |
localhost |
mysql |
Sleep |
10 |
|
|
|
18674644 |
admin |
172.31.45.113:37692 |
richmond |
Sleep |
465 |
|
|
|
18674645 |
admin |
172.31.45.113:37698 |
richmond |
Sleep |
465 |
|
|
|
19729294 |
admin |
172.31.45.113:55594 |
richmond |
Query |
2 |
executing |
SELECT id, k.NurseID, n.FirstNames, n.Surname, date_format(k.ActionDate,'%d-%m-%Y %H:%i'), k.Action,
date_format(k.ActionDate,'%Y%m%d%H%i') , CompanyName
from tblKeyActions k
left join (select Nurseid, FirstNames, Surname , CompanyName from tblNurse where CompanyName = 'Richmond') n on k.NurseID = n.NurseID
where cleared = 0 and k.`action` like 'Availability%' and
k.NurseID in (Select nurseid from tblNurse where companyname = 'Richmond' and HCA =0 ) |
|
19729295 |
admin |
172.31.45.113:55596 |
richmond_registrations |
Sleep |
2 |
|
|
|
19729296 |
admin |
172.31.45.113:55598 |
data_warehouse |
Sleep |
2 |
|
|
|
19729297 |
admin |
172.31.45.113:55600 |
richmond |
Sleep |
0 |
|
|
|
19729298 |
admin |
172.31.45.113:55602 |
richmond_registrations |
Sleep |
0 |
|
|
|
19729299 |
admin |
172.31.45.113:55604 |
data_warehouse |
Sleep |
0 |
|
|
|
19729300 |
admin |
172.31.45.113:55606 |
richmond |
Sleep |
0 |
|
|
|
19729301 |
admin |
172.31.45.113:55608 |
richmond_registrations |
Sleep |
0 |
|
|
|
19729302 |
admin |
172.31.45.113:55610 |
data_warehouse |
Sleep |
0 |
|
|
|
19729303 |
admin |
172.31.45.113:55612 |
richmond |
Query |
0 |
init |
show full processlist |
|
19729304 |
admin |
172.31.45.113:55614 |
richmond_registrations |
Sleep |
0 |
|
|
|
19729305 |
admin |
172.31.45.113:55616 |
data_warehouse |
Sleep |
0 |
|
|
Running Transactions
|
trx_id |
trx_state |
trx_started |
trx_requested_lock_id |
trx_wait_started |
trx_weight |
trx_mysql_thread_id |
trx_query |
trx_operation_state |
trx_tables_in_use |
trx_tables_locked |
trx_lock_structs |
trx_lock_memory_bytes |
trx_rows_locked |
trx_rows_modified |
trx_concurrency_tickets |
trx_isolation_level |
trx_unique_checks |
trx_foreign_key_checks |
trx_last_foreign_key_error |
trx_adaptive_hash_latched |
trx_adaptive_hash_timeout |
trx_is_read_only |
trx_autocommit_non_locking |
trx_schedule_weight |
|
304247258225640 |
RUNNING |
2025-08-31 12:08:25 |
|
|
0 |
19729294 |
SELECT id, k.NurseID, n.FirstNames, n.Surname, date_format(k.ActionDate,'%d-%m-%Y %H:%i'), k.Action,
date_format(k.ActionDate,'%Y%m%d%H%i') , CompanyName
from tblKeyActions k
left join (select Nurseid, FirstNames, Surname , CompanyName from tblNurse where CompanyName = 'Richmond') n on k.NurseID = n.NurseID
where cleared = 0 and k.`action` like 'Availability%' and
k.NurseID in (Select nurseid from tblNurse where companyname = 'Richmond' and HCA =0 ) |
|
3 |
0 |
0 |
1128 |
0 |
0 |
0 |
REPEATABLE READ |
1 |
1 |
|
0 |
0 |
1 |
1 |
|