Debian Codegraph @

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

raw
1 ##
2 ## Test the Performance Schema-based implementation of SHOW PROCESSLIST.
3 ## Verify behavior for anonymous users and PROCESS_ACL.
4 ##
5 SELECT @@global.performance_schema_show_processlist INTO @save_processlist;
6 SET @@global.performance_schema_show_processlist = OFF;
7 Warnings:
8 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
9 SHOW GRANTS;
10 Grants for @localhost
11 GRANT USAGE ON *.* TO ``@`localhost`
12 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
13 ID USER HOST DB COMMAND TIME STATE INFO
14 Warnings:
15 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
16 SELECT * FROM performance_schema.processlist;
17 ID USER HOST DB COMMAND TIME STATE INFO EXECUTION_ENGINE
18 SHOW PROCESSLIST;
19 ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
20 SET @@global.performance_schema_show_processlist = ON;
21 Warnings:
22 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
23 SHOW GRANTS;
24 Grants for @localhost
25 GRANT USAGE ON *.* TO ``@`localhost`
26 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
27 ID USER HOST DB COMMAND TIME STATE INFO
28 Warnings:
29 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
30 SELECT * FROM performance_schema.processlist;
31 ID USER HOST DB COMMAND TIME STATE INFO EXECUTION_ENGINE
32 SHOW PROCESSLIST;
33 ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
34 GRANT PROCESS ON *.* TO ''@'localhost';
35 SET @@global.performance_schema_show_processlist = OFF;
36 Warnings:
37 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
38 SHOW GRANTS;
39 Grants for @localhost
40 GRANT PROCESS ON *.* TO ``@`localhost`
41 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
42 count(*) >= 2
43 1
44 Warnings:
45 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
46 SELECT count(*) >= 2 FROM performance_schema.processlist;
47 count(*) >= 2
48 1
49 SHOW PROCESSLIST;
50 SELECT "Previous statement is now completed." as status;
51 status
52 Previous statement is now completed.
53 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT as BROKEN_ROWS_SENT
54 FROM performance_schema.events_statements_history
55 WHERE SQL_TEXT = "SHOW PROCESSLIST";
56 EVENT_NAME SQL_TEXT BROKEN_ROWS_SENT
57 statement/sql/show_processlist SHOW PROCESSLIST 0
58 TRUNCATE TABLE performance_schema.events_statements_history;
59 set @@global.performance_schema_show_processlist = ON;
60 Warnings:
61 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
62 SHOW GRANTS;
63 Grants for @localhost
64 GRANT PROCESS ON *.* TO ``@`localhost`
65 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
66 count(*) >= 2
67 1
68 Warnings:
69 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
70 SELECT count(*) >= 2 FROM performance_schema.processlist;
71 count(*) >= 2
72 1
73 SHOW PROCESSLIST;
74 SELECT "Previous statement is now completed." as status;
75 status
76 Previous statement is now completed.
77 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT >= 2
78 FROM performance_schema.events_statements_history
79 WHERE SQL_TEXT = "SHOW PROCESSLIST";
80 EVENT_NAME SQL_TEXT ROWS_SENT >= 2
81 statement/sql/show_processlist SHOW PROCESSLIST 1
82 SET @@global.performance_schema_show_processlist = @save_processlist;
83 Warnings:
84 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.