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_current YES
7 events_statements_history YES
8 events_statements_history_long YES
9 events_transactions_current YES
10 events_transactions_history YES
11 events_transactions_history_long YES
12 events_waits_current YES
13 events_waits_history YES
14 events_waits_history_long YES
15 global_instrumentation YES
16 thread_instrumentation YES
17 statements_digest YES
18 select * from performance_schema.setup_consumers
19 where name='events_waits_current';
20 NAME ENABLED
21 events_waits_current YES
22 select * from performance_schema.setup_consumers
23 where enabled='YES';
24 NAME ENABLED
25 events_stages_current YES
26 events_stages_history YES
27 events_stages_history_long YES
28 events_statements_current YES
29 events_statements_history YES
30 events_statements_history_long YES
31 events_transactions_current YES
32 events_transactions_history YES
33 events_transactions_history_long YES
34 events_waits_current YES
35 events_waits_history YES
36 events_waits_history_long YES
37 global_instrumentation YES
38 thread_instrumentation YES
39 statements_digest YES
40 select * from performance_schema.setup_consumers
41 where enabled='NO';
42 NAME ENABLED
43 insert into performance_schema.setup_consumers
44 set name='FOO', enabled='YES';
45 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`setup_consumers`
46 update performance_schema.setup_consumers
47 set name='FOO';
48 ERROR HY000: Invalid performance_schema usage
49 update performance_schema.setup_consumers
50 set enabled='YES';
51 delete from performance_schema.setup_consumers;
52 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_consumers`
53 delete from performance_schema.setup_consumers
54 where name='events_waits_current';
55 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_consumers`
56 LOCK TABLES performance_schema.setup_consumers READ;
57 UNLOCK TABLES;
58 LOCK TABLES performance_schema.setup_consumers WRITE;
59 UNLOCK TABLES;
60 #
61 # MDEV-25325 column_comment for performance_schema tables
62 #
63 select column_name, column_comment
64 from information_schema.columns
65 where table_schema='performance_schema' and table_name='setup_consumers';
66 column_name column_comment
67 NAME Consumer name
68 ENABLED YES or NO for whether or not the consumer is enabled. You can modify this column to ensure that event information is added, or is not added.