summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test')
-rw-r--r--mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test b/mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test
new file mode 100644
index 00000000000..507741f4d83
--- /dev/null
+++ b/mysql-test/suite/sysschema/t/pr_ps_setup_show_enabled_instruments.test
@@ -0,0 +1,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