INNODB STATUS

=====================================
2026-04-22 09:23:52 23212919461632 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 14 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 350159 srv_active, 0 srv_shutdown, 1118584 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 53123
OS WAIT ARRAY INFO: signal count 67676
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-04-17 09:05:04 23213343414016
*** (1) TRANSACTION:
TRANSACTION 304689698575128, ACTIVE 0 sec starting index read
mysql tables in use 7, locked 7
LOCK WAIT 1023 lock struct(s), heap size 123000, 3422 row lock(s)
MySQL thread id 1635551, OS thread handle 23213204739840, query id 325914695 172.31.45.113 admin executing
Insert ignore into tblPlacements (nurseid, jobid,fit, Fit2) select n.nurseid, jr1.jobid,
'3' 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 where jr1.jobid='5101978' and case Matches When 'Early' then (na.earlyjob is null or na.earlyjob='0' or na.earlyjob='' or na.earlyjob like '%Pulled') When 'Late' then (na.latejob is null or na.latejob='0' or na.latejob='' or na.latejob like '%Pulled') When 'Night' then (na.nightjob is null or na.nightjob='0' or na.nightjob='' or na.nightjob like '%Pulled') When 'L/D' then (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 179 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 304689698575128 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331313334; asc PS1134;;
1: len 6; hex 0000080d203a; asc :;;
2: len 7; hex 020000145620fc; asc V ;;
3: len 5; hex 4b61746965; asc Katie;;
4: len 9; hex 507269746368617264; asc Pritchard;;
5: SQL NULL;
6: len 8; hex 4c6c616e656c6c69; asc Llanelli;;
7: len 8; hex 5341313420384742; asc SA14 8GB;;
8: len 18; hex 6b617469655f62616368406d736e2e636f6d; asc katie_bach@msn.com;;
9: len 13; hex 30313535342038323120373131; asc 01554 821 711;;
10: len 13; hex 30373538322031393220313132; asc 07582 192 112;;
11: len 8; hex 3134413038303457; asc 14A0804W;;
12: SQL NULL;
13: len 5; hex 999f380000; asc 8 ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4a52203432353130302041; asc JR 425100 A;;
16: len 5; hex 3431323937; asc 41297;;
17: len 4; hex 4d697373; asc Miss;;
18: len 3; hex 416e6e; asc Ann;;
19: len 5; hex 99466e0000; asc Fn ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a35c0000; asc \ ;;
22: len 12; hex 303031353333343734323539; asc 001533474259;;
23: len 30; hex 44616e69656c20507269636520284669616e6365290d0a30373737333639; asc Daniel Price (Fiance) 0777369; (total 34 bytes);
24: len 5; hex 999b8a0000; asc ;;
25: len 5; hex 999cc40000; asc ;;
26: len 9; hex 506172742054696d65; asc Part Time;;
27: len 11; hex 437972696c204576616e73; asc Cyril Evans;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 999c660000; asc f ;;
31: len 30; hex 4d4f423a303735383220313932203131320d0a0d0a33302f30362f323031; asc MOB:07582 192 112 30/06/201; (total 198 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 999b8c0000; asc ;;
34: len 23; hex 4d616e75616c2048616e646c696e672065787069726564; asc Manual Handling expired;;
35: SQL NULL;
36: SQL NULL;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 999b3a0000; asc : ;;
40: len 30; hex 30312d30322d31382031323a35333a204e4d43526576616c69646174696f; asc 01-02-18 12:53: NMCRevalidatio; (total 4703 bytes);
41: len 5; hex 999ae20000; asc ;;
42: len 5; hex 999ae20000; asc ;;
43: len 5; hex 9999bc0000; asc ;;
44: len 5; hex 99a3fa0000; asc ;;
45: len 5; hex 995b520000; asc [R ;;
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: len 1; hex 80; asc ;;
66: len 5; hex 8000000000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 13; hex 33322c4272796e687966727964; asc 32,Brynhyfryd;;
71: len 0; hex ; asc ;;
72: len 11; hex 4c6c616e67656e6e656368; asc Llangennech;;
73: len 0; hex ; asc ;;
74: len 5; hex 998dfa0000; asc ;;
75: len 5; hex 99ae7a0000; asc z ;;
76: len 30; hex 556e69746564204b696e67646f6d206f6620477265617420427269746169; asc United Kingdom of Great Britai; (total 45 bytes);
77: len 8; hex 4458363131313336; asc DX611136;;
78: len 2; hex 556b; asc Uk;;
79: len 18; hex 50524954433936313233304b413945423137; asc PRITC961230KA9EB17;;
80: len 5; hex 999e0e0000; asc ;;
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: len 5; hex 9999b60000; asc ;;
90: len 5; hex 9999820000; asc ;;
91: SQL NULL;
92: len 5; hex 999b3a0000; asc : ;;
93: len 5; hex 99a5ba0000; asc ;;
94: len 5; hex 99992a0000; asc * ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: SQL NULL;
99: len 5; hex 9999840000; asc ;;
100: SQL NULL;
101: SQL NULL;
102: len 4; hex 69442480; asc iD$ ;;
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: 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 80; 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: 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 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: 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 505331313335; asc PS1135;;
1: len 6; hex 0000065a6987; asc Zi ;;
2: len 7; hex 01000017f20985; asc ;;
3: len 7; hex 416e6472657720; asc Andrew ;;
4: len 6; hex 446176696573; asc Davies;;
5: SQL NULL;
6: len 11; hex 436165727068696c6c7920; asc Caerphilly ;;
7: len 8; hex 4346383320335046; asc CF83 3PF;;
8: len 17; hex 696e636964656e7440696e636964656e74; asc incident@incident;;
9: len 13; hex 30373739392030393420323134; asc 07799 094 214;;
10: len 13; hex 30303030302030303020303030; asc 00000 000 000;;
11: len 8; hex 3833593231353245; asc 83Y2152E;;
12: SQL NULL;
13: len 5; hex 99a67e0000; asc ~ ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4e42203631303038392044; asc NB 610089 D;;
16: len 5; hex 3431303834; asc 41084;;
17: len 2; hex 4d72; asc Mr;;
18: len 1; hex 4a; asc J;;
19: len 5; hex 98f0e60000; asc ;;
20: len 4; hex 4d616c65; asc Male;;
21: len 5; hex 99a8900000; asc ;;
22: len 12; hex 303031363134323939343731; asc 001614299471;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a6320000; asc 2 ;;
25: len 5; hex 99a6660000; asc f ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 16; hex 46756c6c2054696d65204167656e6379; asc Full Time Agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a6320000; asc 2 ;;
31: len 30; hex 62696b65722e64617669657331393037363440676d61696c2e636f6d0d0a; asc biker.davies190764@gmail.com ; (total 679 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99aa680000; asc h ;;
34: len 30; hex 457175616c69747920616e64204469766572736974792065787069726564; asc Equality and Diversity expired;;
35: SQL NULL;
36: SQL NULL;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a8e60000; asc ;;
40: len 20; hex 000003e9000000aa0000000100000000000057f9; asc W ;;
41: len 5; hex 99a8e60000; asc ;;
42: len 5; hex 99a8e60000; asc ;;
43: len 5; hex 9999c80000; asc ;;
44: len 5; hex 99b6f80000; asc ;;
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 99a9e4e81f; asc ;;
62: len 5; hex 99a70a0000; asc ;;
63: len 5; hex 999dce0000; asc ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99aa760000; asc v ;;
67: len 5; hex 999bc20000; asc ;;
68: SQL NULL;
69: SQL NULL;
70: len 12; hex 393320476c796e2042656477; asc 93 Glyn Bedw;;
71: len 12; hex 4c6c616e6272616461636820; asc Llanbradach ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 9981e80000; asc ;;
75: len 5; hex 99a2680000; asc h ;;
76: len 30; hex 556e69746564204b696e67646f6d206f6620477265617420427269746169; asc United Kingdom of Great Britai; (total 31 bytes);
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 19; hex 4441564945363037313934414a394e43203836; asc DAVIE607194AJ9NC 86;;
80: len 5; hex 99b4b00000; asc ;;
81: len 1; hex 81; asc ;;
82: SQL NULL;
83: SQL NULL;
84: len 13; hex 4b6172656e20466f7274756e65; asc Karen Fortune;;
85: SQL NULL;
86: SQL NULL;
87: len 26; hex 4b6172656e2e466f7274756e654077616c65732e6e68732e756b; asc Karen.Fortune@wales.nhs.uk;;
88: len 30; hex 454d61696c2073656e7420746f204b6172656e20466f7274756e65206f6e; asc EMail sent to Karen Fortune on; (total 43 bytes);
89: len 5; hex 9999c80000; asc ;;
90: len 5; hex 9999540000; asc T ;;
91: SQL NULL;
92: len 5; hex 99a8e60000; asc ;;
93: len 5; hex 99acfe0000; asc ;;
94: len 5; hex 9999540000; asc T ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99a8c60000; asc ;;
99: len 5; hex 9999660000; asc f ;;
100: len 5; hex 99aa0a0000; asc ;;
101: SQL NULL;
102: len 4; hex 67b5b00d; asc g ;;
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: len 5; hex 99a8e60000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a8e60000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a8e60000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a8e60000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a8e60000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a8e60000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a8e60000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a8e60000; asc ;;
141: SQL NULL;
142: len 1; hex 81; asc ;;
143: len 9; hex 5375626d6974746564; asc Submitted;;
144: len 20; hex 000003e9000000ac000000010000000000001c5b; asc [;;
145: SQL NULL;
146: len 1; hex 81; asc ;;
147: len 1; hex 80; 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 17; hex 322f33204c657769732054657272616365; asc 2/3 Lewis Terrace;;
161: len 11; hex 4c6c616e62726164616368; asc Llanbradach;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 8; hex 4346383320334a5a; asc CF83 3JZ;;
166: len 10; hex 436165727068696c6c79; asc Caerphilly;;
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: len 19; hex 5468652056696c6c6167652053757267657279; asc The Village 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 99a6320000; asc 2 ;;
227: len 5; hex 99a8e60000; asc ;;
228: len 0; hex ; asc ;;
229: len 5; hex 99a88e0000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 454b313020584347; asc EK10 XCG;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: len 5; hex 99a68a0000; asc ;;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 13; hex 42657468616e20446176696573; asc Bethan Davies;;
245: len 8; hex 4461756768746572; asc Daughter;;
246: len 11; hex 3037393536383136353935; asc 07956816595;;
247: SQL NULL;
248: len 5; hex 99a8e60000; asc ;;
249: len 5; hex 99a8e60000; 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 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 5 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331313339; asc PS1139;;
1: len 6; hex 0000080cf8fc; asc ;;
2: len 7; hex 020000145b15cf; asc [ ;;
3: len 15; hex 436572797320456c697a6162657468; asc Cerys Elizabeth;;
4: len 6; hex 4d6f7267616e; asc Morgan;;
5: SQL NULL;
6: len 8; hex 4162657264617265; asc Aberdare;;
7: len 8; hex 4346343420304453; asc CF44 0DS;;
8: len 19; hex 6d6f7267616e63653740676d61696c2e636f6d; asc morgance7@gmail.com;;
9: len 13; hex 30313638352038373620303933; asc 01685 876 093;;
10: len 14; hex 2030373938392031333120373534; asc 07989 131 754;;
11: len 8; hex 3133463030363957; asc 13F0069W;;
12: SQL NULL;
13: len 5; hex 99a43c0000; asc < ;;
14: len 7; hex 44656c65746564; asc Deleted;;
15: len 11; hex 4a4b203934353332392042; asc JK 945329 B;;
16: len 5; hex 3430353137; asc 40517;;
17: len 4; hex 4d697373; asc Miss;;
18: len 1; hex 45; asc E;;
19: len 5; hex 99495c0000; asc I\ ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a2fa0000; asc ;;
22: len 12; hex 303031363132313230323436; asc 001612120246;;
23: len 30; hex 5061756c204d6f7267616e2028466174686572290d0a3037373931333333; asc Paul Morgan (Father) 07791333; (total 33 bytes);
24: len 5; hex 99a1280000; asc ( ;;
25: len 5; hex 999c640000; asc d ;;
26: len 9; hex 506172742054696d65; asc Part Time;;
27: len 4; hex 4d454155; asc MEAU;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a3740000; asc t ;;
31: len 30; hex 4d4f42203a20303739383920313331203735340d0a0d0a30342e30312e32; asc MOB : 07989 131 754 04.01.2; (total 60 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99a12a0000; asc * ;;
34: len 23; hex 4d616e75616c2048616e646c696e672065787069726564; asc Manual Handling expired;;
35: SQL NULL;
36: SQL NULL;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a40c0000; asc ;;
40: len 20; hex 000003e9000000af0000000100000000000046f2; asc F ;;
41: len 5; hex 99a40c0000; asc ;;
42: len 5; hex 99a40c0000; asc ;;
43: len 5; hex 9999e60000; asc ;;
44: len 5; hex 99da600000; asc ` ;;
45: len 5; hex 994d960000; asc M ;;
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 99a0820000; asc ;;
62: len 5; hex 99a3320000; asc 2 ;;
63: len 5; hex 999c280000; asc ( ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99a1060000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 20; hex 313520546972666f756e646572204669656c6473; asc 15 Tirfounder Fields;;
71: len 8; hex 43776d6261636820; asc Cwmbach ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 9986200000; asc ;;
75: len 5; hex 99a7e00000; asc ;;
76: len 30; hex 556e69746564204b696e67646f6d206f6620477265617420427269746169; asc United Kingdom of Great Britai; (total 45 bytes);
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 19; hex 4d4f5247413936303134314345395550203533; asc MORGA960141CE9UP 53;;
80: len 5; hex 99a0640000; asc d ;;
81: len 1; hex 81; asc ;;
82: len 13; hex 43657269205269636861726473; asc Ceri Richards;;
83: SQL NULL;
84: SQL NULL;
85: len 30; hex 636572692e72696368617264732d7461796c6f724077616c65732e6e6873; asc ceri.richards-taylor@wales.nhs; (total 33 bytes);
86: SQL NULL;
87: SQL NULL;
88: len 30; hex 454d61696c2073656e7420746f2043657269205269636861726473206f6e; asc EMail sent to Ceri Richards on; (total 43 bytes);
89: SQL NULL;
90: len 5; hex 99991a0000; asc ;;
91: len 5; hex 9999260000; asc & ;;
92: len 5; hex 99a40c0000; asc ;;
93: len 5; hex 99a43c0000; asc < ;;
94: len 5; hex 99990a0000; asc ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 999f420000; asc B ;;
99: len 5; hex 9999b60000; asc ;;
100: SQL NULL;
101: SQL NULL;
102: len 4; hex 694406d3; asc iD ;;
103: len 5; hex 4365727973; asc Cerys;;
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: len 5; hex 99a40c0000; asc ;;
120: SQL NULL;
121: len 5; hex 99a0420000; asc B ;;
122: len 5; hex 99a40c0000; asc ;;
123: len 3; hex 55484c; asc UHL;;
124: len 5; hex 99a0020000; asc ;;
125: len 5; hex 99a40c0000; asc ;;
126: len 3; hex 55484c; asc UHL;;
127: len 5; hex 99a0420000; asc B ;;
128: len 5; hex 99a40c0000; asc ;;
129: len 3; hex 55484c; asc UHL;;
130: SQL NULL;
131: len 5; hex 99a40c0000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a40c0000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a40c0000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a40c0000; asc ;;
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: 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 80; 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 3734204d6f6e6b20537472656574; asc 74 Monk Street;;
161: len 0; hex ; asc ;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 8; hex 4346343420375041; asc CF44 7PA;;
166: len 8; hex 4162657264617265; asc Aberdare;;
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: len 20; hex 466f756e64727920546f776e20436c696e696320; asc Foundry Town Clinic ;;
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 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 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: len 0; hex ; asc ;;
275: len 1; hex 80; asc ;;
276: SQL NULL;

Record lock, heap no 6 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331313431; asc PS1141;;
1: len 6; hex 00000883d8cd; asc ;;
2: len 7; hex 0200000704071b; asc ;;
3: len 17; hex 4368726973746f70686572204d61726b20; asc Christopher Mark ;;
4: len 6; hex 4b6561676c65; asc Keagle;;
5: SQL NULL;
6: len 8; hex 4272696467656e64; asc Bridgend;;
7: len 8; hex 4346333120314e4e; asc CF31 1NN;;
8: len 23; hex 6561676c65636d6b40676f6f676c656d61696c2e636f6d; asc eaglecmk@googlemail.com;;
9: len 13; hex 30313635362036363720303736; asc 01656 667 076;;
10: len 13; hex 30373336362034313620323935; asc 07366 416 295;;
11: len 8; hex 3834433030363757; asc 84C0067W;;
12: SQL NULL;
13: len 5; hex 999cfc0000; asc ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 574d203637343337392044; asc WM 674379 D;;
16: len 5; hex 3431363239; asc 41629;;
17: len 2; hex 4d72; asc Mr;;
18: len 2; hex 434d; asc CM;;
19: len 5; hex 98eab40000; asc ;;
20: len 4; hex 4d616c65; asc Male;;
21: len 5; hex 99a3a40000; asc ;;
22: len 12; hex 303031353337393332393630; asc 001537932960;;
23: len 26; hex 57656e6479202857696665292030373731392032383520363038; asc Wendy (Wife) 07719 285 608;;
24: len 5; hex 999cc60000; asc ;;
25: len 5; hex 999cfc0000; asc ;;
26: len 9; hex 506172742054696d65; asc Part Time;;
27: len 16; hex 46756c6c2054696d65204167656e6379; asc Full Time Agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 999c6c0000; asc l ;;
31: len 30; hex 31332e30392e323120726566657272656420416d616e6461204a61636b73; asc 13.09.21 referred Amanda Jacks; (total 36 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b7e40000; asc ;;
34: len 25; hex 496e66656374696f6e20436f6e74726f6c2065787069726564; asc Infection Control expired;;
35: SQL NULL;
36: SQL NULL;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 999ce80000; asc ;;
40: len 20; hex 000003e900000163000000010000000000007800; asc c x ;;
41: len 5; hex 999b3e0000; asc > ;;
42: len 5; hex 999ce80000; asc ;;
43: len 5; hex 99a8040000; asc ;;
44: len 5; hex 99a7680000; asc h ;;
45: len 5; hex 9999560000; asc V ;;
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 99b7b2fcd9; asc ;;
62: len 5; hex 99b7d00000; asc ;;
63: len 5; hex 99a7f60000; asc ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99b76c0000; asc l ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 23; hex 3339204772656174205765737465726e204176656e7565; asc 39 Great Western Avenue;;
71: len 0; hex ; asc ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 997c1e0000; asc | ;;
75: len 5; hex 999c9e0000; asc ;;
76: len 5; hex 57616c6573; asc Wales;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 18; hex 4b4541474c363038323632434d394d463234; asc KEAGL608262CM9MF24;;
80: len 5; hex 99a59a0000; asc ;;
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: len 30; hex 5265666572656e636520322075706c6f61646564206d616e75616c6c7920; asc Reference 2 uploaded manually ; (total 274 bytes);
89: len 5; hex 9999180000; asc ;;
90: len 5; hex 99999a0000; asc ;;
91: SQL NULL;
92: len 5; hex 999ce80000; asc ;;
93: SQL NULL;
94: len 5; hex 99a7f60000; asc ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b6600000; asc ` ;;
99: len 5; hex 99a7f40000; asc ;;
100: len 5; hex 99ae660000; asc f ;;
101: SQL NULL;
102: len 4; hex 69be7b62; asc i {b;;
103: len 5; hex 4368726973; asc Chris;;
104: len 5; hex 99a8040000; 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: 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: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: len 5; hex 99a7700000; asc p ;;
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 18; hex 4e6577636173746c65207375726765727920; asc Newcastle surgery ;;
161: len 16; hex 4c6c616e67657779646420526f616420; asc Llangewydd Road ;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 7; hex 43463331345858; asc CF314XX;;
166: len 9; hex 4272696467656e6420; asc Bridgend ;;
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: len 24; hex 4272696467656e642067726f757020707261637469636520; asc Bridgend group practice ;;
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: 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 5; hex 57656e6479; asc Wendy;;
245: len 4; hex 57696665; asc Wife;;
246: len 12; hex 303737313920323835363038; asc 07719 285608;;
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: len 5; hex 99a7f50c85; asc ;;
263: len 1; hex 37; asc 7;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 3; hex 524e31; asc RN1;;
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;


*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1001 page no 9 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 304689698575128 lock mode S locks rec but not gap waiting
Record lock, heap no 10 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 5; hex 4152303236; asc AR026;;
1: len 6; hex 0000089f435b; asc C[;;
2: len 7; hex 01000017c018b9; asc ;;
3: len 8; hex 4361726f6c696e65; asc Caroline;;
4: len 6; hex 57696c736f6e; asc Wilson;;
5: len 30; hex 4665617468657262656420566965770d0a4c4c616e64697373696c696f0d; asc Featherbed View LLandissilio ; (total 66 bytes);
6: len 17; hex 56616c65206f6620476c616d6f7267616e; asc Vale of Glamorgan;;
7: len 8; hex 434636342032414c; asc CF64 2AL;;
8: len 30; hex 6361726f6c696e6577696c736f6e2e63796d727540676d61696c2e636f6d; asc carolinewilson.cymru@gmail.com;;
9: len 13; hex 30373530302038303820353035; asc 07500 808 505;;
10: len 13; hex 30373530302038303820353035; asc 07500 808 505;;
11: len 8; hex 3931413132353445; asc 91A1254E;;
12: SQL NULL;
13: len 5; hex 99a63c0000; asc < ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 4e58203434343738372044; asc NX 444787 D;;
16: len 4; hex 33343932; asc 3492;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 0; hex ; asc ;;
19: len 5; hex 9908c20000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a6b40000; asc ;;
22: len 12; hex 303031363233313837383838; asc 001623187888;;
23: len 30; hex 4d61747468657720506f747473202d203030393635203636353820343337; asc Matthew Potts - 00965 6658 437; (total 40 bytes);
24: len 5; hex 99a8d20000; asc ;;
25: len 5; hex 99a7fa0000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 11; hex 462f54204167656e63792e; asc F/T Agency.;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a8d20000; asc ;;
31: len 30; hex 30382f31312f323320416464726573732075706461746564206173206e6f; asc 08/11/23 Address updated as no; (total 946 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b9620000; asc b ;;
34: len 25; hex 4865616c746820416e64205361666574792065787069726564; asc Health And Safety expired;;
35: len 30; hex 0d0a4e4f2041264520494e205757472c204e4f204349545520494e204d4f; asc NO A&E IN WWG, NO CITU IN MO; (total 185 bytes);
36: len 0; hex ; asc ;;
37: len 1; hex 81; asc ;;
38: len 30; hex 53686966742043616e63656c6c656420666f722032352f31312f32303134; asc Shift Cancelled for 25/11/2014;;
39: len 5; hex 99a7840000; asc ;;
40: len 20; hex 000003e9000007180000000100000000000020bd; asc ;;
41: len 5; hex 99a6b60000; asc ;;
42: len 5; hex 99a7840000; asc ;;
43: len 5; hex 9962f60000; asc b ;;
44: len 5; hex 999b100000; asc ;;
45: len 5; hex 99b70e0000; asc ;;
46: len 5; hex 9947020000; asc G ;;
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 99b994e1ac; asc ;;
62: len 5; hex 99b8fc0000; asc ;;
63: len 5; hex 99acf20000; asc ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99b86a0000; asc j ;;
67: SQL NULL;
68: SQL NULL;
69: len 5; hex 99987a0000; asc z ;;
70: len 23; hex 47726f756e6420466c6f6f7220466c61742046726f6e74; asc Ground Floor Flat Front;;
71: len 15; hex 3238204869636b6d616e20526f6164; asc 28 Hickman Road;;
72: len 7; hex 50656e61727468; asc Penarth;;
73: len 12; hex 303239323020373132343333; asc 02920 712433;;
74: len 5; hex 999a320000; asc 2 ;;
75: len 5; hex 99bcb20000; asc ;;
76: len 6; hex 474220264e49; asc GB &NI;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 15; hex 57494c53373632303131434a38544d; asc WILS762011CJ8TM;;
80: len 5; hex 99a6ee0000; asc ;;
81: len 1; hex 80; asc ;;
82: len 11; hex 4a616e65204a616d657320; asc Jane James ;;
83: SQL NULL;
84: SQL NULL;
85: len 23; hex 4a616e652e4a616d65734077616c65732e6e68732e756b; asc Jane.James@wales.nhs.uk;;
86: SQL NULL;
87: SQL NULL;
88: len 30; hex 454d61696c2073656e7420746f204a616e65204a616d657320206f6e2031; asc EMail sent to Jane James on 1; (total 41 bytes);
89: len 5; hex 999ee20000; asc ;;
90: SQL NULL;
91: SQL NULL;
92: len 5; hex 99a7840000; asc ;;
93: len 5; hex 99a97c0000; asc | ;;
94: len 5; hex 99994c0000; asc L ;;
95: SQL NULL;
96: SQL NULL;
97: len 1; hex 81; asc ;;
98: len 5; hex 99b8320000; asc 2 ;;
99: len 5; hex 999aee0000; asc ;;
100: len 5; hex 99af5a0000; asc Z ;;
101: SQL NULL;
102: len 4; hex 69d90978; asc i x;;
103: len 0; hex ; asc ;;
104: SQL NULL;
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 99a8e00000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a8e00000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a8e00000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a8e00000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a8e00000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a8e00000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a8e00000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a8e00000; 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 13; hex 5265646c616e647320726f6164; asc Redlands road;;
161: len 7; hex 50656e61727468; asc Penarth;;
162: len 17; hex 56616c65206f6620676c616d6f7267616e; asc Vale of glamorgan;;
163: SQL NULL;
164: SQL NULL;
165: len 7; hex 43463634335758; asc CF643WX;;
166: len 7; hex 50656e61727468; asc Penarth;;
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: len 21; hex 5265646c616e647320726f61642073757267657279; asc Redlands 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 99a8d20000; asc ;;
227: len 5; hex 99a7840000; asc ;;
228: len 9; hex 353338363436353039; asc 538646509;;
229: len 5; hex 99a7840000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 434b353220545954; asc CK52 TYT;;
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 13; hex 4d61747468657720506f747473; asc Matthew Potts;;
245: len 7; hex 48757362616e64; asc Husband;;
246: len 9; hex 5365652042656c6f77; asc See Below;;
247: SQL NULL;
248: len 5; hex 99a7840000; asc ;;
249: len 5; hex 99a7840000; 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 524e31; asc RN1;;
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 30; hex 494c532031322d392d323520444f204e4f5420424f4f4b45442057495448; asc ILS 12-9-25 DO NOT BOOKED WITH; (total 43 bytes);
275: len 1; hex 80; asc ;;
276: SQL NULL;


*** (2) TRANSACTION:
TRANSACTION 145245917, ACTIVE 0 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 17 lock struct(s), heap size 1128, 24 row lock(s)
MySQL thread id 1635557, OS thread handle 23213011519232, query id 325914694 172.31.45.113 admin executing
UPDATE tblNurse n
left join (select * from tblNurseCompliance where ComplianceItemId = '3' ) c on n.NurseID = c.NurseId
SET `Status` = 'Archive' , DateArchived = curdate(), ReasonArchived = 'Manual Handling expired'
where RGN = 1 and `status` = 'Live' and (c.id is null or datevalue < NOW()) and CompanyName = 'Richmond'

*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1001 page no 9 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 145245917 lock_mode X locks rec but not gap
Record lock, heap no 8 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 5; hex 4152313037; asc AR107;;
1: len 6; hex 000008780483; asc x ;;
2: len 7; hex 0200000a9f0c61; asc a;;
3: len 8; hex 47656f7267696e61; asc Georgina;;
4: len 6; hex 48696c746f6e; asc Hilton;;
5: len 30; hex 323720576f6f646c616e64730d0a476f776572746f6e0d0a5377616e7365; asc 27 Woodlands Gowerton Swanse; (total 47 bytes);
6: len 7; hex 5377616e736561; asc Swansea;;
7: len 7; hex 5341342033594a; asc SA4 3YJ;;
8: len 16; hex 67696e6168696c7440616f6c2e636f6d; asc ginahilt@aol.com;;
9: len 0; hex ; asc ;;
10: len 13; hex 30373938302032393320383137; asc 07980 293 817;;
11: len 8; hex 3739413231363845; asc 79A2168E;;
12: SQL NULL;
13: len 5; hex 99a7be0000; asc ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 574b203632353734372041; asc WK 625747 A;;
16: len 4; hex 35363232; asc 5622;;
17: len 2; hex 4d73; asc Ms;;
18: len 0; hex ; asc ;;
19: len 5; hex 98e3220000; asc " ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a5d60000; asc ;;
22: len 12; hex 303031343437383234393330; asc 001447824930;;
23: len 0; hex ; asc ;;
24: len 5; hex 99a67a0000; asc z ;;
25: len 5; hex 99a6980000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 22; hex 5357414e53454120424159204d4f52524953544f4e20; asc SWANSEA BAY MORRISTON ;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a7820000; asc ;;
31: len 30; hex 31312e30312072656665726564205361726168204a61796e652043616e61; asc 11.01 refered Sarah Jayne Cana; (total 531 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b78c0000; asc ;;
34: len 26; hex 4261736963204c69666520537570706f72742065787069726564; asc Basic Life Support expired;;
35: len 30; hex 4e6f7420476f7765722057617264204d6f72726973746f6e204d47203236; asc Not Gower Ward Morriston MG 26; (total 32 bytes);
36: len 0; hex ; asc ;;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 99a6a60000; asc ;;
40: len 20; hex 000003e90000081d00000001000000000000f1eb; asc ;;
41: len 5; hex 99a5e40000; asc ;;
42: len 5; hex 99a8300000; asc 0 ;;
43: len 5; hex 99a8c40000; asc ;;
44: len 5; hex 99c4e80000; asc ;;
45: len 5; hex 9909b20000; asc ;;
46: len 5; hex 9982e40000; asc ;;
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 99b8280000; asc ( ;;
62: len 5; hex 99b8640000; asc d ;;
63: len 5; hex 99a8c40000; asc ;;
64: len 5; hex 99a8b80000; asc ;;
65: SQL NULL;
66: len 5; hex 99b7c60000; asc ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 14; hex 352043616520466f6c6c616e6420; asc 5 Cae Folland ;;
71: len 9; hex 50656e636c61776464; asc Penclawdd;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 998bea0000; asc ;;
75: len 5; hex 99ad2a0000; asc * ;;
76: len 21; hex 47422026206e6f72746865726e204972656c616e64; asc GB & northern Ireland;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 19; hex 48494c544f4e3635343137304739394d413834; asc HILTON654170G99MA84;;
80: len 5; hex 99a45e0000; asc ^ ;;
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: len 30; hex 5265666572656e636520322075706c6f61646564206d616e75616c6c7920; asc Reference 2 uploaded manually ; (total 107 bytes);
89: len 5; hex 9999160000; asc ;;
90: len 5; hex 999f0a0000; asc ;;
91: SQL NULL;
92: len 5; hex 99a8a80000; asc ;;
93: SQL NULL;
94: len 5; hex 99a8c40000; asc ;;
95: len 5; hex 99b9580000; asc X ;;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b6720000; asc r ;;
99: len 5; hex 99a8c40000; asc ;;
100: len 5; hex 99adac0000; asc ;;
101: SQL NULL;
102: len 4; hex 69b2c7fd; asc i ;;
103: len 0; hex ; asc ;;
104: len 5; hex 99a8c40000; asc ;;
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: len 5; hex 99a8300000; asc 0 ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a6a60000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a6a60000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a6a60000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a8320000; asc 2 ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a8a80000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a8300000; asc 0 ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a8300000; asc 0 ;;
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 80; asc ;;
147: len 1; hex 80; asc ;;
148: len 1; hex 80; asc ;;
149: len 1; hex 80; asc ;;
150: len 1; hex 80; asc ;;
151: len 1; hex 80; 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 8; hex 4d696c6c20737420; asc Mill st ;;
161: len 8; hex 476f776572746f6e; asc Gowerton;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 7; hex 53413420334544; asc SA4 3ED;;
166: len 7; hex 5357414e534541; asc SWANSEA;;
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: len 23; hex 457374756172792067726f757020707261637469636520; asc Estuary group practice ;;
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 99a67a0000; asc z ;;
227: len 5; hex 99a8300000; asc 0 ;;
228: len 0; hex ; asc ;;
229: len 5; hex 99a89c0000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 4356323320595a54; asc CV23 YZT;;
235: SQL NULL;
236: SQL NULL;
237: SQL NULL;
238: SQL NULL;
239: len 5; hex 99a7820000; asc ;;
240: SQL NULL;
241: SQL NULL;
242: SQL NULL;
243: len 0; hex ; asc ;;
244: len 12; hex 44617669642048696c746f6e; asc David Hilton;;
245: len 10; hex 45782048757362616e64; asc Ex Husband;;
246: len 11; hex 3037393830323933383532; asc 07980293852;;
247: SQL NULL;
248: len 5; hex 99a8a80000; asc ;;
249: len 5; hex 99a61c0000; 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: len 5; hex 99a8c4edef; asc ;;
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 30; hex 524e3120524e3220204e4f4e2045505020666f7220414d41552050504820; asc RN1 RN2 NON EPP for AMAU PPH ; (total 34 bytes);
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 28; hex 494c53202032352074682053657074656d62657220696e20776f726b; asc ILS 25 th September in work;;
275: len 1; hex 80; asc ;;
276: SQL NULL;

Record lock, heap no 10 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 5; hex 4152303236; asc AR026;;
1: len 6; hex 0000089f435b; asc C[;;
2: len 7; hex 01000017c018b9; asc ;;
3: len 8; hex 4361726f6c696e65; asc Caroline;;
4: len 6; hex 57696c736f6e; asc Wilson;;
5: len 30; hex 4665617468657262656420566965770d0a4c4c616e64697373696c696f0d; asc Featherbed View LLandissilio ; (total 66 bytes);
6: len 17; hex 56616c65206f6620476c616d6f7267616e; asc Vale of Glamorgan;;
7: len 8; hex 434636342032414c; asc CF64 2AL;;
8: len 30; hex 6361726f6c696e6577696c736f6e2e63796d727540676d61696c2e636f6d; asc carolinewilson.cymru@gmail.com;;
9: len 13; hex 30373530302038303820353035; asc 07500 808 505;;
10: len 13; hex 30373530302038303820353035; asc 07500 808 505;;
11: len 8; hex 3931413132353445; asc 91A1254E;;
12: SQL NULL;
13: len 5; hex 99a63c0000; asc < ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 4e58203434343738372044; asc NX 444787 D;;
16: len 4; hex 33343932; asc 3492;;
17: len 3; hex 4d7273; asc Mrs;;
18: len 0; hex ; asc ;;
19: len 5; hex 9908c20000; asc ;;
20: len 6; hex 46656d616c65; asc Female;;
21: len 5; hex 99a6b40000; asc ;;
22: len 12; hex 303031363233313837383838; asc 001623187888;;
23: len 30; hex 4d61747468657720506f747473202d203030393635203636353820343337; asc Matthew Potts - 00965 6658 437; (total 40 bytes);
24: len 5; hex 99a8d20000; asc ;;
25: len 5; hex 99a7fa0000; asc ;;
26: len 9; hex 46756c6c2054696d65; asc Full Time;;
27: len 11; hex 462f54204167656e63792e; asc F/T Agency.;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 99a8d20000; asc ;;
31: len 30; hex 30382f31312f323320416464726573732075706461746564206173206e6f; asc 08/11/23 Address updated as no; (total 946 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b9620000; asc b ;;
34: len 25; hex 4865616c746820416e64205361666574792065787069726564; asc Health And Safety expired;;
35: len 30; hex 0d0a4e4f2041264520494e205757472c204e4f204349545520494e204d4f; asc NO A&E IN WWG, NO CITU IN MO; (total 185 bytes);
36: len 0; hex ; asc ;;
37: len 1; hex 81; asc ;;
38: len 30; hex 53686966742043616e63656c6c656420666f722032352f31312f32303134; asc Shift Cancelled for 25/11/2014;;
39: len 5; hex 99a7840000; asc ;;
40: len 20; hex 000003e9000007180000000100000000000020bd; asc ;;
41: len 5; hex 99a6b60000; asc ;;
42: len 5; hex 99a7840000; asc ;;
43: len 5; hex 9962f60000; asc b ;;
44: len 5; hex 999b100000; asc ;;
45: len 5; hex 99b70e0000; asc ;;
46: len 5; hex 9947020000; asc G ;;
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 99b994e1ac; asc ;;
62: len 5; hex 99b8fc0000; asc ;;
63: len 5; hex 99acf20000; asc ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99b86a0000; asc j ;;
67: SQL NULL;
68: SQL NULL;
69: len 5; hex 99987a0000; asc z ;;
70: len 23; hex 47726f756e6420466c6f6f7220466c61742046726f6e74; asc Ground Floor Flat Front;;
71: len 15; hex 3238204869636b6d616e20526f6164; asc 28 Hickman Road;;
72: len 7; hex 50656e61727468; asc Penarth;;
73: len 12; hex 303239323020373132343333; asc 02920 712433;;
74: len 5; hex 999a320000; asc 2 ;;
75: len 5; hex 99bcb20000; asc ;;
76: len 6; hex 474220264e49; asc GB &NI;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 15; hex 57494c53373632303131434a38544d; asc WILS762011CJ8TM;;
80: len 5; hex 99a6ee0000; asc ;;
81: len 1; hex 80; asc ;;
82: len 11; hex 4a616e65204a616d657320; asc Jane James ;;
83: SQL NULL;
84: SQL NULL;
85: len 23; hex 4a616e652e4a616d65734077616c65732e6e68732e756b; asc Jane.James@wales.nhs.uk;;
86: SQL NULL;
87: SQL NULL;
88: len 30; hex 454d61696c2073656e7420746f204a616e65204a616d657320206f6e2031; asc EMail sent to Jane James on 1; (total 41 bytes);
89: len 5; hex 999ee20000; asc ;;
90: SQL NULL;
91: SQL NULL;
92: len 5; hex 99a7840000; asc ;;
93: len 5; hex 99a97c0000; asc | ;;
94: len 5; hex 99994c0000; asc L ;;
95: SQL NULL;
96: SQL NULL;
97: len 1; hex 81; asc ;;
98: len 5; hex 99b8320000; asc 2 ;;
99: len 5; hex 999aee0000; asc ;;
100: len 5; hex 99af5a0000; asc Z ;;
101: SQL NULL;
102: len 4; hex 69d90978; asc i x;;
103: len 0; hex ; asc ;;
104: SQL NULL;
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 99a8e00000; asc ;;
120: SQL NULL;
121: SQL NULL;
122: len 5; hex 99a8e00000; asc ;;
123: SQL NULL;
124: SQL NULL;
125: len 5; hex 99a8e00000; asc ;;
126: SQL NULL;
127: SQL NULL;
128: len 5; hex 99a8e00000; asc ;;
129: SQL NULL;
130: SQL NULL;
131: len 5; hex 99a8e00000; asc ;;
132: SQL NULL;
133: SQL NULL;
134: len 5; hex 99a8e00000; asc ;;
135: SQL NULL;
136: SQL NULL;
137: len 5; hex 99a8e00000; asc ;;
138: SQL NULL;
139: SQL NULL;
140: len 5; hex 99a8e00000; 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 13; hex 5265646c616e647320726f6164; asc Redlands road;;
161: len 7; hex 50656e61727468; asc Penarth;;
162: len 17; hex 56616c65206f6620676c616d6f7267616e; asc Vale of glamorgan;;
163: SQL NULL;
164: SQL NULL;
165: len 7; hex 43463634335758; asc CF643WX;;
166: len 7; hex 50656e61727468; asc Penarth;;
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: len 21; hex 5265646c616e647320726f61642073757267657279; asc Redlands 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 99a8d20000; asc ;;
227: len 5; hex 99a7840000; asc ;;
228: len 9; hex 353338363436353039; asc 538646509;;
229: len 5; hex 99a7840000; asc ;;
230: SQL NULL;
231: SQL NULL;
232: SQL NULL;
233: SQL NULL;
234: len 8; hex 434b353220545954; asc CK52 TYT;;
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 13; hex 4d61747468657720506f747473; asc Matthew Potts;;
245: len 7; hex 48757362616e64; asc Husband;;
246: len 9; hex 5365652042656c6f77; asc See Below;;
247: SQL NULL;
248: len 5; hex 99a7840000; asc ;;
249: len 5; hex 99a7840000; 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 524e31; asc RN1;;
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 30; hex 494c532031322d392d323520444f204e4f5420424f4f4b45442057495448; asc ILS 12-9-25 DO NOT BOOKED WITH; (total 43 bytes);
275: len 1; hex 80; asc ;;
276: SQL NULL;


*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1001 page no 179 n bits 80 index PRIMARY of table `richmond`.`tblNurse` trx id 145245917 lock_mode X locks rec but not gap waiting
Record lock, heap no 6 PHYSICAL RECORD: n_fields 277; compact format; info bits 64
0: len 6; hex 505331313431; asc PS1141;;
1: len 6; hex 00000883d8cd; asc ;;
2: len 7; hex 0200000704071b; asc ;;
3: len 17; hex 4368726973746f70686572204d61726b20; asc Christopher Mark ;;
4: len 6; hex 4b6561676c65; asc Keagle;;
5: SQL NULL;
6: len 8; hex 4272696467656e64; asc Bridgend;;
7: len 8; hex 4346333120314e4e; asc CF31 1NN;;
8: len 23; hex 6561676c65636d6b40676f6f676c656d61696c2e636f6d; asc eaglecmk@googlemail.com;;
9: len 13; hex 30313635362036363720303736; asc 01656 667 076;;
10: len 13; hex 30373336362034313620323935; asc 07366 416 295;;
11: len 8; hex 3834433030363757; asc 84C0067W;;
12: SQL NULL;
13: len 5; hex 999cfc0000; asc ;;
14: len 4; hex 4c697665; asc Live;;
15: len 11; hex 574d203637343337392044; asc WM 674379 D;;
16: len 5; hex 3431363239; asc 41629;;
17: len 2; hex 4d72; asc Mr;;
18: len 2; hex 434d; asc CM;;
19: len 5; hex 98eab40000; asc ;;
20: len 4; hex 4d616c65; asc Male;;
21: len 5; hex 99a3a40000; asc ;;
22: len 12; hex 303031353337393332393630; asc 001537932960;;
23: len 26; hex 57656e6479202857696665292030373731392032383520363038; asc Wendy (Wife) 07719 285 608;;
24: len 5; hex 999cc60000; asc ;;
25: len 5; hex 999cfc0000; asc ;;
26: len 9; hex 506172742054696d65; asc Part Time;;
27: len 16; hex 46756c6c2054696d65204167656e6379; asc Full Time Agency;;
28: len 4; hex 80000000; asc ;;
29: len 4; hex 80000000; asc ;;
30: len 5; hex 999c6c0000; asc l ;;
31: len 30; hex 31332e30392e323120726566657272656420416d616e6461204a61636b73; asc 13.09.21 referred Amanda Jacks; (total 36 bytes);
32: len 4; hex 80000001; asc ;;
33: len 5; hex 99b7e40000; asc ;;
34: len 25; hex 496e66656374696f6e20436f6e74726f6c2065787069726564; asc Infection Control expired;;
35: SQL NULL;
36: SQL NULL;
37: len 1; hex 80; asc ;;
38: SQL NULL;
39: len 5; hex 999ce80000; asc ;;
40: len 20; hex 000003e900000163000000010000000000007800; asc c x ;;
41: len 5; hex 999b3e0000; asc > ;;
42: len 5; hex 999ce80000; asc ;;
43: len 5; hex 99a8040000; asc ;;
44: len 5; hex 99a7680000; asc h ;;
45: len 5; hex 9999560000; asc V ;;
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 99b7b2fcd9; asc ;;
62: len 5; hex 99b7d00000; asc ;;
63: len 5; hex 99a7f60000; asc ;;
64: SQL NULL;
65: len 1; hex 80; asc ;;
66: len 5; hex 99b76c0000; asc l ;;
67: SQL NULL;
68: SQL NULL;
69: SQL NULL;
70: len 23; hex 3339204772656174205765737465726e204176656e7565; asc 39 Great Western Avenue;;
71: len 0; hex ; asc ;;
72: len 0; hex ; asc ;;
73: len 0; hex ; asc ;;
74: len 5; hex 997c1e0000; asc | ;;
75: len 5; hex 999c9e0000; asc ;;
76: len 5; hex 57616c6573; asc Wales;;
77: len 0; hex ; asc ;;
78: len 0; hex ; asc ;;
79: len 18; hex 4b4541474c363038323632434d394d463234; asc KEAGL608262CM9MF24;;
80: len 5; hex 99a59a0000; asc ;;
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: len 30; hex 5265666572656e636520322075706c6f61646564206d616e75616c6c7920; asc Reference 2 uploaded manually ; (total 274 bytes);
89: len 5; hex 9999180000; asc ;;
90: len 5; hex 99999a0000; asc ;;
91: SQL NULL;
92: len 5; hex 999ce80000; asc ;;
93: SQL NULL;
94: len 5; hex 99a7f60000; asc ;;
95: SQL NULL;
96: len 1; hex 80; asc ;;
97: SQL NULL;
98: len 5; hex 99b6600000; asc ` ;;
99: len 5; hex 99a7f40000; asc ;;
100: len 5; hex 99ae660000; asc f ;;
101: SQL NULL;
102: len 4; hex 69be7b62; asc i {b;;
103: len 5; hex 4368726973; asc Chris;;
104: len 5; hex 99a8040000; 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: 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: len 9; hex 436f6d706c65746564; asc Completed;;
144: SQL NULL;
145: len 5; hex 99a7700000; asc p ;;
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 18; hex 4e6577636173746c65207375726765727920; asc Newcastle surgery ;;
161: len 16; hex 4c6c616e67657779646420526f616420; asc Llangewydd Road ;;
162: len 0; hex ; asc ;;
163: SQL NULL;
164: SQL NULL;
165: len 7; hex 43463331345858; asc CF314XX;;
166: len 9; hex 4272696467656e6420; asc Bridgend ;;
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: len 24; hex 4272696467656e642067726f757020707261637469636520; asc Bridgend group practice ;;
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: 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 5; hex 57656e6479; asc Wendy;;
245: len 4; hex 57696665; asc Wife;;
246: len 12; hex 303737313920323835363038; asc 07719 285608;;
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: len 5; hex 99a7f50c85; asc ;;
263: len 1; hex 37; asc 7;;
264: len 4; hex 50415945; asc PAYE;;
265: SQL NULL;
266: SQL NULL;
267: SQL NULL;
268: len 3; hex 524e31; asc RN1;;
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;

*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 145683968
Purge done for trx's n:o < 145683968 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304689698574320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304689698573512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304689698572704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304689698571896, 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
96407 OS file reads, 4786912 OS file writes, 2241990 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.99 writes/s, 0.07 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 12099, seg size 12101, 2451 merges
merged operations:
insert 2956, delete mark 3229, delete 2091
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 1741 buffer(s)
Hash table size 276707, node heap has 253 buffer(s)
Hash table size 276707, node heap has 86 buffer(s)
Hash table size 276707, node heap has 186 buffer(s)
Hash table size 276707, node heap has 34 buffer(s)
Hash table size 276707, node heap has 47 buffer(s)
Hash table size 276707, node heap has 238 buffer(s)
Hash table size 276707, node heap has 157 buffer(s)
7.21 hash searches/s, 12.28 non-hash searches/s
---
LOG
---
Log sequence number 245070991550
Log buffer assigned up to 245070991550
Log buffer completed up to 245070991550
Log written up to 245070991550
Log flushed up to 245070991550
Added dirty pages up to 245070991550
Pages flushed up to 245070991550
Last checkpoint at 245070991550
Log minimum file id is 1721
Log maximum file id is 1739
2267438 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 1846477
Buffer pool size 65530
Free buffers 8212
Database pages 54576
Old database pages 19984
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1957172, not young 2430702
1.70 youngs/s, 0.00 non-youngs/s
Pages read 95619, created 94116, written 2037867
0.00 reads/s, 0.21 creates/s, 0.92 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: 54576, unzip_LRU len: 0
I/O sum[304]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8192
Free buffers 1025
Database pages 6827
Old database pages 2500
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 150168, not young 212888
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11084, created 13694, written 218389
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: 6827, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8191
Free buffers 1024
Database pages 6832
Old database pages 2502
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 130488, not young 881291
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13851, created 8404, written 166383
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: 6832, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1024
Database pages 6808
Old database pages 2493
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 158177, not young 209839
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11988, created 13097, written 83353
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6808, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1028
Database pages 6824
Old database pages 2499
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 75665, not young 183695
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12033, created 8081, written 79246
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: 6824, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8192
Free buffers 1026
Database pages 6821
Old database pages 2497
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 109588, not young 210128
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11432, created 13159, written 117409
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6821, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1024
Database pages 6820
Old database pages 2497
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1082651, not young 244585
1.42 youngs/s, 0.00 non-youngs/s
Pages read 12093, created 8551, written 1052190
0.00 reads/s, 0.00 creates/s, 0.85 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6820, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1032
Database pages 6818
Old database pages 2497
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 148690, not young 347276
0.28 youngs/s, 0.00 non-youngs/s
Pages read 11029, created 20606, written 112445
0.00 reads/s, 0.21 creates/s, 0.07 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6818, unzip_LRU len: 0
I/O sum[38]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8191
Free buffers 1029
Database pages 6826
Old database pages 2499
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 101745, not young 141000
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12109, created 8524, written 208452
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: 6826, unzip_LRU len: 0
I/O sum[38]: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=23213327243008 , state=sleeping
Number of rows inserted 15493554, updated 73240, deleted 334640, read 180773615975
14.50 inserts/s, 0.00 updates/s, 0.00 deletes/s, 64848.15 reads/s
Number of system rows inserted 107294, updated 57655, deleted 84419, read 11985654
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 30.64 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

---

Process List

5	event_scheduler	localhost		Daemon	1469265	Waiting on empty queue
1860358	rdsadmin	localhost	mysql	Sleep	2
1860401	rdsadmin	localhost		Sleep	7
2229559	admin	172.31.45.113:48370	richmond	Query	0	init	show full processlist
2229560	admin	172.31.45.113:48378	richmond_registrations	Sleep	0
2229561	admin	172.31.45.113:48386	data_warehouse	Sleep	0

---

Running Transactions