Debian Codegraph @

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

raw
1
2 # Add to users to the setup_actors table: one enabled, and one disabled
3 INSERT INTO performance_schema.setup_actors
4 VALUES ('localhost', 'foo', '%', 'YES', 'YES'),
5 ('localhost', 'bar', '%', 'NO', 'NO');
6
7 # Disable a few instruments
8 UPDATE performance_schema.setup_instruments
9 SET ENABLED = 'NO'
10 WHERE NAME LIKE 'stage/innodb/%'
11 OR NAME LIKE 'statement/com/%'
12 OR NAME = 'idle';
13
14 # Disable the history_long consumers:
15 UPDATE performance_schema.setup_consumers
16 SET ENABLED = 'NO'
17 WHERE NAME LIKE '%\_history\_long';
18
19 # Disable some of the background threads:
20 UPDATE performance_schema.threads SET INSTRUMENTED = 'NO' WHERE NAME LIKE 'thread/innodb/srv\_%';
21
22 # Show limited info (no thread or instrument info)
23 CALL sys.ps_setup_show_disabled(FALSE, FALSE);
24
25 # Should show instrument data, but not thread info
26 CALL sys.ps_setup_show_disabled(TRUE, FALSE);
27
28 # Should show thread info, but no instrument data
29 CALL sys.ps_setup_show_disabled(FALSE, TRUE);
30
31 # Should show all info
32 CALL sys.ps_setup_show_disabled(TRUE, TRUE);
33
34 # Clean up
35 -- source ../include/ps_setup_reset_to_default_cleanup.inc