1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
##########################################
# Run plugin
##########################################
SHOW PROCESSLIST;
Id User Host db Command Time State Info
ID event_scheduler HOST_NAME NULL Daemon TIME Waiting on empty queue NULL
ID root HOST_NAME test Query TIME init SHOW PROCESSLIST
Warnings:
ID 1287 HOST_NAME
INSTALL PLUGIN test_x_sessions_init SONAME 'libtest_x_sessions_init.so';
SHOW VARIABLES LIKE '%test_x_session%';
Variable_name Value
test_x_sessions_init_nb_sessions 5
SHOW PROCESSLIST;
Id User Host db Command Time State Info
ID event_scheduler HOST_NAME NULL Daemon TIME Waiting on empty queue NULL
ID root HOST_NAME test Query TIME init SHOW PROCESSLIST
Warnings:
ID 1287 HOST_NAME
##########################################
# Stop plugin
##########################################
UNINSTALL PLUGIN test_x_sessions_init;
##########################################
# Plugin log
##########################################
========================================================================
Test in a server thread
srv_session_open 0
srv_session_open 1
srv_session_open 2
srv_session_open 3
srv_session_open 4
Number of threads of this plugin: 0
Number of threads of all (NULL) plugins: 0
srv_session_close 4
srv_session_close 3
srv_session_close 2
srv_session_close 1
srv_session_close 0
srv_session_open 0
srv_session_open 1
srv_session_open 2
srv_session_open 3
srv_session_open 4
Number of open sessions: 5
srv_session_close 0
srv_session_close 1
srv_session_close 2
srv_session_close 3
srv_session_close 4
Number of open sessions: 0
Number of threads: 0
Follows threaded run
========================================================================
init thread
srv_session_open 0
srv_session_open 1
srv_session_open 2
srv_session_open 3
srv_session_open 4
Number of threads of this plugin: 1
Number of threads of all (NULL) plugins: 1
srv_session_close 4
srv_session_close 3
srv_session_close 2
srv_session_close 1
srv_session_close 0
deinit thread
========================================================================
init thread
srv_session_open 0
srv_session_open 1
srv_session_open 2
srv_session_open 3
srv_session_open 4
Number of open sessions: 5
srv_session_close 0
srv_session_close 1
srv_session_close 2
srv_session_close 3
srv_session_close 4
Number of open sessions: 0
deinit thread
========================================================================
init thread
deinit thread
|
