Debian Codegraph @

mysql-test/suite/sysschema/r/fn_ps_is_consumer_enabled.result

raw
1 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'events_stages_history';
2 SELECT sys.ps_is_consumer_enabled('events_stages_history');
3 sys.ps_is_consumer_enabled('events_stages_history')
4 NO
5 SELECT sys.ps_is_consumer_enabled('global_instrumentation');
6 sys.ps_is_consumer_enabled('global_instrumentation')
7 YES
8 SELECT sys.ps_is_consumer_enabled('events_stages_histONg');
9 ERROR HY000: Invalid argument error: events_stages_histONg in function sys.ps_is_consumer_enabled.
10 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'events_stages_current';
11 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_history';
12 SELECT sys.ps_is_consumer_enabled('events_stages_history');
13 sys.ps_is_consumer_enabled('events_stages_history')
14 NO
15 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_current';
16 SELECT sys.ps_is_consumer_enabled('events_stages_history');
17 sys.ps_is_consumer_enabled('events_stages_history')
18 YES
19 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'global_instrumentation';
20 SELECT sys.ps_is_consumer_enabled('thread_instrumentation');
21 sys.ps_is_consumer_enabled('thread_instrumentation')
22 NO
23 SELECT sys.ps_is_consumer_enabled('statements_digest');
24 sys.ps_is_consumer_enabled('statements_digest')
25 NO
26 SELECT sys.ps_is_consumer_enabled('events_stages_current');
27 sys.ps_is_consumer_enabled('events_stages_current')
28 NO
29 SELECT sys.ps_is_consumer_enabled('events_stages_history');
30 sys.ps_is_consumer_enabled('events_stages_history')
31 NO
32 SELECT sys.ps_is_consumer_enabled('events_stages_history_long');
33 sys.ps_is_consumer_enabled('events_stages_history_long')
34 NO
35 SELECT sys.ps_is_consumer_enabled('events_statements_current');
36 sys.ps_is_consumer_enabled('events_statements_current')
37 NO
38 SELECT sys.ps_is_consumer_enabled('events_statements_history');
39 sys.ps_is_consumer_enabled('events_statements_history')
40 NO
41 SELECT sys.ps_is_consumer_enabled('events_statements_history_long');
42 sys.ps_is_consumer_enabled('events_statements_history_long')
43 NO
44 UPDATE performance_schema.setup_consumers SET enabled = 'YES';