Debian Codegraph @

mysql-test/suite/perfschema/r/show_aggregate.result

raw
1
2 ================================================================================
3 SETUP
4 ================================================================================
5 SET @@session.sql_log_bin=OFF;
6
7 # CREATE 3 CLIENTS, 3 CONNECTIONS, RESULTS TABLE
8 connection default;
9 USE test;
10
11 # Create results table
12 CREATE TABLE test.status_results
13 (variable_name VARCHAR(64), start INT DEFAULT 0, stop INT DEFAULT 0, delta INT DEFAULT 0,
14 t1 INT DEFAULT 0, t2 INT DEFAULT 0, t3 INT DEFAULT 0, thread INT DEFAULT 0,
15 u1 INT DEFAULT 0, u2 INT DEFAULT 0, u3 INT DEFAULT 0, user INT DEFAULT 0,
16 h1 INT DEFAULT 0, h2 INT DEFAULT 0, h3 INT DEFAULT 0, host INT DEFAULT 0,
17 a1 INT DEFAULT 0, a2 INT DEFAULT 0, a3 INT DEFAULT 0, acct INT DEFAULT 0);
18 INSERT INTO test.status_results (variable_name, start)
19 SELECT sg.variable_name, sg.variable_value+0 FROM performance_schema.global_status sg
20 WHERE variable_name IN ('handler_delete', 'handler_rollback');
21
22 # Create test tables
23 CREATE TABLE t1 (s1 int) ENGINE=InnoDB;
24 INSERT INTO t1 VALUES (1), (2), (2), (3), (3), (3);
25 CREATE TABLE t2 (s1 int) ENGINE=InnoDB;
26 CREATE TABLE t3 (s1 int) ENGINE=InnoDB;
27
28 CREATE USER 'user1'@localhost, 'user2'@localhost, 'user3'@localhost;
29 GRANT ALL ON *.* to 'user1'@localhost;
30 GRANT ALL ON *.* to 'user2'@localhost;
31 GRANT ALL ON *.* to 'user3'@localhost;
32
33 ================================================================================
34 CONNECTION 1: DELETE 1, ROLLBACK x 1
35 ================================================================================
36 connect con1, localhost, user1,,;
37 SET @@session.sql_log_bin=OFF;
38 DELETE FROM t1 WHERE s1 = 1;
39 START TRANSACTION;
40 INSERT INTO t1 VALUES (1);
41 ROLLBACK;
42
43 ================================================================================
44 CONNECTION 2: DELETE 2, ROLLBACK x 2
45 ================================================================================
46 connect con2, localhost, user2,,;
47 SET @@session.sql_log_bin=OFF;
48 DELETE FROM t1 WHERE s1 = 2;
49
50 START TRANSACTION;
51 INSERT INTO t1 VALUES (2);
52 ROLLBACK;
53
54 START TRANSACTION;
55 INSERT INTO t1 VALUES (2);
56 ROLLBACK;
57
58 ================================================================================
59 CONNECTION 3: DELETE 3, ROLLBACK x 3
60 ================================================================================
61 connect con3, localhost, user3,,;
62 SET @@session.sql_log_bin=OFF;
63 DELETE FROM t1 WHERE s1 = 3;
64
65 START TRANSACTION;
66 INSERT INTO t1 VALUES (3);
67 ROLLBACK;
68
69 START TRANSACTION;
70 INSERT INTO t1 VALUES (3);
71 ROLLBACK;
72
73 START TRANSACTION;
74 INSERT INTO t1 VALUES (3);
75 ROLLBACK;
76
77 ================================================================================
78 CONNECTION DEFAULT: Gather results, compare session and global status counts
79 ================================================================================
80 connection default;
81 # Get thread ids for each connection.
82 USE performance_schema;
83 SELECT thread_id INTO @con1_id FROM threads WHERE processlist_user IN ('user1');
84 SELECT thread_id INTO @con2_id FROM threads WHERE processlist_user IN ('user2');
85 SELECT thread_id INTO @con3_id FROM threads WHERE processlist_user IN ('user3');
86 #=================
87 # Global results
88 #=================
89 USE test;
90 UPDATE test.status_results sr, performance_schema.global_status sg
91 SET sr.stop = sg.variable_value
92 WHERE sr.variable_name = sg.variable_name
93 AND sg.variable_name IN ('handler_delete', 'handler_rollback');
94
95 # Global deltas: END - START.
96 UPDATE test.status_results sr
97 SET sr.delta = sr.stop - sr.start;
98 #=================
99 # Status by thread
100 #=================
101 # Thread results from CON1.
102 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
103 SET sr.t1 = sbt.variable_value
104 WHERE sr.variable_name = sbt.variable_name
105 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
106 AND sbt.thread_id = @con1_id;
107
108 # Thread results from CON2.
109 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
110 SET sr.t2 = sbt.variable_value
111 WHERE sr.variable_name = sbt.variable_name
112 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
113 AND sbt.thread_id = @con2_id;
114
115 # Thread results from CON3.
116 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
117 SET sr.t3 = sbt.variable_value
118 WHERE sr.variable_name = sbt.variable_name
119 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
120 AND sbt.thread_id = @con3_id;
121
122 # Thread totals for 3 connections.
123 UPDATE test.status_results sr
124 SET sr.thread = sr.t1 + sr.t2 + sr.t3;
125 #=================
126 # Status by user
127 #=================
128 # User1
129 UPDATE test.status_results sr, performance_schema.status_by_user sbu
130 SET sr.u1 = sbu.variable_value
131 WHERE sr.variable_name = sbu.variable_name
132 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
133 AND sbu.user IN ('user1');
134
135 # User2
136 UPDATE test.status_results sr, performance_schema.status_by_user sbu
137 SET sr.u2 = sbu.variable_value
138 WHERE sr.variable_name = sbu.variable_name
139 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
140 AND sbu.user IN ('user2');
141
142 # User3
143 UPDATE test.status_results sr, performance_schema.status_by_user sbu
144 SET sr.u3 = sbu.variable_value
145 WHERE sr.variable_name = sbu.variable_name
146 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
147 AND sbu.user IN ('user3');
148
149 # Status totals for 3 users.
150 UPDATE test.status_results sr
151 SET sr.user = sr.u1 + sr.u2 + sr.u3;
152 #===========================
153 # Status by host (localhost)
154 #===========================
155
156 # host1 = localhost
157 UPDATE test.status_results sr, performance_schema.status_by_host sbh
158 SET sr.h1 = sbh.variable_value
159 WHERE sr.variable_name = sbh.variable_name
160 AND sbh.variable_name IN ('handler_delete', 'handler_rollback')
161 AND sbh.host IN ('localhost');
162
163 # Status totals for 'localhost' only.
164 UPDATE test.status_results sr
165 SET sr.host = sr.h1 + sr.h2 + sr.h3;
166 #==================
167 # Status by account
168 #==================
169 # User1@localhost
170 UPDATE test.status_results sr, performance_schema.status_by_account sba
171 SET sr.a1 = sba.variable_value
172 WHERE sr.variable_name = sba.variable_name
173 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
174 AND sba.user IN ('user1');
175
176 # User2@localhost
177 UPDATE test.status_results sr, performance_schema.status_by_account sba
178 SET sr.a2 = sba.variable_value
179 WHERE sr.variable_name = sba.variable_name
180 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
181 AND sba.user IN ('user2');
182
183 # User3@localhost
184 UPDATE test.status_results sr, performance_schema.status_by_account sba
185 SET sr.a3 = sba.variable_value
186 WHERE sr.variable_name = sba.variable_name
187 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
188 AND sba.user IN ('user3');
189
190
191 # Status totals for 3 accounts.
192 UPDATE test.status_results sr
193 SET sr.acct = sr.a1 + sr.a2 + sr.a3;
194
195 ================================================================================
196 TEST 1: STATUS_BY_THREAD: Verify expected status counts per thread (1,2,3)
197 ================================================================================
198 #
199 # Review per-thread status counts
200 #
201 USE performance_schema;
202 SELECT * FROM status_by_thread WHERE thread_id IN (@con1_id, @con2_id, @con3_id) AND variable_name IN ('handler_delete', 'handler_rollback') ORDER BY thread_id;
203 THREAD_ID VARIABLE_NAME VARIABLE_VALUE
204 thread_id Handler_delete 1
205 thread_id Handler_rollback 1
206 thread_id Handler_delete 2
207 thread_id Handler_rollback 2
208 thread_id Handler_delete 3
209 thread_id Handler_rollback 3
210 #
211 # Verify expected counts for 'handler_delete' per thread
212 #
213 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con1_id AND variable_name IN ('handler_delete');
214 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
215 connect_1 Handler_delete 1 OK
216
217 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con2_id AND variable_name IN ('handler_delete');
218 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
219 connnect_2 Handler_delete 2 OK
220
221 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con3_id AND variable_name IN ('handler_delete');
222 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
223 connnect_3 Handler_delete 3 OK
224 #
225 # STATUS_BY_THREAD vs. GLOBAL_STATUS
226 #
227 SELECT variable_name, t1, t2, t3, delta, thread, IF(thread=delta,'OK','ERROR') Expected
228 FROM test.status_results
229 ORDER BY variable_name;
230 variable_name t1 t2 t3 delta thread Expected
231 Handler_delete 1 2 3 6 6 OK
232 Handler_rollback 1 2 3 6 6 OK
233
234 ================================================================================
235 TEST 2: STATUS_BY_USER: Verify expected status counts per user (1,2,3)
236 ================================================================================
237 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete');
238 USER VARIABLE_NAME VARIABLE_VALUE Expected
239 user1 Handler_delete 1 OK
240
241 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete');
242 USER VARIABLE_NAME VARIABLE_VALUE Expected
243 user2 Handler_delete 2 OK
244
245 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete');
246 USER VARIABLE_NAME VARIABLE_VALUE Expected
247 user3 Handler_delete 3 OK
248 #
249 # STATUS_BY_USER vs. GLOBAL_STATUS
250 #
251 SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OK','ERROR') Expected
252 FROM test.status_results
253 ORDER BY variable_name;
254 variable_name u1 u2 u3 delta user Expected
255 Handler_delete 1 2 3 6 6 OK
256 Handler_rollback 1 2 3 6 6 OK
257
258 ================================================================================
259 TEST 3: STATUS_BY_ACCOUNT: Verify expected status counts per user, host (1,2,3)
260 ================================================================================
261 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete');
262 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
263 user1 localhost Handler_delete 1 OK
264
265 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete');
266 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
267 user2 localhost Handler_delete 2 OK
268
269 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete');
270 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
271 user3 localhost Handler_delete 3 OK
272 #
273 # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS
274 #
275 SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OK','ERROR') Expected
276 FROM test.status_results
277 ORDER BY variable_name;
278 variable_name a1 a2 a3 delta acct Expected
279 Handler_delete 1 2 3 6 6 OK
280 Handler_rollback 1 2 3 6 6 OK
281 ================================================================================
282 TEST 4: STATUS_BY_HOST: Verify expected status counts per host (6)
283 ================================================================================
284 SELECT *, IF (variable_value = 6,'OK','ERROR') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
285 HOST VARIABLE_NAME VARIABLE_VALUE Expected
286 localhost Handler_delete 6 OK
287 #
288 # STATUS_BY_HOST vs. GLOBAL_STATUS
289 #
290 # Special case: No way to isolate pre-existing 'localhost' activity, so
291 # just check global totals = sum(status_by_host).
292 #
293 SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OK','ERROR') Expected
294 FROM test.status_results
295 ORDER BY variable_name;
296 variable_name h1 h2 h3 delta host Expected
297 Handler_delete 6 0 0 6 6 OK
298 Handler_rollback 6 0 0 6 6 OK
299
300 ================================================================================
301 DISCONNECT ALL USERS AND RUN THE TESTS AGAIN. RESULTS SHOULD NOT CHANGE.
302 ================================================================================
303 connection default;
304 disconnect con1;
305 disconnect con2;
306 disconnect con3;
307
308 USE test;
309
310 # Clear results table, leave initial global_status counts
311 UPDATE test.status_results
312 SET stop=0, delta=0,
313 t1=0, t2=0, t3=0, thread=0,
314 u1=0, u2=0, u3=0, user=0,
315 h1=0, h2=0, h3=0, host=0,
316 a1=0, a2=0, a3=0, acct=0;
317
318 #=================
319 # Global results
320 #=================
321 USE test;
322 UPDATE test.status_results sr, performance_schema.global_status sg
323 SET sr.stop = sg.variable_value
324 WHERE sr.variable_name = sg.variable_name
325 AND sg.variable_name IN ('handler_delete', 'handler_rollback');
326
327 # Global deltas: END - START.
328 UPDATE test.status_results sr
329 SET sr.delta = sr.stop - sr.start;
330 #=================
331 # Status by thread
332 #=================
333 # Thread results from CON1.
334 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
335 SET sr.t1 = sbt.variable_value
336 WHERE sr.variable_name = sbt.variable_name
337 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
338 AND sbt.thread_id = @con1_id;
339
340 # Thread results from CON2.
341 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
342 SET sr.t2 = sbt.variable_value
343 WHERE sr.variable_name = sbt.variable_name
344 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
345 AND sbt.thread_id = @con2_id;
346
347 # Thread results from CON3.
348 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
349 SET sr.t3 = sbt.variable_value
350 WHERE sr.variable_name = sbt.variable_name
351 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
352 AND sbt.thread_id = @con3_id;
353
354 # Thread totals for 3 connections.
355 UPDATE test.status_results sr
356 SET sr.thread = sr.t1 + sr.t2 + sr.t3;
357 #=================
358 # Status by user
359 #=================
360 # User1
361 UPDATE test.status_results sr, performance_schema.status_by_user sbu
362 SET sr.u1 = sbu.variable_value
363 WHERE sr.variable_name = sbu.variable_name
364 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
365 AND sbu.user IN ('user1');
366
367 # User2
368 UPDATE test.status_results sr, performance_schema.status_by_user sbu
369 SET sr.u2 = sbu.variable_value
370 WHERE sr.variable_name = sbu.variable_name
371 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
372 AND sbu.user IN ('user2');
373
374 # User3
375 UPDATE test.status_results sr, performance_schema.status_by_user sbu
376 SET sr.u3 = sbu.variable_value
377 WHERE sr.variable_name = sbu.variable_name
378 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
379 AND sbu.user IN ('user3');
380
381 # Status totals for 3 users.
382 UPDATE test.status_results sr
383 SET sr.user = sr.u1 + sr.u2 + sr.u3;
384 #===========================
385 # Status by host (localhost)
386 #===========================
387
388 # host1 = localhost
389 UPDATE test.status_results sr, performance_schema.status_by_host sbh
390 SET sr.h1 = sbh.variable_value
391 WHERE sr.variable_name = sbh.variable_name
392 AND sbh.variable_name IN ('handler_delete', 'handler_rollback')
393 AND sbh.host IN ('localhost');
394
395 # Status totals for 'localhost' only.
396 UPDATE test.status_results sr
397 SET sr.host = sr.h1 + sr.h2 + sr.h3;
398 #==================
399 # Status by account
400 #==================
401 # User1@localhost
402 UPDATE test.status_results sr, performance_schema.status_by_account sba
403 SET sr.a1 = sba.variable_value
404 WHERE sr.variable_name = sba.variable_name
405 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
406 AND sba.user IN ('user1');
407
408 # User2@localhost
409 UPDATE test.status_results sr, performance_schema.status_by_account sba
410 SET sr.a2 = sba.variable_value
411 WHERE sr.variable_name = sba.variable_name
412 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
413 AND sba.user IN ('user2');
414
415 # User3@localhost
416 UPDATE test.status_results sr, performance_schema.status_by_account sba
417 SET sr.a3 = sba.variable_value
418 WHERE sr.variable_name = sba.variable_name
419 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
420 AND sba.user IN ('user3');
421
422
423 # Status totals for 3 accounts.
424 UPDATE test.status_results sr
425 SET sr.acct = sr.a1 + sr.a2 + sr.a3;
426 USE performance_schema;
427
428 ================================================================================
429 TEST X: STATUS_BY_THREAD: Connections are gone--nothing to verify.
430 ================================================================================
431
432 ================================================================================
433 TEST 5: STATUS_BY_USER: Verify expected status counts per user (1,2,3)
434 ================================================================================
435 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete');
436 USER VARIABLE_NAME VARIABLE_VALUE Expected
437 user1 Handler_delete 1 OK
438
439 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete');
440 USER VARIABLE_NAME VARIABLE_VALUE Expected
441 user2 Handler_delete 2 OK
442
443 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete');
444 USER VARIABLE_NAME VARIABLE_VALUE Expected
445 user3 Handler_delete 3 OK
446 #
447 # STATUS_BY_USER vs. GLOBAL_STATUS
448 #
449 SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OK','ERROR') Expected
450 FROM test.status_results
451 ORDER BY variable_name;
452 variable_name u1 u2 u3 delta user Expected
453 Handler_delete 1 2 3 6 6 OK
454 Handler_rollback 1 2 3 6 6 OK
455
456 ================================================================================
457 TEST 6: STATUS_BY_ACCOUNT: Verify expected status counts per user:host (1,2,3)
458 ================================================================================
459 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete');
460 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
461 user1 localhost Handler_delete 1 OK
462
463 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete');
464 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
465 user2 localhost Handler_delete 2 OK
466
467 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete');
468 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
469 user3 localhost Handler_delete 3 OK
470 #
471 # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS
472 #
473 SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OK','ERROR') Expected
474 FROM test.status_results
475 ORDER BY variable_name;
476 variable_name a1 a2 a3 delta acct Expected
477 Handler_delete 1 2 3 6 6 OK
478 Handler_rollback 1 2 3 6 6 OK
479 ================================================================================
480 TEST 7: STATUS_BY_HOST: Verify expected status counts per host (6)
481 ================================================================================
482 SELECT *, IF (variable_value = 6,'OK','ERROR') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
483 HOST VARIABLE_NAME VARIABLE_VALUE Expected
484 localhost Handler_delete 6 OK
485 #
486 # STATUS_BY_HOST vs. GLOBAL_STATUS
487 #
488 # Special case: No way to isolate pre-existing 'localhost' activity, so
489 # just check global totals = sum(status_by_host).
490 #
491 SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OK','ERROR') Expected
492 FROM test.status_results
493 ORDER BY variable_name;
494 variable_name h1 h2 h3 delta host Expected
495 Handler_delete 6 0 0 6 6 OK
496 Handler_rollback 6 0 0 6 6 OK
497 ================================================================================
498 TEST 8: FLUSH STATUS should clear account, host and user status
499 ================================================================================
500
501 FLUSH STATUS;
502
503 SELECT * FROM status_by_account WHERE user LIKE 'user%' AND variable_name IN ('handler_delete');
504 USER HOST VARIABLE_NAME VARIABLE_VALUE
505 user1 localhost Handler_delete 0
506 user2 localhost Handler_delete 0
507 user3 localhost Handler_delete 0
508
509 SELECT * FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
510 HOST VARIABLE_NAME VARIABLE_VALUE
511 localhost Handler_delete 0
512
513 SELECT * FROM status_by_user WHERE user LIKE 'user%' AND variable_name IN ('handler_delete');
514 USER VARIABLE_NAME VARIABLE_VALUE
515 user1 Handler_delete 0
516 user2 Handler_delete 0
517 user3 Handler_delete 0
518 ================================================================================
519 CLEANUP
520 ================================================================================
521 DROP TABLE test.t1;
522 DROP TABLE test.t2;
523 DROP TABLE test.t3;
524 DROP TABLE test.status_results;
525 DROP USER 'user1'@localhost;
526 DROP USER 'user2'@localhost;
527 DROP USER 'user3'@localhost;