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 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'events_stages_current';
9 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_history';
10 SELECT sys.ps_is_consumer_enabled('events_stages_history');
11 sys.ps_is_consumer_enabled('events_stages_history')
12 NO
13 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_current';
14 SELECT sys.ps_is_consumer_enabled('events_stages_history');
15 sys.ps_is_consumer_enabled('events_stages_history')
16 YES
17 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'global_instrumentation';
18 SELECT sys.ps_is_consumer_enabled('thread_instrumentation');
19 sys.ps_is_consumer_enabled('thread_instrumentation')
20 NO
21 SELECT sys.ps_is_consumer_enabled('statements_digest');
22 sys.ps_is_consumer_enabled('statements_digest')
23 NO
24 SELECT sys.ps_is_consumer_enabled('events_stages_current');
25 sys.ps_is_consumer_enabled('events_stages_current')
26 NO
27 SELECT sys.ps_is_consumer_enabled('events_stages_history');
28 sys.ps_is_consumer_enabled('events_stages_history')
29 NO
30 SELECT sys.ps_is_consumer_enabled('events_stages_history_long');
31 sys.ps_is_consumer_enabled('events_stages_history_long')
32 NO
33 SELECT sys.ps_is_consumer_enabled('events_statements_current');
34 sys.ps_is_consumer_enabled('events_statements_current')
35 NO
36 SELECT sys.ps_is_consumer_enabled('events_statements_history');
37 sys.ps_is_consumer_enabled('events_statements_history')
38 NO
39 SELECT sys.ps_is_consumer_enabled('events_statements_history_long');
40 sys.ps_is_consumer_enabled('events_statements_history_long')
41 NO
42 UPDATE performance_schema.setup_consumers SET enabled = 'YES';