Debian Codegraph @

mysql-test/suite/sysschema/t/fn_ps_is_consumer_enabled.test

raw
1 -- source include/not_embedded.inc
2 # Tests for sys schema
3 # Verify the sys.ps_is_consumer_enabled() function perfoms as expected
4
5 # Should be disabled by default
6 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'events_stages_history';
7 SELECT sys.ps_is_consumer_enabled('events_stages_history');
8
9 # Should be enabled by default
10 SELECT sys.ps_is_consumer_enabled('global_instrumentation');
11
12 #
13 # Check that hierarchy is properly reflected
14 #
15
16 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'events_stages_current';
17 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_history';
18
19 # Should still be disabled, as events_stages_current not enabled
20 SELECT sys.ps_is_consumer_enabled('events_stages_history');
21
22 UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_stages_current';
23
24 # Now it should be enabled
25 SELECT sys.ps_is_consumer_enabled('events_stages_history');
26
27 # Toggling global_instrumentation should disable all other consumers
28 UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name = 'global_instrumentation';
29
30 SELECT sys.ps_is_consumer_enabled('thread_instrumentation');
31 SELECT sys.ps_is_consumer_enabled('statements_digest');
32 SELECT sys.ps_is_consumer_enabled('events_stages_current');
33 SELECT sys.ps_is_consumer_enabled('events_stages_history');
34 SELECT sys.ps_is_consumer_enabled('events_stages_history_long');
35 SELECT sys.ps_is_consumer_enabled('events_statements_current');
36 SELECT sys.ps_is_consumer_enabled('events_statements_history');
37 SELECT sys.ps_is_consumer_enabled('events_statements_history_long');
38
39 --source ../include/ps_setup_consumers_cleanup.inc