Debian Codegraph @

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

raw
1 /*first*/SELECT * FROM information_schema.processlist WHERE command LIKE 'query';
2 ID USER HOST DB COMMAND TIME STATE INFO
3 <ID> root <HOST_NAME> test Query <TIME> executing /*first*/SELECT * FROM information_schema.processlist WHERE command LIKE 'query'
4 Warnings:
5 <ID> 1287 <HOST_NAME>
6 ##########################################
7 # Run plugin
8 ##########################################
9 INSTALL PLUGIN test_sql_processlist SONAME 'TEST_SQL_PROCESSLIST';
10 ##########################################
11 # Plugin log
12 ##########################################
13 ========================================================================
14 Test in a server thread
15 Opening Session 1
16 -----------------------------------------------------------------
17 Session 1 :
18 -----------------------------------------------------------------
19 /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
20 num_cols : 4
21 nb rows : 1
22 -----------------------------------------------------------------
23 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
24 root [NULL] Query PLUGIN: /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
25
26 affected rows : 0
27 server status : 34
28 warn count : 1
29
30 Opening Session 2
31 -----------------------------------------------------------------
32 Session 1 :
33 -----------------------------------------------------------------
34 /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
35 num_cols : 4
36 nb rows : 2
37 -----------------------------------------------------------------
38 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
39 root [NULL] Query PLUGIN: /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
40 root [NULL] Sleep PLUGIN
41
42 affected rows : 0
43 server status : 34
44 warn count : 1
45 -----------------------------------------------------------------
46 Session 2 :
47 -----------------------------------------------------------------
48 /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
49 num_cols : 4
50 nb rows : 2
51 -----------------------------------------------------------------
52 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
53 root [NULL] Sleep PLUGIN
54 root [NULL] Query PLUGIN: /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
55
56 affected rows : 0
57 server status : 34
58 warn count : 1
59
60 Close Session 1
61 -----------------------------------------------------------------
62 Session 2 :
63 -----------------------------------------------------------------
64 /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
65 num_cols : 4
66 nb rows : 1
67 -----------------------------------------------------------------
68 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
69 root [NULL] Query PLUGIN: /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
70
71 affected rows : 0
72 server status : 34
73 warn count : 1
74
75 Close Session 2
76 Follows threaded run
77 ========================================================================
78 init thread
79 Opening Session 1
80 -----------------------------------------------------------------
81 Session 1 :
82 -----------------------------------------------------------------
83 /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
84 num_cols : 4
85 nb rows : 1
86 -----------------------------------------------------------------
87 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
88 root [NULL] Query PLUGIN: /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
89
90 affected rows : 0
91 server status : 34
92 warn count : 1
93
94 Opening Session 2
95 -----------------------------------------------------------------
96 Session 1 :
97 -----------------------------------------------------------------
98 /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
99 num_cols : 4
100 nb rows : 2
101 -----------------------------------------------------------------
102 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
103 root [NULL] Query PLUGIN: /*Session_1*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
104 root [NULL] Sleep PLUGIN
105
106 affected rows : 0
107 server status : 34
108 warn count : 1
109 -----------------------------------------------------------------
110 Session 2 :
111 -----------------------------------------------------------------
112 /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
113 num_cols : 4
114 nb rows : 2
115 -----------------------------------------------------------------
116 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
117 root [NULL] Sleep PLUGIN
118 root [NULL] Query PLUGIN: /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
119
120 affected rows : 0
121 server status : 34
122 warn count : 1
123
124 Close Session 1
125 -----------------------------------------------------------------
126 Session 2 :
127 -----------------------------------------------------------------
128 /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
129 num_cols : 4
130 nb rows : 1
131 -----------------------------------------------------------------
132 user VARCHAR(15) db VARCHAR(15) command VARCHAR(15) info BLOB(252)
133 root [NULL] Query PLUGIN: /*Session_2*/ SELECT user,db,command,info FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' order by id
134
135 affected rows : 0
136 server status : 34
137 warn count : 1
138
139 Close Session 2
140 deinit thread
141 ##########################################
142 # Stop plugin
143 ##########################################
144 UNINSTALL PLUGIN test_sql_processlist;
145 /*second*/SELECT * FROM information_schema.processlist WHERE command LIKE 'query';
146 ID USER HOST DB COMMAND TIME STATE INFO
147 <ID> root <HOST_NAME> test Query <TIME> executing /*second*/SELECT * FROM information_schema.processlist WHERE command LIKE 'query'
148 Warnings:
149 <ID> 1287 <HOST_NAME>