Debian Codegraph @

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

raw
1 select * from performance_schema.setup_consumers;
2 NAME ENABLED
3 events_stages_current YES
4 events_stages_history YES
5 events_stages_history_long YES
6 events_statements_cpu YES
7 events_statements_current YES
8 events_statements_history YES
9 events_statements_history_long YES
10 events_transactions_current YES
11 events_transactions_history YES
12 events_transactions_history_long YES
13 events_waits_current YES
14 events_waits_history YES
15 events_waits_history_long YES
16 global_instrumentation YES
17 thread_instrumentation YES
18 statements_digest YES
19 select * from performance_schema.setup_consumers
20 where name='events_waits_current';
21 NAME ENABLED
22 events_waits_current YES
23 select * from performance_schema.setup_consumers
24 where enabled='YES';
25 NAME ENABLED
26 events_stages_current YES
27 events_stages_history YES
28 events_stages_history_long YES
29 events_statements_cpu YES
30 events_statements_current YES
31 events_statements_history YES
32 events_statements_history_long YES
33 events_transactions_current YES
34 events_transactions_history YES
35 events_transactions_history_long YES
36 events_waits_current YES
37 events_waits_history YES
38 events_waits_history_long YES
39 global_instrumentation YES
40 thread_instrumentation YES
41 statements_digest YES
42 select * from performance_schema.setup_consumers
43 where enabled='NO';
44 NAME ENABLED
45 insert into performance_schema.setup_consumers
46 set name='FOO', enabled='YES';
47 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_consumers'
48 update performance_schema.setup_consumers
49 set name='FOO';
50 ERROR HY000: Invalid performance_schema usage.
51 update performance_schema.setup_consumers
52 set enabled='YES';
53 delete from performance_schema.setup_consumers;
54 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_consumers'
55 delete from performance_schema.setup_consumers
56 where name='events_waits_current';
57 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_consumers'
58 LOCK TABLES performance_schema.setup_consumers READ;
59 UNLOCK TABLES;
60 LOCK TABLES performance_schema.setup_consumers WRITE;
61 UNLOCK TABLES;