INNODB STATUS
=====================================
2026-02-15 07:20:13 22849671649024 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 3 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 508170 srv_active, 0 srv_shutdown, 7949701 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 447872
OS WAIT ARRAY INFO: signal count 572631
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
------------------------
2026-01-21 10:14:34 22849737901824
*** (1) TRANSACTION:
TRANSACTION 304326090169880, ACTIVE 0 sec fetching rows
mysql tables in use 8, locked 8
LOCK WAIT 314 lock struct(s), heap size 57464, 17349 row lock(s)
MySQL thread id 11166117, OS thread handle 22850252281600, query id 2089843848 172.31.45.113 admin executing
Insert ignore into tblPlacements (nurseid, jobid,fit, Fit2) select n.nurseid, jr1.jobid,
'1' as `Score`, 'Available'
from tblNurse n inner join tblPreferredHospitals ph on n.nurseid = ph.nurseid inner join tblJobRequests jr1 on jr1.Hospitalid= ph.hospitalid
inner join tblTimeslots t on jr1.timeslot = t.SlotName inner join tblPreferredWards pw on n.nurseid = pw.nurseid inner join tblNurseAvailability na on na.availabledate = jr1.jobdate and na.nurseid = n.nurseid inner join (select nurseid, count(*) as compliance_count from tblNurseCompliance where ComplianceItemId in (12,8,11,9,5,7,17,6,13,16,10,15,14,4,3) and datevalue >= now() group by nurseid) nc on nc.Nurseid = n.Nurseid where jr1.jobid='5080250' and nc.compliance_count = 15 and case Matches When 'Early' then na.early =1 and (na.earlyjob is null or na.earlyjob='0' or na.earlyjob='' or na.earlyjob like '%Pulled') When 'Late' then ABS(na.late) =1 and (na.latejob is null or na.latejob='0' or na.latejob='' or na.latejob like '%Pulled') When 'Night' then ABS(na.night) =1 and (na.nightjob is null or na.nightjob='0' or na.nightjob='' or na.nightjob like '%Pulled') When 'L/D' then ABS(na.`L/D`) =1 and (na.`L/Djob` is null or na.`L/Djob`='0' or na.`L/Djob`='' or na.`L/Djob` like '%Pulled') end AND cast(n.Grade as UNSIGNED) >= CAST(jr1.grade as UNSIGNED)group by n.nurseid HAVING group_concat(concat('*',WardType,'*')) like ('%*General Wards*%') order by n.nurseid
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 1001 page no 334 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 304326090169880 lock mode S
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 2 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331323836; asc PS1286;;
1: len 6; hex 00000801b4e8; asc ;;
2: len 7; hex 01000008322c4c; asc 2,L;;
3: len 6; hex 42657468616e; asc Bethan;;
4: len 9; hex 446f6e616c64736f6e; asc Donaldson;;
5: len 0; hex ; asc ;;
6: len 10; hex 416d6d616e666f726420; asc Ammanford ;;
7: len 8; hex 534131382033544e; asc SA18 3TN;;
8: len 25; hex 62657468646f6e616c64736f6e333340676d61696c2e636f6d; asc bethdonaldson33@gmail.com;;
9: len 13; hex 30373530372036383220313234; asc 07507 682 124;;
10: len 13; hex 30373530372036383220313234; asc 07507 682 124;;
11: len 8; hex 3136473030353057; asc 16G0050W;;
12: SQL NULL;
13: len 5; hex 99a77c0000; asc | ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4a45203433343638352042; asc JE 434685 B;;
16: len 0; hex ; asc ;;
17: len 2; hex 4d73; asc Ms;;
18: len 1; hex 42; asc B;;
19: len 5; hex 99169e0000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a8220000; asc " ;;
22: len 12; hex 303031363833323939313937; asc 001683299197;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a7d40000; asc ;;
25: len 5; hex 99a5c40000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 16; hex 66756c6c2074696d65206167656e6379; asc full time agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a7d40000; asc ;;
31: len 30; hex 303735303720363832203132340d0a0d0a32322f352f3139202d20436865; asc 07507 682 124 22/5/19 - Che; (total 60 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b6780000; asc x ;;
34: len 26; hex 4261736963204c69666520537570706f72742065787069726564; asc Basic Life Support expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a88a0000; asc ;;
40: len 20; hex 000003e9000003b8000000010000000000008122; asc ";;
41: len 5; hex 99a88a0000; asc ;;
42: len 5; hex 99a88a0000; asc ;;
43: len 5; hex 999f440000; asc D ;;
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: len 5; hex 99b5a00000; asc ;;
62: len 5; hex 99b8e00000; asc ;;
63: len 5; hex 999e5e0000; asc ^ ;;
64: SQL NULL;
65: SQL NULL;
66: len 5; hex 99b4040000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 10; hex 547920436f726e656c20; asc Ty Cornel ;;
71: len 11; hex 4479666672796e20526420; asc Dyffryn Rd ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 9996660000; asc f ;;
75: len 5; hex 99b6e60000; asc ;;
76: len 30; hex 554e49544544204b494e47444f4d2026204e4f52544845524e204952454c; asc UNITED KINGDOM & NORTHERN IREL; (total 33 bytes);
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 16; hex 444f4e414c3735323135364239395050; asc DONAL752156B99PP;;
80: len 5; hex 99a7aa0000; asc ;;
81: len 1; hex 81; asc ;;
82: len 14; hex 41727475726f2053616e6f726a6f; asc Arturo Sanorjo;;
83: len 13; hex 456c65726920486973636f7474; asc Eleri Hiscott;;
84: len 14; hex 537573616e612053616e6f726a6f; asc Susana Sanorjo;;
85: len 27; hex 41727475726f2e53616e6f726a6f4077616c65732e6e68732e756b; asc Arturo.Sanorjo@wales.nhs.uk;;
86: len 26; hex 456c6572692e486973636f74744077616c65732e6e68732e756b; asc Eleri.Hiscott@wales.nhs.uk;;
87: len 27; hex 537573616e612e53616e6f726a6f4077616c65732e6e68732e756b; asc Susana.Sanorjo@wales.nhs.uk;;
88: len 30; hex 454d61696c2073656e7420746f2041727475726f2053616e6f726a6f206f; asc EMail sent to Arturo Sanorjo o; (total 393 bytes);
89: len 5; hex 999e360000; asc 6 ;;
90: len 5; hex 999e360000; asc 6 ;;
91: SQL NULL;
92: len 5; hex 99a8840000; asc ;;
93: len 5; hex 99adfc0000; asc ;;
94: len 5; hex 999e5e0000; asc ^ ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b5aa0000; asc ;;
99: len 5; hex 999e5e0000; asc ^ ;;
100: len 5; hex 99acc60000; asc ;;
101: SQL NULL;
102: len 4; hex 69396750; asc i9gP;;
103: len 0; hex ; asc ;;
104: len 5; hex 999e5e0000; asc ^ ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a88a0000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a88a0000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a8840000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a88a0000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a88a0000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a88a0000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a8840000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a88a0000; asc ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: len 5; hex 999e5e0000; asc ^ ;;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: len 15; hex 4272796e6d617772206176656e7565; asc Brynmawr avenue;;
161: len 0; hex ; asc ;;
162: len 10; hex 416d6d616e666f726420; asc Ammanford ;;
163: SQL NULL;
164: SQL NULL;
165: len 8; hex 5341313820324441; asc SA18 2DA;;
166: len 15; hex 4361726d61727468656e7368697265; asc Carmarthenshire;;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: len 18; hex 4d6f72726973746f6e20486f73706974616c; asc Morriston Hospital;;
189: len 18; hex 4d6f72726973746f6e20486f73706974616c; asc Morriston Hospital;;
190: len 18; hex 4d6f72726973746f6e20486f73706974616c; asc Morriston Hospital;;
191: len 12; hex 303137393220373033343739; asc 01792 703479;;
192: len 12; hex 303137393220373033343739; asc 01792 703479;;
193: len 12; hex 303137393220373033343739; asc 01792 703479;;
194: len 13; hex 5369737465722042616e642037; asc Sister Band 7;;
195: len 7; hex 53697374657220; asc Sister ;;
196: len 6; hex 536973746572; asc Sister;;
197: SQL NULL;
198: len 7; hex 4272796e746567; asc Brynteg;;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: len 5; hex 99a7d40000; asc ;;
227: len 5; hex 99a88a0000; asc ;;
228: len 9; hex 353331343634353632; asc 531464562;;
229: len 5; hex 99a57c0000; asc | ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 4b52363620484646; asc KR66 HFF;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 0; hex ; asc ;;
245: len 0; hex ; asc ;;
246: len 0; hex ; asc ;;
247: SQL NULL;
248: len 5; hex 99a88a0000; asc ;;
249: len 5; hex 99a88a0000; asc ;;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 3; hex 524e41; asc RNA;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: len 0; hex ; asc ;;
275: len 1; hex 80; asc ;;
276: SQL NULL;
Record lock, heap no 3 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331323933; asc PS1293;;
1: len 6; hex 0000080b8c5d; asc ];;
2: len 7; hex 0100000cf32aa1; asc * ;;
3: len 6; hex 536865696c61; asc Sheila;;
4: len 7; hex 45647761726473; asc Edwards;;
5: len 0; hex ; asc ;;
6: len 13; hex 456c6c65736d657265706f7274; asc Ellesmereport;;
7: len 8; hex 4348363520354850; asc CH65 5HP;;
8: len 23; hex 732e656477617264733539406f75746c6f6f6b2e636f6d; asc s.edwards59@outlook.com;;
9: len 0; hex ; asc ;;
10: len 11; hex 3037353431333138363739; asc 07541318679;;
11: len 8; hex 3739453030313357; asc 79E0013W;;
12: SQL NULL;
13: len 5; hex 99a6bc0000; asc ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 595a203632333632352043; asc YZ 623625 C;;
16: len 0; hex ; asc ;;
17: len 2; hex 4d73; asc Ms;;
18: len 1; hex 53; asc S;;
19: len 5; hex 98db020000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a48a0000; asc ;;
22: len 12; hex 303031363336353330323034; asc 001636530204;;
23: len 15; hex 73697a6520323420756e69666f726d; asc size 24 uniform;;
24: len 5; hex 99a39a0000; asc ;;
25: len 5; hex 99a2200000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 16; hex 537065637472756d206865616c746820; asc Spectrum health ;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a39a0000; asc ;;
31: len 30; hex 30382f30342f32303230206d6f62696c6520303735343133313836373920; asc 08/04/2020 mobile 07541318679 ; (total 55 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99a39c0000; asc ;;
34: len 26; hex 4261736963204c69666520537570706f72742065787069726564; asc Basic Life Support expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a6a40000; asc ;;
40: len 20; hex 000003e900000129000000010000000000002eff; asc ) . ;;
41: len 5; hex 99a47e0000; asc ~ ;;
42: len 5; hex 99a6a40000; asc ;;
43: len 5; hex 999ee20000; asc ;;
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: len 5; hex 98de020000; asc ;;
59: len 5; hex 98de080000; asc ;;
60: len 5; hex 9990d40000; asc ;;
61: len 5; hex 99a17c0000; asc | ;;
62: len 5; hex 99a5560000; asc V ;;
63: len 5; hex 999e1c0000; asc ;;
64: SQL NULL;
65: SQL NULL;
66: len 5; hex 99a3520000; asc R ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 18; hex 3133204c616e63617374657220436c6f7365; asc 13 Lancaster Close;;
71: len 21; hex 506f72742053756e6c696768742056696c6c616765; asc Port Sunlight Village;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 9998a20000; asc ;;
75: len 5; hex 99b9200000; asc ;;
76: len 7; hex 4972656c616e64; asc Ireland;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 16; hex 4544574152353631303137534d39524e; asc EDWAR561017SM9RN;;
80: len 5; hex 99a8c20000; asc ;;
81: len 1; hex 81; asc ;;
82: len 16; hex 59766f6e6e652061726d726964696e67; asc Yvonne armriding;;
83: len 14; hex 4a61636b207368756e7368696f6e; asc Jack shunshion;;
84: len 0; hex ; asc ;;
85: len 30; hex 79766f6e6e652e61726d726964696e6740686f746d61696c2e636f2e756b; asc yvonne.armriding@hotmail.co.uk;;
86: len 19; hex 4a616337646573407961686f6f2e636f2e756b; asc Jac7des@yahoo.co.uk;;
87: len 0; hex ; asc ;;
88: len 30; hex 454d61696c2073656e7420746f2059766f6e6e652061726d726964696e67; asc EMail sent to Yvonne armriding; (total 274 bytes);
89: len 5; hex 999e100000; asc ;;
90: len 5; hex 999e100000; asc ;;
91: len 5; hex 999de60000; asc ;;
92: len 5; hex 99a69e0000; asc ;;
93: len 5; hex 99a6bc0000; asc ;;
94: len 5; hex 999e6a0000; asc j ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 999ee20000; asc ;;
99: len 5; hex 999de60000; asc ;;
100: SQL NULL;
101: SQL NULL;
102: len 4; hex 6942bf72; asc iB r;;
103: len 0; hex ; asc ;;
104: len 5; hex 999ee20000; asc ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a6760000; asc v ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a6760000; asc v ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a6760000; asc v ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a69c0000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a6760000; asc v ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a6760000; asc v ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a6760000; asc v ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a4420000; asc B ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: SQL NULL;
144: SQL NULL;
145: len 5; hex 999dc80000; asc ;;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: len 9; hex 436875726368207264; asc Church rd;;
161: len 8; hex 5472616e6d657265; asc Tranmere;;
162: len 6; hex 57697272616c; asc Wirral;;
163: SQL NULL;
164: SQL NULL;
165: len 8; hex 4348343220345052; asc CH42 4PR;;
166: len 10; hex 4269726b656e68656164; asc Birkenhead;;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: len 8; hex 537065637472756d; asc Spectrum;;
189: len 8; hex 537065637472756d; asc Spectrum;;
190: len 0; hex ; asc ;;
191: len 11; hex 3037373931313631383133; asc 07791161813;;
192: len 11; hex 3031363132383531303732; asc 01612851072;;
193: len 0; hex ; asc ;;
194: len 15; hex 5465616d206c65616465722f72676e; asc Team leader/rgn;;
195: len 14; hex 53656e696f7220526d6e2f72676e; asc Senior Rmn/rgn;;
196: len 0; hex ; asc ;;
197: SQL NULL;
198: len 22; hex 53742e436174686572696e6527732073757267657279; asc St.Catherine's surgery;;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: len 5; hex 99a39a0000; asc ;;
227: len 5; hex 99a69e0000; asc ;;
228: len 9; hex 504630303931313530; asc PF0091150;;
229: len 5; hex 99a46e0000; asc n ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 0; hex ; asc ;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: len 5; hex 999de60000; asc ;;
243: len 0; hex ; asc ;;
244: len 15; hex 416e74686f6e792045647761726473; asc Anthony Edwards;;
245: len 3; hex 536f6e; asc Son;;
246: len 11; hex 3037373135383733333435; asc 07715873345;;
247: SQL NULL;
248: len 5; hex 99a6760000; asc v ;;
249: len 5; hex 99a6760000; asc v ;;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 36; asc 6;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 0; hex ; asc ;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: len 0; hex ; asc ;;
275: len 1; hex 80; asc ;;
276: SQL NULL;
Record lock, heap no 4 PHYSICAL RECORD: n_fields 277; compact format; info bits 0
0: len 5; hex 5053313330; asc PS130;;
1: len 6; hex 0000000b8991; asc ;;
2: len 7; hex 810000019302b4; asc ;;
3: len 6; hex 416e64726577; asc Andrew;;
4: len 6; hex 4d7572726179; asc Murray;;
5: len 30; hex 36392048656f6c20792042616e630d0a42616e6366666f7366656c696e0d; asc 69 Heol y Banc Bancffosfelin ; (total 68 bytes);
6: len 10; hex 4361726d61727468656e; asc Carmarthen;;
7: len 8; hex 534131352035444c; asc SA15 5DL;;
8: len 26; hex 616e647265772e6d75727261794077616c65732e6e68732e756b; asc andrew.murray@wales.nhs.uk;;
9: len 11; hex 3030303030303030303030; asc 00000000000;;
10: len 0; hex ; asc ;;
11: len 8; hex 3934493331333045; asc 94I3130E;;
12: SQL NULL;
13: len 5; hex 999dbc0000; asc ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4e5a203439303136312043; asc NZ 490161 C;;
16: len 0; hex ; asc ;;
17: len 2; hex 4d72; asc Mr;;
18: len 1; hex 4a; asc J;;
19: len 5; hex 990d900000; asc ;;
20: len 4; hex 4d616c65; asc Male;;
21: len 5; hex 9981e40000; asc ;;
22: len 12; hex 303031303436373130383737; asc 001046710877;;
23: len 30; hex 393434353630313335303236310d0a4f7468657220656d61696c200d0a61; asc 9445601350261 Other email a; (total 73 bytes);
24: len 5; hex 997fe20000; asc ;;
25: len 5; hex 9982420000; asc B ;;
26: len 9; hex 506172742054696d65; asc Part Time;;
27: len 9; hex 6974752f7769746879; asc itu/withy;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 997ffe0000; asc ;;
31: len 19; hex 0909090909090909090d0a3d3d3d3d3d3d0d0a; asc ====== ;;
32: len 4; hex 80000001; asc ;;
33: len 5; hex 997ffe0000; asc ;;
34: len 23; hex 4d616e75616c2048616e646c696e672045787069726564; asc Manual Handling Expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 81; asc ;;
38: len 30; hex 53686966742043616e63656c6c656420666f722032312f31302f32303037; asc Shift Cancelled for 21/10/2007;;
39: len 5; hex 997fe20000; asc ;;
40: len 30; hex 30312d31312d31362031313a35333a204e4d43526576616c69646174696f; asc 01-11-16 11:53: NMCRevalidatio; (total 697 bytes);
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: len 5; hex 995abc0000; asc Z ;;
45: SQL NULL;
46: len 5; hex 99613c0000; asc a< ;;
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: len 1; hex 80; asc ;;
66: len 5; hex 8000000000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: len 5; hex 997ffe0000; asc ;;
70: len 14; hex 36392048656f6c20792042616e63; asc 69 Heol y Banc;;
71: len 13; hex 42616e6366666f7366656c696e; asc Bancffosfelin;;
72: len 10; hex 506f6e7479626572656d; asc Pontyberem;;
73: len 9; hex 30313335303236314f; asc 01350261O;;
74: SQL NULL;
75: SQL NULL;
76: len 0; hex ; asc ;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 0; hex ; asc ;;
80: SQL NULL;
81: len 1; hex 80; asc ;;
82: SQL NULL;
83: SQL NULL;
84: SQL NULL;
85: SQL NULL;
86: SQL NULL;
87: SQL NULL;
88: SQL NULL;
89: SQL NULL;
90: SQL NULL;
91: SQL NULL;
92: SQL NULL;
93: len 5; hex 99a0fc0000; asc ;;
94: SQL NULL;
95: SQL NULL;
96: SQL NULL;
97: SQL NULL;
98: SQL NULL;
99: SQL NULL;
100: SQL NULL;
101: SQL NULL;
102: len 4; hex 63503462; asc cP4b;;
103: len 0; hex ; asc ;;
104: SQL NULL;
105: len 1; hex 80; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: SQL NULL;
120: SQL NULL;
121: SQL NULL;
122: SQL NULL;
123: SQL NULL;
124: SQL NULL;
125: SQL NULL;
126: SQL NULL;
127: SQL NULL;
128: SQL NULL;
129: SQL NULL;
130: SQL NULL;
131: SQL NULL;
132: SQL NULL;
133: SQL NULL;
134: SQL NULL;
135: SQL NULL;
136: SQL NULL;
137: SQL NULL;
138: SQL NULL;
139: SQL NULL;
140: SQL NULL;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: SQL NULL;
144: SQL NULL;
145: SQL NULL;
146: len 1; hex 81; asc ;;
147: SQL NULL;
148: SQL NULL;
149: SQL NULL;
150: SQL NULL;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: SQL NULL;
161: SQL NULL;
162: SQL NULL;
163: SQL NULL;
164: SQL NULL;
165: SQL NULL;
166: SQL NULL;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: SQL NULL;
189: SQL NULL;
190: SQL NULL;
191: SQL NULL;
192: SQL NULL;
193: SQL NULL;
194: SQL NULL;
195: SQL NULL;
196: SQL NULL;
197: SQL NULL;
198: SQL NULL;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: SQL NULL;
227: SQL NULL;
228: SQL NULL;
229: SQL NULL;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: SQL NULL;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: SQL NULL;
244: SQL NULL;
245: SQL NULL;
246: SQL NULL;
247: SQL NULL;
248: SQL NULL;
249: SQL NULL;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: SQL NULL;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: SQL NULL;
275: len 1; hex 80; asc ;;
276: SQL DEFAULT;
Record lock, heap no 5 PHYSICAL RECORD: n_fields 277; compact format; info bits 0
0: len 6; hex 505331333034; asc PS1304;;
1: len 6; hex 0000000b8991; asc ;;
2: len 7; hex 810000019302c2; asc ;;
3: len 16; hex 43617472696f6e61204e617461736861; asc Catriona Natasha;;
4: len 4; hex 53656564; asc Seed;;
5: len 0; hex ; asc ;;
6: len 9; hex 436f77627269646765; asc Cowbridge;;
7: len 8; hex 4346373120374541; asc CF71 7EA;;
8: len 30; hex 61747461636b6f667468656d6f6e6b65796361747340686f746d61696c2e; asc attackofthemonkeycats@hotmail.; (total 35 bytes);
9: len 11; hex 3030303030303030303030; asc 00000000000;;
10: len 0; hex ; asc ;;
11: len 8; hex 3039473033343445; asc 09G0344E;;
12: SQL NULL;
13: len 5; hex 99a1be0000; asc ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4a53203339303031362041; asc JS 390016 A;;
16: len 0; hex ; asc ;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 1; hex 4e; asc N;;
19: len 5; hex 99257c0000; asc %| ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a1440000; asc D ;;
22: len 12; hex 303031353933333331393335; asc 001593331935;;
23: len 13; hex 30373834322035313020373337; asc 07842 510 737;;
24: len 5; hex 99a15a0000; asc Z ;;
25: len 5; hex 99a16c0000; asc l ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 20; hex 4369747920486f73706963652043617264696666; asc City Hospice Cardiff;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a15a0000; asc Z ;;
31: len 30; hex 43617472696f6e612077696c6c20676f20746f20484455206173206c6f6e; asc Catriona will go to HDU as lon; (total 161 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99a0a00000; asc ;;
34: len 25; hex 496e66656374696f6e20436f6e74726f6c2065787069726564; asc Infection Control expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a09e0000; asc ;;
40: len 30; hex 417263686976656420616e6420656d61696c2073656e743a2031362d3038; asc Archived and email sent: 16-08; (total 5374 bytes);
41: len 5; hex 99a15e0000; asc ^ ;;
42: len 5; hex 99a14e0000; asc N ;;
43: len 5; hex 999e2c0000; asc , ;;
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: len 5; hex 9926820000; asc & ;;
59: len 5; hex 9954020000; asc T ;;
60: len 5; hex 9957420000; asc WB ;;
61: len 5; hex 999e040000; asc ;;
62: len 5; hex 99a16c0000; asc l ;;
63: len 5; hex 999e040000; asc ;;
64: SQL NULL;
65: SQL NULL;
66: len 5; hex 99a0860000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 18; hex 31352c2048696c6c73696465204472697665; asc 15, Hillside Drive;;
71: len 0; hex ; asc ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 9989f20000; asc ;;
75: len 5; hex 99aa720000; asc r ;;
76: len 7; hex 47422026204e49; asc GB & NI;;
77: len 8; hex 4455393530343931; asc DU950491;;
78: len 2; hex 554b; asc UK;;
79: len 16; hex 5345454439383539333030434e394258; asc SEED9859300CN9BX;;
80: len 5; hex 99b76a0000; asc j ;;
81: len 1; hex 81; asc ;;
82: SQL NULL;
83: SQL NULL;
84: SQL NULL;
85: SQL NULL;
86: SQL NULL;
87: SQL NULL;
88: SQL NULL;
89: len 5; hex 999de40000; asc ;;
90: len 5; hex 999e100000; asc ;;
91: SQL NULL;
92: len 5; hex 99a14c0000; asc L ;;
93: len 5; hex 99a1be0000; asc ;;
94: len 5; hex 999e060000; asc ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 999e2c0000; asc , ;;
99: len 5; hex 999e060000; asc ;;
100: len 5; hex 999e1c0000; asc ;;
101: SQL NULL;
102: len 4; hex 63503462; asc cP4b;;
103: len 8; hex 43617472696f6e61; asc Catriona;;
104: len 5; hex 999e040000; asc ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a1500000; asc P ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a1500000; asc P ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a1500000; asc P ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a1500000; asc P ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a09e0000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a1500000; asc P ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a14c0000; asc L ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a14c0000; asc L ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: SQL NULL;
144: SQL NULL;
145: len 5; hex 999e040000; asc ;;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: SQL NULL;
161: SQL NULL;
162: SQL NULL;
163: SQL NULL;
164: SQL NULL;
165: SQL NULL;
166: SQL NULL;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: SQL NULL;
189: SQL NULL;
190: SQL NULL;
191: SQL NULL;
192: SQL NULL;
193: SQL NULL;
194: SQL NULL;
195: SQL NULL;
196: SQL NULL;
197: SQL NULL;
198: SQL NULL;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: SQL NULL;
227: SQL NULL;
228: len 0; hex ; asc ;;
229: SQL NULL;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 6; hex 6e6f20636172; asc no car;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 0; hex ; asc ;;
245: len 0; hex ; asc ;;
246: len 0; hex ; asc ;;
247: SQL NULL;
248: SQL NULL;
249: SQL NULL;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 0; hex ; asc ;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: SQL NULL;
275: len 1; hex 80; asc ;;
276: SQL DEFAULT;
Record lock, heap no 6 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331333035; asc PS1305;;
1: len 6; hex 000008254cda; asc %L ;;
2: len 7; hex 010000401f22b7; asc @ " ;;
3: len 7; hex 4d656c69737361; asc Melissa;;
4: len 6; hex 5761726c6f77; asc Warlow;;
5: len 0; hex ; asc ;;
6: len 5; hex 4e65617468; asc Neath;;
7: len 8; hex 5341313020364445; asc SA10 6DE;;
8: len 30; hex 6d656c697373617761726c6f773139383340686f746d61696c2e636f2e75; asc melissawarlow1983@hotmail.co.u; (total 31 bytes);
9: len 0; hex ; asc ;;
10: len 13; hex 30373533342035303520353231; asc 07534 505 521;;
11: len 8; hex 3130423030373257; asc 10B0072W;;
12: SQL NULL;
13: len 5; hex 999f100000; asc ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 4a48203230353031342043; asc JH 205014 C;;
16: len 0; hex ; asc ;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 1; hex 4d; asc M;;
19: len 5; hex 992d280000; asc -( ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a6b00000; asc ;;
22: len 12; hex 303031343837303538313139; asc 001487058119;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a7d40000; asc ;;
25: len 5; hex 99a7ba0000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 3; hex 4e5054; asc NPT;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a7d40000; asc ;;
31: len 30; hex 32372f312f323032302072656d6f76656420706f777973206173206e6576; asc 27/1/2020 removed powys as nev; (total 333 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b6100000; asc ;;
34: len 23; hex 4d616e75616c2048616e646c696e672065787069726564; asc Manual Handling expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a7140000; asc ;;
40: len 20; hex 000003e900000a320000000100000000000090e6; asc 2 ;;
41: len 5; hex 99a7540000; asc T ;;
42: len 5; hex 99a7140000; asc ;;
43: len 5; hex 99a9220000; asc " ;;
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: len 5; hex 99b5f40000; asc ;;
62: len 5; hex 99b9340000; asc 4 ;;
63: len 5; hex 99a9120000; asc ;;
64: len 5; hex 99a9960000; asc ;;
65: SQL NULL;
66: len 5; hex 99b7d40000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 12; hex 333920436165204d6f726661; asc 39 Cae Morfa;;
71: len 6; hex 536b6577656e; asc Skewen;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 998cd80000; asc ;;
75: len 5; hex 99afd80000; asc ;;
76: len 7; hex 47422026204e49; asc GB & NI;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 16; hex 5741524c4f3835313230334d3939474e; asc WARLO851203M99GN;;
80: len 5; hex 99a7d00000; asc ;;
81: len 1; hex 81; asc ;;
82: len 11; hex 50617420526f6265727473; asc Pat Roberts;;
83: len 17; hex 526961204c657769732d537472616e6765; asc Ria Lewis-Strange;;
84: len 17; hex 526961204c657769732d537472616e6765; asc Ria Lewis-Strange;;
85: len 24; hex 7061742e726f62657274734077616c65732e6e68732e756b; asc pat.roberts@wales.nhs.uk;;
86: len 22; hex 7269612e6c657769734077616c65732e6e68732e756b; asc ria.lewis@wales.nhs.uk;;
87: len 22; hex 7269612e6c657769734077616c65732e6e68732e756b; asc ria.lewis@wales.nhs.uk;;
88: len 30; hex 5265666572656e636520372075706c6f61646564206d616e75616c6c7920; asc Reference 7 uploaded manually ; (total 685 bytes);
89: len 5; hex 999dc80000; asc ;;
90: len 5; hex 999dc80000; asc ;;
91: SQL NULL;
92: len 5; hex 99a7140000; asc ;;
93: SQL NULL;
94: len 5; hex 99a9160000; asc ;;
95: len 5; hex 99a9960000; asc ;;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b6a00000; asc ;;
99: len 5; hex 99a9120000; asc ;;
100: len 5; hex 99afa80000; asc ;;
101: SQL NULL;
102: len 4; hex 695cf783; asc i\ ;;
103: len 0; hex ; asc ;;
104: len 5; hex 99a9220000; asc " ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a7140000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a7140000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a7140000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a7140000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a7140000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a7140000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a7140000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a7140000; asc ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: SQL NULL;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: len 10; hex 447966656420526f6164; asc Dyfed Road;;
161: len 5; hex 4e65617468; asc Neath;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 0; hex ; asc ;;
166: len 5; hex 4e65617468; asc Neath;;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: len 7; hex 41424d55204842; asc ABMU HB;;
189: len 7; hex 41424d55204842; asc ABMU HB;;
190: len 7; hex 41424d55204842; asc ABMU HB;;
191: len 12; hex 303137393220323835323532; asc 01792 285252;;
192: len 12; hex 303137393220323835323532; asc 01792 285252;;
193: len 12; hex 303137393220323835323532; asc 01792 285252;;
194: len 30; hex 416374696e67206c65616420666f72206c796d70686f6564656d61207365; asc Acting lead for lymphoedema se; (total 36 bytes);
195: len 27; hex 42616e642037206c796d70686f6564656d61207365727669636573; asc Band 7 lymphoedema services;;
196: len 27; hex 42616e642037206c796d70686f6564656d61207365727669636573; asc Band 7 lymphoedema services;;
197: SQL NULL;
198: len 18; hex 447966656420526f61642053757267657279; asc Dyfed Road Surgery;;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: len 5; hex 99a7d40000; asc ;;
227: len 5; hex 99a71a0000; asc ;;
228: len 9; hex 353130363632323932; asc 510662292;;
229: len 5; hex 99a71a0000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 424c323220415750; asc BL22 AWP;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 15; hex 416c69736f6e20486f6c6c6f776179; asc Alison Holloway;;
245: len 6; hex 6d6f74686572; asc mother;;
246: len 12; hex 303738313120313131203435; asc 07811 111 45;;
247: SQL NULL;
248: len 5; hex 99a71a0000; asc ;;
249: len 5; hex 99a71a0000; asc ;;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 3; hex 524e41; asc RNA;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 80; asc ;;
274: len 11; hex 494c532031322d392d3235; asc ILS 12-9-25;;
275: len 1; hex 80; asc ;;
276: SQL NULL;
Record lock, heap no 7 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331323934; asc PS1294;;
1: len 6; hex 000008306985; asc 0i ;;
2: len 7; hex 020000031b1827; asc ';;
3: len 14; hex 537573616e20566963746f726961; asc Susan Victoria;;
4: len 5; hex 4c65776973; asc Lewis;;
5: len 0; hex ; asc ;;
6: len 7; hex 5377616e736561; asc Swansea;;
7: len 7; hex 53413820344445; asc SA8 4DE;;
8: len 27; hex 737573616e2e762e6c6577697340686f746d61696c2e636f2e756b; asc susan.v.lewis@hotmail.co.uk;;
9: len 13; hex 30313739322039323320373437; asc 01792 923 747;;
10: len 13; hex 30373835352032333020323535; asc 07855 230 255;;
11: len 8; hex 3739413032303857; asc 79A0208W;;
12: len 5; hex 99a6bc0000; asc ;;
13: len 5; hex 99a6bc0000; asc ;;
14: len 7; hex 41726368697665; asc Archive;;
15: len 11; hex 574b203433373737362041; asc WK 437776 A;;
16: len 0; hex ; asc ;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 1; hex 56; asc V;;
19: len 5; hex 98e3ca0000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a6d20000; asc ;;
22: len 12; hex 303031363634393535333031; asc 001664955301;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a8120000; asc ;;
25: len 5; hex 99a5c20000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 16; hex 66756c6c2074696d65206167656e6379; asc full time agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a8120000; asc ;;
31: len 30; hex 31362f352f31392072656665727265642052616368656c2057696c6c6961; asc 16/5/19 referred Rachel Willia; (total 190 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b8dc0000; asc ;;
34: len 23; hex 4d616e75616c2048616e646c696e672065787069726564; asc Manual Handling expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a7120000; asc ;;
40: len 20; hex 000003e9000002f000000001000000000000b9e3; asc ;;
41: len 5; hex 99a7120000; asc ;;
42: len 5; hex 99a7100000; asc ;;
43: len 5; hex 999f420000; asc B ;;
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: len 5; hex 98e5820000; asc ;;
59: len 5; hex 98e5820000; asc ;;
60: len 5; hex 98e5820000; asc ;;
61: len 5; hex 99b7028d9b; asc ;;
62: len 5; hex 99b0ec0000; asc ;;
63: len 5; hex 999db60000; asc ;;
64: SQL NULL;
65: SQL NULL;
66: len 5; hex 99b7c60000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 12; hex 352c204661726d20526f6164; asc 5, Farm Road;;
71: len 8; hex 54726562616e6f73; asc Trebanos;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 998a4c0000; asc L ;;
75: len 5; hex 99aacc0000; asc ;;
76: len 30; hex 556e69746564204b696e67646f6d206f6620477265617420427269746169; asc United Kingdom of Great Britai; (total 45 bytes);
77: len 6; hex 323730333634; asc 270364;;
78: len 2; hex 756b; asc uk;;
79: len 0; hex ; asc ;;
80: SQL NULL;
81: len 1; hex 81; asc ;;
82: len 12; hex 6b6172656e20446176696573; asc karen Davies;;
83: len 12; hex 72616d65736820506174656c; asc ramesh Patel;;
84: len 14; hex 4d656c616e696520486172726973; asc Melanie Harris;;
85: len 23; hex 6b6172656e793137406274696e7465726e65742e636f6d; asc kareny17@btinternet.com;;
86: len 20; hex 72616d6573684063617265696e6e2e636f2e756b; asc ramesh@careinn.co.uk;;
87: len 28; hex 4d616e616765724063776d63617274726566636172652e636f2e756b; asc Manager@cwmcartrefcare.co.uk;;
88: len 30; hex 454d61696c2073656e7420746f206b6172656e20446176696573206f6e20; asc EMail sent to karen Davies on ; (total 914 bytes);
89: len 5; hex 999f380000; asc 8 ;;
90: len 5; hex 999e020000; asc ;;
91: len 5; hex 999e5a0000; asc Z ;;
92: len 5; hex 99a7120000; asc ;;
93: len 5; hex 99a6bc0000; asc ;;
94: len 5; hex 999e2e0000; asc . ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b7e80000; asc ;;
99: len 5; hex 999db60000; asc ;;
100: len 5; hex 99af060000; asc ;;
101: SQL NULL;
102: len 4; hex 6967a636; asc ig 6;;
103: len 5; hex 537573616e; asc Susan;;
104: len 5; hex 999db60000; asc ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a7120000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a7120000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a7100000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a7120000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a7120000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a7120000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a7120000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a7120000; asc ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: len 5; hex 999db60000; asc ;;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: len 14; hex 4865726265727420537472656574; asc Herbert Street;;
161: len 10; hex 506f6e74617264617765; asc Pontardawe;;
162: len 7; hex 5377616e736561; asc Swansea;;
163: SQL NULL;
164: SQL NULL;
165: len 0; hex ; asc ;;
166: len 0; hex ; asc ;;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: len 22; hex 43776d2043617274726566206361726520486f6d6520; asc Cwm Cartref care Home ;;
189: len 21; hex 43776d2043617274726566204361726520486f6d65; asc Cwm Cartref Care Home;;
190: len 0; hex ; asc ;;
191: len 12; hex 303137393220383632383435; asc 01792 862845;;
192: len 12; hex 303137393220383632383435; asc 01792 862845;;
193: len 0; hex ; asc ;;
194: len 18; hex 52656769737465726564204d616e61676572; asc Registered Manager;;
195: len 19; hex 4f7065726174696f6e616c204d616e61676572; asc Operational Manager;;
196: len 0; hex ; asc ;;
197: SQL NULL;
198: len 22; hex 416d6d616e205461776520506172746e657273686970; asc Amman Tawe Partnership;;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: len 5; hex 99a8120000; asc ;;
227: len 5; hex 99a7120000; asc ;;
228: len 0; hex ; asc ;;
229: len 5; hex 99a7120000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 0; hex ; asc ;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 10; hex 42656e20576f6c736579; asc Ben Wolsey;;
245: len 3; hex 536f6e; asc Son;;
246: len 0; hex ; asc ;;
247: SQL NULL;
248: len 5; hex 99a7100000; asc ;;
249: len 5; hex 99a7120000; asc ;;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 8; hex 524e312c20524e32; asc RN1, RN2;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: len 20; hex 4d482032312e30312e3230323620426f6f6b6564; asc MH 21.01.2026 Booked;;
275: len 1; hex 80; asc ;;
276: SQL NULL;
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1004 page no 660 n bits 864 index nurse of table `richmond`.`tblNurseCompliance` trx id 304326090169880 lock mode S waiting
Record lock, heap no 718 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d063; asc 8 c;;
*** (2) TRANSACTION:
TRANSACTION 137993942, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1128, 84 row lock(s), undo log entries 26
MySQL thread id 11166120, OS thread handle 22851109246720, query id 2089843852 172.31.45.113 admin updating
UPDATE tblNurse SET eligibilitynotes = '21-01-26 10:14:32 Manual Handling updated [djones_rna]\r\n21-01-26 10:14:32 Manual Handling updated [djones_rna]\r\n14-01-26 14:20:30 Manual Handling updated [djones_rna]\r\n14-01-26 14:00:27 Manual Handling updated [djones_rna]\r\nArchived and email sent: 14-01-2026 10:05:05\r\n19-12-25 16:57:52 Annual Review updated [djones_rna]\r\nAnnual Review Completed 19-12-2025 04:54:17\r\nAnnual Review Received 19-12-2025 04:01:06\r\nAnnual Review email Sent 18-12-2025 04:52:59\r\n18-12-25 16:52:50 Annual Review updated [djones_rna]\r\n13-12-25 9:30:06 Basic Life Support updated [gmorgan-myles_rna]\r\n13-12-25 9:30:06 Basic Life Support updated [gmorgan-myles_rna]\r\n13-12-25 9:30:02 BasicLifeSupport file uploaded [gmorgan-myles_rna]\r\nAnnual Review email Sent 20-11-2025 12:55:42\r\n20-11-25 12:53:51 Annual Review updated [djones_rna]\r\n11-11-25 15:09:20 Safeguarding Children SOCA 3 updated [djones_rna]\r\n11-11-25 15:09:17 SafeguardingChildren file uploaded [djones_rna]\r\n11-11-25 15:09:13 Safeguarding Children SOCA 3 updated [djones_rna]\r\n11-11-25 15:09:13 Safeguarding Children SOCA 3 updated [djones_rna]\r\n24-10-25 15:45:10 Annual Review updated [djones_rna]\r\n20-10-25 11:09:39 DBS Expiry Date updated [lkershaw_rna]\r\n20-10-25 11:09:36 DBS Expiry Date updated [lkershaw_rna]\r\n20-10-25 11:09:31 PoliceCheckExpiryDate file uploaded [lkershaw_rna]\r\n20-10-25 11:09:28 CRBNumber file uploaded [lkershaw_rna]\r\nAnnual Review email Sent 07-10-2025 02:17:16\r\n07-10-25 14:16:15 Annual Review updated [djones_rna]\r\n26-09-25 15:45:41 NMC Expiry updated [djones_rna]\r\n01-07-25 12:23:38 Fit For Work updated [lnicol_rna]\r\n01-07-25 12:23:37 Fit For Work updated [lnicol_rna]\r\n01-07-25 12:23:35 Fit For Work updated [lnicol_rna]\r\n01-07-25 12:23:33 Fit For Work updated [lnicol_rna]\r\n01-07-25 12:23:29 FitForWork file uploaded [lnicol_rna]\r\n16-06-25 14:59:51 Lone Worker updated [dmorgan_rna]\r\n16-06-25 14:59:45 LoneWorker file uploaded [dmorgan_rna]\r\n16-06-25 13:49:09 MADC file uploaded [lnicol_rna]\r\n16-06-25 13:49:06 Medication Awareness updated [lnicol_rna]\r\n09-06-25 11:49:06 SOVAPOVA file uploaded [lnicol_rna]\r\n09-06-25 11:49:01 SOVA/POVA updated [lnicol_rna]\r\n09-06-25 11:30:53 RIDDOR file uploaded [lnicol_rna]\r\n09-06-25 11:30:48 RIDDOR updated [lnicol_rna]\r\n09-06-25 11:30:34 DignityAndRespect file uploaded [lnicol_rna]\r\n09-06-25 11:30:30 Dignity And Respect updated [lnicol_rna]\r\n09-06-25 11:30:15 Caldicott file uploaded [lnicol_rna]\r\n09-06-25 11:30:12 Caldicott updated [lnicol_rna]\r\n09-06-25 11:29:57 InfectionControl file uploaded [lnicol_rna]\r\n09-06-25 11:29:53 Infection Control updated [lnicol_rna]\r\n09-06-25 11:29:39 HealthAndSafety file uploaded [lnicol_rna]\r\n09-06-25 11:29:34 Health And Safety updated [lnicol_rna]\r\n09-06-25 11:29:22 ViolenceAndAggression file uploaded [lnicol_rna]\r\n09-06-25 11:29:18 Violence And Aggression updated [lnicol_rna]\r\n09-06-25 11:29:05 FoodSaf
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1004 page no 660 n bits 864 index nurse of table `richmond`.`tblNurseCompliance` trx id 137993942 lock_mode X
Record lock, heap no 428 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d084; asc 8 ;;
Record lock, heap no 488 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d072; asc 8 r;;
Record lock, heap no 494 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d086; asc 8 ;;
Record lock, heap no 561 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d080; asc 8 ;;
Record lock, heap no 565 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d081; asc 8 ;;
Record lock, heap no 593 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d082; asc 8 ;;
Record lock, heap no 594 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07a; asc 8 z;;
Record lock, heap no 595 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d079; asc 8 y;;
Record lock, heap no 596 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d076; asc 8 v;;
Record lock, heap no 607 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d073; asc 8 s;;
Record lock, heap no 611 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d071; asc 8 q;;
Record lock, heap no 612 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d070; asc 8 p;;
Record lock, heap no 613 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06f; asc 8 o;;
Record lock, heap no 614 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06e; asc 8 n;;
Record lock, heap no 615 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06d; asc 8 m;;
Record lock, heap no 616 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06c; asc 8 l;;
Record lock, heap no 617 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06b; asc 8 k;;
Record lock, heap no 618 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d06a; asc 8 j;;
Record lock, heap no 694 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d089; asc 8 ;;
Record lock, heap no 695 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d08a; asc 8 ;;
Record lock, heap no 696 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d08b; asc 8 ;;
Record lock, heap no 697 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d067; asc 8 g;;
Record lock, heap no 708 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d066; asc 8 f;;
Record lock, heap no 714 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d074; asc 8 t;;
Record lock, heap no 715 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d088; asc 8 ;;
Record lock, heap no 716 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d087; asc 8 ;;
Record lock, heap no 717 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d064; asc 8 d;;
Record lock, heap no 718 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d063; asc 8 c;;
Record lock, heap no 724 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d077; asc 8 w;;
Record lock, heap no 725 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d078; asc 8 x;;
Record lock, heap no 729 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d083; asc 8 ;;
Record lock, heap no 730 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d068; asc 8 h;;
Record lock, heap no 731 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d069; asc 8 i;;
Record lock, heap no 734 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d075; asc 8 u;;
Record lock, heap no 745 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07c; asc 8 |;;
Record lock, heap no 746 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07b; asc 8 {;;
Record lock, heap no 748 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d085; asc 8 ;;
Record lock, heap no 752 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07f; asc 8 ;;
Record lock, heap no 759 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07e; asc 8 ~;;
Record lock, heap no 760 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d07d; asc 8 };;
Record lock, heap no 794 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 6; hex 505331323934; asc PS1294;;
1: len 4; hex 8038d065; asc 8 e;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1001 page no 334 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 137993942 lock_mode X locks rec but not gap waiting
Record lock, heap no 7 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331323934; asc PS1294;;
1: len 6; hex 000008306985; asc 0i ;;
2: len 7; hex 020000031b1827; asc ';;
3: len 14; hex 537573616e20566963746f726961; asc Susan Victoria;;
4: len 5; hex 4c65776973; asc Lewis;;
5: len 0; hex ; asc ;;
6: len 7; hex 5377616e736561; asc Swansea;;
7: len 7; hex 53413820344445; asc SA8 4DE;;
8: len 27; hex 737573616e2e762e6c6577697340686f746d61696c2e636f2e756b; asc susan.v.lewis@hotmail.co.uk;;
9: len 13; hex 30313739322039323320373437; asc 01792 923 747;;
10: len 13; hex 30373835352032333020323535; asc 07855 230 255;;
11: len 8; hex 3739413032303857; asc 79A0208W;;
12: len 5; hex 99a6bc0000; asc ;;
13: len 5; hex 99a6bc0000; asc ;;
14: len 7; hex 41726368697665; asc Archive;;
15: len 11; hex 574b203433373737362041; asc WK 437776 A;;
16: len 0; hex ; asc ;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 1; hex 56; asc V;;
19: len 5; hex 98e3ca0000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a6d20000; asc ;;
22: len 12; hex 303031363634393535333031; asc 001664955301;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a8120000; asc ;;
25: len 5; hex 99a5c20000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 16; hex 66756c6c2074696d65206167656e6379; asc full time agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a8120000; asc ;;
31: len 30; hex 31362f352f31392072656665727265642052616368656c2057696c6c6961; asc 16/5/19 referred Rachel Willia; (total 190 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b8dc0000; asc ;;
34: len 23; hex 4d616e75616c2048616e646c696e672065787069726564; asc Manual Handling expired;;
35: len 0; hex ; asc ;;
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a7120000; asc ;;
40: len 20; hex 000003e9000002f000000001000000000000b9e3; asc ;;
41: len 5; hex 99a7120000; asc ;;
42: len 5; hex 99a7100000; asc ;;
43: len 5; hex 999f420000; asc B ;;
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: len 5; hex 98e5820000; asc ;;
59: len 5; hex 98e5820000; asc ;;
60: len 5; hex 98e5820000; asc ;;
61: len 5; hex 99b7028d9b; asc ;;
62: len 5; hex 99b0ec0000; asc ;;
63: len 5; hex 999db60000; asc ;;
64: SQL NULL;
65: SQL NULL;
66: len 5; hex 99b7c60000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 12; hex 352c204661726d20526f6164; asc 5, Farm Road;;
71: len 8; hex 54726562616e6f73; asc Trebanos;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 998a4c0000; asc L ;;
75: len 5; hex 99aacc0000; asc ;;
76: len 30; hex 556e69746564204b696e67646f6d206f6620477265617420427269746169; asc United Kingdom of Great Britai; (total 45 bytes);
77: len 6; hex 323730333634; asc 270364;;
78: len 2; hex 756b; asc uk;;
79: len 0; hex ; asc ;;
80: SQL NULL;
81: len 1; hex 81; asc ;;
82: len 12; hex 6b6172656e20446176696573; asc karen Davies;;
83: len 12; hex 72616d65736820506174656c; asc ramesh Patel;;
84: len 14; hex 4d656c616e696520486172726973; asc Melanie Harris;;
85: len 23; hex 6b6172656e793137406274696e7465726e65742e636f6d; asc kareny17@btinternet.com;;
86: len 20; hex 72616d6573684063617265696e6e2e636f2e756b; asc ramesh@careinn.co.uk;;
87: len 28; hex 4d616e616765724063776d63617274726566636172652e636f2e756b; asc Manager@cwmcartrefcare.co.uk;;
88: len 30; hex 454d61696c2073656e7420746f206b6172656e20446176696573206f6e20; asc EMail sent to karen Davies on ; (total 914 bytes);
89: len 5; hex 999f380000; asc 8 ;;
90: len 5; hex 999e020000; asc ;;
91: len 5; hex 999e5a0000; asc Z ;;
92: len 5; hex 99a7120000; asc ;;
93: len 5; hex 99a6bc0000; asc ;;
94: len 5; hex 999e2e0000; asc . ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b7e80000; asc ;;
99: len 5; hex 999db60000; asc ;;
100: len 5; hex 99af060000; asc ;;
101: SQL NULL;
102: len 4; hex 6967a636; asc ig 6;;
103: len 5; hex 537573616e; asc Susan;;
104: len 5; hex 999db60000; asc ;;
105: len 1; hex 81; asc ;;
106: SQL NULL;
107: SQL NULL;
108: SQL NULL;
109: SQL NULL;
110: SQL NULL;
111: SQL NULL;
112: SQL NULL;
113: SQL NULL;
114: SQL NULL;
115: SQL NULL;
116: SQL NULL;
117: SQL NULL;
118: SQL NULL;
119: len 5; hex 99a7120000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a7120000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a7100000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a7120000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a7120000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a7120000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a7120000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a7120000; asc ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: len 5; hex 999db60000; asc ;;
146: len 1; hex 81; asc ;;
147: len 1; hex 81; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 81; asc ;;
152: SQL NULL;
153: SQL NULL;
154: SQL NULL;
155: SQL NULL;
156: SQL NULL;
157: SQL NULL;
158: SQL NULL;
159: SQL NULL;
160: len 14; hex 4865726265727420537472656574; asc Herbert Street;;
161: len 10; hex 506f6e74617264617765; asc Pontardawe;;
162: len 7; hex 5377616e736561; asc Swansea;;
163: SQL NULL;
164: SQL NULL;
165: len 0; hex ; asc ;;
166: len 0; hex ; asc ;;
167: SQL NULL;
168: SQL NULL;
169: SQL NULL;
170: SQL NULL;
171: SQL NULL;
172: SQL NULL;
173: SQL NULL;
174: SQL NULL;
175: SQL NULL;
176: SQL NULL;
177: SQL NULL;
178: SQL NULL;
179: SQL NULL;
180: SQL NULL;
181: SQL NULL;
182: SQL NULL;
183: SQL NULL;
184: SQL NULL;
185: SQL NULL;
186: SQL NULL;
187: SQL NULL;
188: len 22; hex 43776d2043617274726566206361726520486f6d6520; asc Cwm Cartref care Home ;;
189: len 21; hex 43776d2043617274726566204361726520486f6d65; asc Cwm Cartref Care Home;;
190: len 0; hex ; asc ;;
191: len 12; hex 303137393220383632383435; asc 01792 862845;;
192: len 12; hex 303137393220383632383435; asc 01792 862845;;
193: len 0; hex ; asc ;;
194: len 18; hex 52656769737465726564204d616e61676572; asc Registered Manager;;
195: len 19; hex 4f7065726174696f6e616c204d616e61676572; asc Operational Manager;;
196: len 0; hex ; asc ;;
197: SQL NULL;
198: len 22; hex 416d6d616e205461776520506172746e657273686970; asc Amman Tawe Partnership;;
199: SQL NULL;
200: SQL NULL;
201: SQL NULL;
202: SQL NULL;
203: SQL NULL;
204: SQL NULL;
205: SQL NULL;
206: SQL NULL;
207: SQL NULL;
208: SQL NULL;
209: SQL NULL;
210: SQL NULL;
211: SQL NULL;
212: SQL NULL;
213: SQL NULL;
214: SQL NULL;
215: SQL NULL;
216: SQL NULL;
217: SQL NULL;
218: SQL NULL;
219: SQL NULL;
220: SQL NULL;
221: SQL NULL;
222: SQL NULL;
223: SQL NULL;
224: SQL NULL;
225: SQL NULL;
226: len 5; hex 99a8120000; asc ;;
227: len 5; hex 99a7120000; asc ;;
228: len 0; hex ; asc ;;
229: len 5; hex 99a7120000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 0; hex ; asc ;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: SQL NULL;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 10; hex 42656e20576f6c736579; asc Ben Wolsey;;
245: len 3; hex 536f6e; asc Son;;
246: len 0; hex ; asc ;;
247: SQL NULL;
248: len 5; hex 99a7100000; asc ;;
249: len 5; hex 99a7120000; asc ;;
250: SQL NULL;
251: SQL NULL;
252: SQL NULL;
253: SQL NULL;
254: SQL NULL;
255: SQL NULL;
256: len 8; hex 526963686d6f6e64; asc Richmond;;
257: SQL NULL;
258: SQL NULL;
259: SQL NULL;
260: SQL NULL;
261: SQL NULL;
262: SQL NULL;
263: len 1; hex 35; asc 5;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 8; hex 524e312c20524e32; asc RN1, RN2;;
269: len 1; hex 81; asc ;;
270: len 1; hex 80; asc ;;
271: len 1; hex 80; asc ;;
272: len 1; hex 80; asc ;;
273: len 1; hex 81; asc ;;
274: len 20; hex 4d482032312e30312e3230323620426f6f6b6564; asc MH 21.01.2026 Booked;;
275: len 1; hex 80; asc ;;
276: SQL NULL;
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 140098711
Purge done for trx's n:o < 140098707 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304326090172304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304326090171496, 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 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
1190028 OS file reads, 25022206 OS file writes, 14108701 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, 13069 merges
merged operations:
insert 18725, delete mark 9378, delete 5573
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 1371 buffer(s)
Hash table size 276707, node heap has 223 buffer(s)
Hash table size 276707, node heap has 73 buffer(s)
Hash table size 276707, node heap has 183 buffer(s)
Hash table size 276707, node heap has 22 buffer(s)
Hash table size 276707, node heap has 39 buffer(s)
Hash table size 276707, node heap has 230 buffer(s)
Hash table size 276707, node heap has 159 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 240481901268
Log buffer assigned up to 240481901268
Log buffer completed up to 240481901268
Log written up to 240481901268
Log flushed up to 240481901268
Added dirty pages up to 240481901268
Pages flushed up to 240481901268
Last checkpoint at 240481901268
Log minimum file id is 1654
Log maximum file id is 1670
12827445 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 4765507
Buffer pool size 65531
Free buffers 8205
Database pages 55026
Old database pages 20150
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6631683, not young 29760645
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1189031, created 541960, written 8610270
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 55026, unzip_LRU len: 0
I/O sum[8]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1025
Database pages 6880
Old database pages 2519
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 965782, not young 4021590
0.00 youngs/s, 0.00 non-youngs/s
Pages read 148220, created 81572, written 1732737
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6880, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8192
Free buffers 1025
Database pages 6879
Old database pages 2519
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 799294, not young 4251713
0.00 youngs/s, 0.00 non-youngs/s
Pages read 153289, created 47918, written 1280792
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6879, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1025
Database pages 6879
Old database pages 2519
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1067632, not young 3050198
0.00 youngs/s, 0.00 non-youngs/s
Pages read 155006, created 76399, written 615137
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6879, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1025
Database pages 6882
Old database pages 2520
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 507457, not young 2828697
0.00 youngs/s, 0.00 non-youngs/s
Pages read 140915, created 43607, written 444610
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6882, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8192
Free buffers 1025
Database pages 6882
Old database pages 2520
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 751724, not young 4578446
0.00 youngs/s, 0.00 non-youngs/s
Pages read 145899, created 77083, written 879795
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6882, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1027
Database pages 6871
Old database pages 2516
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 873740, not young 3741234
0.00 youngs/s, 0.00 non-youngs/s
Pages read 149980, created 48753, written 1288954
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6871, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1028
Database pages 6879
Old database pages 2520
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 899808, not young 3941842
0.00 youngs/s, 0.00 non-youngs/s
Pages read 144473, created 119068, written 727302
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6879, unzip_LRU len: 0
I/O sum[1]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8192
Free buffers 1025
Database pages 6874
Old database pages 2517
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 766246, not young 3346925
0.00 youngs/s, 0.00 non-youngs/s
Pages read 151249, created 47560, written 1640943
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6874, unzip_LRU len: 0
I/O sum[1]: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 6705527, updated 1618516, deleted 2674768, read 1290675804479
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 608954, updated 325512, deleted 479433, read 83677049
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Process List
|
5 |
event_scheduler |
localhost |
|
Daemon |
8460262 |
Waiting on empty queue |
|
|
10669479 |
rdsadmin |
localhost |
mysql |
Sleep |
4 |
|
|
|
15087645 |
admin |
172.31.45.113:40806 |
information_schema |
Sleep |
233 |
|
|
|
15087649 |
admin |
172.31.45.113:40846 |
|
Sleep |
230 |
|
|
|
15099647 |
admin |
172.31.45.113:46770 |
richmond |
Sleep |
1493 |
|
|
|
15099652 |
admin |
172.31.45.113:40874 |
richmond |
Sleep |
1492 |
|
|
|
15323611 |
admin |
172.31.45.113:37288 |
richmond |
Query |
0 |
init |
show full processlist |
|
15323612 |
admin |
172.31.45.113:37296 |
richmond_registrations |
Sleep |
0 |
|
|
|
15323613 |
admin |
172.31.45.113:37298 |
data_warehouse |
Sleep |
0 |
|
|
Running Transactions