My Oracle Support Banner

The Sys Schema: Performance Schema Configuration (Doc ID 2040045.1)

Last updated on MARCH 21, 2019

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.


Learn how to use the sys schema to configure and see the current configuration of the Performance Schema.


Detailed general guidance for DBAs already familiar with the sys schema and Performance Schema seeking guidance how to use the sys schema to change the Performance Schema configuration and get the current settings.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Disable and Enable
 Background Threads
 Single Thread
 Reset To Default
 Save and Restore
 Save Current Settings
 Restore Settings
 Show Configuration
 ps_setup_show_disabled_consumers() / ps_setup_show_enabled_consumers()
 ps_is_instrument_default_enabled() / ps_is_instrument_default_timed()
 ps_setup_show_disabled_instruments() / ps_setup_show_enabled_instruments()

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.