summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test
blob: 507741f4d83487805c2f9fc46a120e4a062c65c7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
-- source include/not_embedded.inc
-- source include/have_innodb.inc


# Disable all but a few instruments (reduces output as well)
# It is not possible to disable memory/performance_schema/%
# so don't even try.
UPDATE performance_schema.setup_instruments
   SET ENABLED = 'NO'
 WHERE NAME NOT LIKE 'memory/performance_schema/%'
       AND NAME NOT LIKE 'stage/innodb/%'
       AND NAME NOT LIKE 'statement/com/%'
       AND NAME <> 'idle';

CALL sys.ps_setup_show_enabled_instruments();

# Clean up
-- source ../include/ps_setup_reset_to_default_cleanup.inc