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 SHOW GRANTS;
8 Grants for @localhost
9 GRANT USAGE ON *.* TO ''@'localhost'
10 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
11 ID USER HOST DB COMMAND TIME STATE INFO
12 SELECT * FROM performance_schema.processlist;
13 ID USER HOST DB COMMAND TIME STATE INFO
14 SHOW PROCESSLIST;
15 ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
16 SET @@global.performance_schema_show_processlist = ON;
17 SHOW GRANTS;
18 Grants for @localhost
19 GRANT USAGE ON *.* TO ''@'localhost'
20 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
21 ID USER HOST DB COMMAND TIME STATE INFO
22 SELECT * FROM performance_schema.processlist;
23 ID USER HOST DB COMMAND TIME STATE INFO
24 SHOW PROCESSLIST;
25 ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
26 GRANT PROCESS ON *.* TO ''@'localhost';
27 SET @@global.performance_schema_show_processlist = OFF;
28 SHOW GRANTS;
29 Grants for @localhost
30 GRANT PROCESS ON *.* TO ''@'localhost'
31 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
32 count(*) >= 2
33 1
34 SELECT count(*) >= 2 FROM performance_schema.processlist;
35 count(*) >= 2
36 1
37 SHOW PROCESSLIST;
38 SELECT "Previous statement is now completed." as status;
39 status
40 Previous statement is now completed.
41 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT as BROKEN_ROWS_SENT
42 FROM performance_schema.events_statements_history
43 WHERE SQL_TEXT = "SHOW PROCESSLIST";
44 EVENT_NAME SQL_TEXT BROKEN_ROWS_SENT
45 statement/sql/show_processlist SHOW PROCESSLIST 0
46 TRUNCATE TABLE performance_schema.events_statements_history;
47 set @@global.performance_schema_show_processlist = ON;
48 SHOW GRANTS;
49 Grants for @localhost
50 GRANT PROCESS ON *.* TO ''@'localhost'
51 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
52 count(*) >= 2
53 1
54 SELECT count(*) >= 2 FROM performance_schema.processlist;
55 count(*) >= 2
56 1
57 SHOW PROCESSLIST;
58 SELECT "Previous statement is now completed." as status;
59 status
60 Previous statement is now completed.
61 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT >= 2
62 FROM performance_schema.events_statements_history
63 WHERE SQL_TEXT = "SHOW PROCESSLIST";
64 EVENT_NAME SQL_TEXT ROWS_SENT >= 2
65 statement/sql/show_processlist SHOW PROCESSLIST 1
66 SET @@global.performance_schema_show_processlist = @save_processlist;