INNODB STATUS
=====================================
2025-11-16 21:17:11 22851219678976 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 39620 srv_active, 0 srv_shutdown, 608270 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 29734
OS WAIT ARRAY INFO: signal count 38250
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-10 14:13:20 22849737901824
*** (1) TRANSACTION:
TRANSACTION 131586304, ACTIVE 1 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 640 lock struct(s), heap size 90232, 105175 row lock(s), undo log entries 1
MySQL thread id 200032, OS thread handle 22851108706048, query id 38374054 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 = 5064610
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 370 n bits 320 index PRIMARY of table `richmond`.`tblPlacements` trx id 131586304 lock_mode X locks rec but not gap
Record lock, heap no 249 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 884f4a6a; asc OJj;;
1: len 6; hex 000007d7d900; asc ;;
2: len 7; hex 0200000e651cda; asc e ;;
3: len 4; hex 804d47a2; asc MG ;;
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 80000001; 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 81; asc ;;
16: len 6; hex 50756c6c6564; asc Pulled;;
17: len 10; hex 31303235363434303830; asc 1025644080;;
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;
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1013 page no 373 n bits 136 index PRIMARY of table `richmond`.`tblPlacements` trx id 131586304 lock mode S locks rec but not gap waiting
Record lock, heap no 69 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 884f4d8a; asc OM ;;
1: len 6; hex 000007d7d8fe; asc ;;
2: len 7; hex 0200000e8617f9; asc ;;
3: len 4; hex 804d47c6; asc MG ;;
4: len 6; hex 505331303730; asc PS1070;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: SQL NULL;
10: len 4; hex 80000001; 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: 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 131586302, ACTIVE 1 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 641 lock struct(s), heap size 90232, 104788 row lock(s), undo log entries 1
MySQL thread id 200027, OS thread handle 22850252281600, query id 38374046 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,
j.`Notes` = CONCAT(
'Accepted by ',
CASE
WHEN LongDay > 0 THEN '(Night)'
ELSE ':'
END,
DATE_FORMAT(NOW(), '%d-%m-%y %H:%i'),
' - pmorris_rna',
'
',
COALESCE(j.`Notes`, '')
),
`Status` =
CASE
WHEN NoGivenBack > 0
AND NoGivenBack + NoCancelled + NoCancelled2 = NursesNeeded
THEN 'Given Back'
WHEN NoCancelled + NoCancelled2 = NursesNeeded
THEN 'Cancelled'
WHEN NursesNeeded - (NursesFound + NoGivenBack + NoCancelled + NoCancelled2) > 0
THEN 'Allocating'
WHEN NursesNeeded = NursesFound + NoGivenBack + NoCancelled + NoCancelled2
AND NoConfirmed <> NursesFound
THEN 'Allocated'
WHEN NoConfirmed + NoGivenBack + NoCancelled + NoCancelled2 = NursesNeeded
AND NoConfirmed = NursesFound
THEN 'Confirmed'
ELSE 'Error'
END
WHERE j.jobid = p.jobid and j.jobid = '5064646'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1013 page no 373 n bits 136 index PRIMARY of table `richmond`.`tblPlacements` trx id 131586302 lock_mode X locks rec but not gap
Record lock, heap no 69 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 884f4d8a; asc OM ;;
1: len 6; hex 000007d7d8fe; asc ;;
2: len 7; hex 0200000e8617f9; asc ;;
3: len 4; hex 804d47c6; asc MG ;;
4: len 6; hex 505331303730; asc PS1070;;
5: len 1; hex 81; asc ;;
6: len 1; hex 81; asc ;;
7: len 1; hex 80; asc ;;
8: SQL NULL;
9: SQL NULL;
10: len 4; hex 80000001; 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: 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 370 n bits 320 index PRIMARY of table `richmond`.`tblPlacements` trx id 131586302 lock mode S locks rec but not gap waiting
Record lock, heap no 249 PHYSICAL RECORD: n_fields 75; compact format; info bits 64
0: len 4; hex 884f4a6a; asc OJj;;
1: len 6; hex 000007d7d900; asc ;;
2: len 7; hex 0200000e651cda; asc e ;;
3: len 4; hex 804d47a2; asc MG ;;
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 80000001; 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 81; asc ;;
16: len 6; hex 50756c6c6564; asc Pulled;;
17: len 10; hex 31303235363434303830; asc 1025644080;;
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;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 132140043
Purge done for trx's n:o < 132140041 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304326090170688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090169880, 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
83251 OS file reads, 1972035 OS file writes, 1082714 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 12099, seg size 12101, 1791 merges
merged operations:
insert 2220, delete mark 2531, delete 1808
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 1555 buffer(s)
Hash table size 276707, node heap has 260 buffer(s)
Hash table size 276707, node heap has 87 buffer(s)
Hash table size 276707, node heap has 187 buffer(s)
Hash table size 276707, node heap has 37 buffer(s)
Hash table size 276707, node heap has 43 buffer(s)
Hash table size 276707, node heap has 233 buffer(s)
Hash table size 276707, node heap has 166 buffer(s)
0.83 hash searches/s, 15.81 non-hash searches/s
---
LOG
---
Log sequence number 233912996265
Log buffer assigned up to 233912996265
Log buffer completed up to 233912996265
Log written up to 233912996265
Log flushed up to 233912996265
Added dirty pages up to 233912996265
Pages flushed up to 233912996265
Last checkpoint at 233912996265
Log minimum file id is 1564
Log maximum file id is 1572
980727 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 2094409
Buffer pool size 65531
Free buffers 8204
Database pages 54759
Old database pages 20050
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 469753, not young 1253526
0.00 youngs/s, 0.00 non-youngs/s
Pages read 82440, created 43622, written 705441
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: 54759, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1026
Database pages 6845
Old database pages 2506
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 59043, not young 84027
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9837, created 6514, written 142783
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: 6845, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8192
Free buffers 1025
Database pages 6854
Old database pages 2510
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 43297, not young 218320
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11221, created 3935, written 100055
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: 6854, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1025
Database pages 6831
Old database pages 2501
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 66813, not young 72212
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10698, created 6170, written 51151
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: 6831, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1025
Database pages 6840
Old database pages 2504
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 35053, not young 56658
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9581, created 3531, written 40347
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: 6840, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8192
Free buffers 1025
Database pages 6854
Old database pages 2510
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 47872, not young 171219
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9984, created 6145, written 77597
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: 6854, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1026
Database pages 6848
Old database pages 2507
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 45054, not young 177401
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10854, created 4081, written 108049
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: 6848, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1026
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 131199, not young 333648
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9525, created 9371, written 54921
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[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8192
Free buffers 1026
Database pages 6852
Old database pages 2509
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 41422, not young 140041
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10740, created 3875, written 130538
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: 6852, unzip_LRU len: 0
I/O sum[0]: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 520753, updated 142871, deleted 227765, read 100736291417
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 200736.46 reads/s
Number of system rows inserted 47972, updated 26510, deleted 37733, read 5765470
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.64 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Process List
|
5 |
event_scheduler |
localhost |
|
Daemon |
648080 |
Waiting on empty queue |
|
|
7 |
rdsadmin |
localhost |
mysql |
Sleep |
11 |
|
|
|
1184338 |
admin |
172.31.45.113:55438 |
richmond |
Sleep |
377 |
|
|
|
1184339 |
admin |
172.31.45.113:55446 |
richmond |
Sleep |
377 |
|
|
|
1206434 |
admin |
172.31.45.113:35578 |
richmond |
Query |
0 |
init |
show full processlist |
|
1206435 |
admin |
172.31.45.113:35592 |
richmond_registrations |
Sleep |
0 |
|
|
|
1206436 |
admin |
172.31.45.113:35594 |
data_warehouse |
Sleep |
0 |
|
|
Running Transactions