1##########################################
2# Run plugin
3##########################################
4INSTALL PLUGIN test_session_in_thd SONAME 'TEST_SESSION_IN_THD';
5SHOW VARIABLES LIKE '%test_session%';
6Variable_name	Value
7test_session_in_thd_nb_sessions	100
8SELECT sleep(3);
9sleep(3)
100
11##########################################
12# Stop plugin
13##########################################
14UNINSTALL PLUGIN test_session_in_thd;
15##########################################
16# Plugin log
17##########################################
18Follows threaded run
19============================================================================================
20init thread
21sql open session 0.
22sql open session 1.
23sql open session 2.
24sql open session 3.
25sql open session 4.
26sql open session 5.
27sql open session 6.
28sql open session 7.
29sql open session 8.
30sql open session 9.
31sql open session 10.
32sql open session 11.
33sql open session 12.
34sql open session 13.
35sql open session 14.
36sql open session 15.
37sql open session 16.
38sql open session 17.
39sql open session 18.
40sql open session 19.
41sql open session 20.
42sql open session 21.
43sql open session 22.
44sql open session 23.
45sql open session 24.
46sql open session 25.
47sql open session 26.
48sql open session 27.
49sql open session 28.
50sql open session 29.
51sql open session 30.
52sql open session 31.
53sql open session 32.
54sql open session 33.
55sql open session 34.
56sql open session 35.
57sql open session 36.
58sql open session 37.
59sql open session 38.
60sql open session 39.
61sql open session 40.
62sql open session 41.
63sql open session 42.
64sql open session 43.
65sql open session 44.
66sql open session 45.
67sql open session 46.
68sql open session 47.
69sql open session 48.
70sql open session 49.
71sql open session 50.
72sql open session 51.
73sql open session 52.
74sql open session 53.
75sql open session 54.
76sql open session 55.
77sql open session 56.
78sql open session 57.
79sql open session 58.
80sql open session 59.
81sql open session 60.
82sql open session 61.
83sql open session 62.
84sql open session 63.
85sql open session 64.
86sql open session 65.
87sql open session 66.
88sql open session 67.
89sql open session 68.
90sql open session 69.
91sql open session 70.
92sql open session 71.
93sql open session 72.
94sql open session 73.
95sql open session 74.
96sql open session 75.
97sql open session 76.
98sql open session 77.
99sql open session 78.
100sql open session 79.
101sql open session 80.
102sql open session 81.
103sql open session 82.
104sql open session 83.
105sql open session 84.
106sql open session 85.
107sql open session 86.
108sql open session 87.
109sql open session 88.
110sql open session 89.
111sql open session 90.
112sql open session 91.
113sql open session 92.
114sql open session 93.
115sql open session 94.
116sql open session 95.
117sql open session 96.
118sql open session 97.
119sql open session 98.
120sql open session 99.
121close following nb of sessions: 100
122sql session close session 99.
123sql session close session 98.
124sql session close session 97.
125sql session close session 96.
126sql session close session 95.
127sql session close session 94.
128sql session close session 93.
129sql session close session 92.
130sql session close session 91.
131sql session close session 90.
132sql session close session 89.
133sql session close session 88.
134sql session close session 87.
135sql session close session 86.
136sql session close session 85.
137sql session close session 84.
138sql session close session 83.
139sql session close session 82.
140sql session close session 81.
141sql session close session 80.
142sql session close session 79.
143sql session close session 78.
144sql session close session 77.
145sql session close session 76.
146sql session close session 75.
147sql session close session 74.
148sql session close session 73.
149sql session close session 72.
150sql session close session 71.
151sql session close session 70.
152sql session close session 69.
153sql session close session 68.
154sql session close session 67.
155sql session close session 66.
156sql session close session 65.
157sql session close session 64.
158sql session close session 63.
159sql session close session 62.
160sql session close session 61.
161sql session close session 60.
162sql session close session 59.
163sql session close session 58.
164sql session close session 57.
165sql session close session 56.
166sql session close session 55.
167sql session close session 54.
168sql session close session 53.
169sql session close session 52.
170sql session close session 51.
171sql session close session 50.
172sql session close session 49.
173sql session close session 48.
174sql session close session 47.
175sql session close session 46.
176sql session close session 45.
177sql session close session 44.
178sql session close session 43.
179sql session close session 42.
180sql session close session 41.
181sql session close session 40.
182sql session close session 39.
183sql session close session 38.
184sql session close session 37.
185sql session close session 36.
186sql session close session 35.
187sql session close session 34.
188sql session close session 33.
189sql session close session 32.
190sql session close session 31.
191sql session close session 30.
192sql session close session 29.
193sql session close session 28.
194sql session close session 27.
195sql session close session 26.
196sql session close session 25.
197sql session close session 24.
198sql session close session 23.
199sql session close session 22.
200sql session close session 21.
201sql session close session 20.
202sql session close session 19.
203sql session close session 18.
204sql session close session 17.
205sql session close session 16.
206sql session close session 15.
207sql session close session 14.
208sql session close session 13.
209sql session close session 12.
210sql session close session 11.
211sql session close session 10.
212sql session close session 9.
213sql session close session 8.
214sql session close session 7.
215sql session close session 6.
216sql session close session 5.
217sql session close session 4.
218sql session close session 3.
219sql session close session 2.
220sql session close session 1.
221sql session close session 0.
222sql open session 0.
223sql open session 1.
224sql open session 2.
225sql open session 3.
226sql open session 4.
227sql open session 5.
228sql open session 6.
229sql open session 7.
230sql open session 8.
231sql open session 9.
232sql open session 10.
233sql open session 11.
234sql open session 12.
235sql open session 13.
236sql open session 14.
237sql open session 15.
238sql open session 16.
239sql open session 17.
240sql open session 18.
241sql open session 19.
242sql open session 20.
243sql open session 21.
244sql open session 22.
245sql open session 23.
246sql open session 24.
247sql open session 25.
248sql open session 26.
249sql open session 27.
250sql open session 28.
251sql open session 29.
252sql open session 30.
253sql open session 31.
254sql open session 32.
255sql open session 33.
256sql open session 34.
257sql open session 35.
258sql open session 36.
259sql open session 37.
260sql open session 38.
261sql open session 39.
262sql open session 40.
263sql open session 41.
264sql open session 42.
265sql open session 43.
266sql open session 44.
267sql open session 45.
268sql open session 46.
269sql open session 47.
270sql open session 48.
271sql open session 49.
272sql open session 50.
273sql open session 51.
274sql open session 52.
275sql open session 53.
276sql open session 54.
277sql open session 55.
278sql open session 56.
279sql open session 57.
280sql open session 58.
281sql open session 59.
282sql open session 60.
283sql open session 61.
284sql open session 62.
285sql open session 63.
286sql open session 64.
287sql open session 65.
288sql open session 66.
289sql open session 67.
290sql open session 68.
291sql open session 69.
292sql open session 70.
293sql open session 71.
294sql open session 72.
295sql open session 73.
296sql open session 74.
297sql open session 75.
298sql open session 76.
299sql open session 77.
300sql open session 78.
301sql open session 79.
302sql open session 80.
303sql open session 81.
304sql open session 82.
305sql open session 83.
306sql open session 84.
307sql open session 85.
308sql open session 86.
309sql open session 87.
310sql open session 88.
311sql open session 89.
312sql open session 90.
313sql open session 91.
314sql open session 92.
315sql open session 93.
316sql open session 94.
317sql open session 95.
318sql open session 96.
319sql open session 97.
320sql open session 98.
321sql open session 99.
322close following nb of sessions: 100
323sql session close session 0.
324sql session close session 1.
325sql session close session 2.
326sql session close session 3.
327sql session close session 4.
328sql session close session 5.
329sql session close session 6.
330sql session close session 7.
331sql session close session 8.
332sql session close session 9.
333sql session close session 10.
334sql session close session 11.
335sql session close session 12.
336sql session close session 13.
337sql session close session 14.
338sql session close session 15.
339sql session close session 16.
340sql session close session 17.
341sql session close session 18.
342sql session close session 19.
343sql session close session 20.
344sql session close session 21.
345sql session close session 22.
346sql session close session 23.
347sql session close session 24.
348sql session close session 25.
349sql session close session 26.
350sql session close session 27.
351sql session close session 28.
352sql session close session 29.
353sql session close session 30.
354sql session close session 31.
355sql session close session 32.
356sql session close session 33.
357sql session close session 34.
358sql session close session 35.
359sql session close session 36.
360sql session close session 37.
361sql session close session 38.
362sql session close session 39.
363sql session close session 40.
364sql session close session 41.
365sql session close session 42.
366sql session close session 43.
367sql session close session 44.
368sql session close session 45.
369sql session close session 46.
370sql session close session 47.
371sql session close session 48.
372sql session close session 49.
373sql session close session 50.
374sql session close session 51.
375sql session close session 52.
376sql session close session 53.
377sql session close session 54.
378sql session close session 55.
379sql session close session 56.
380sql session close session 57.
381sql session close session 58.
382sql session close session 59.
383sql session close session 60.
384sql session close session 61.
385sql session close session 62.
386sql session close session 63.
387sql session close session 64.
388sql session close session 65.
389sql session close session 66.
390sql session close session 67.
391sql session close session 68.
392sql session close session 69.
393sql session close session 70.
394sql session close session 71.
395sql session close session 72.
396sql session close session 73.
397sql session close session 74.
398sql session close session 75.
399sql session close session 76.
400sql session close session 77.
401sql session close session 78.
402sql session close session 79.
403sql session close session 80.
404sql session close session 81.
405sql session close session 82.
406sql session close session 83.
407sql session close session 84.
408sql session close session 85.
409sql session close session 86.
410sql session close session 87.
411sql session close session 88.
412sql session close session 89.
413sql session close session 90.
414sql session close session 91.
415sql session close session 92.
416sql session close session 93.
417sql session close session 94.
418sql session close session 95.
419sql session close session 96.
420sql session close session 97.
421sql session close session 98.
422sql session close session 99.
423deinit thread
424