Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_x_sessions_init.result

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