My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

Purpose

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

Scope

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.

Details

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
Purpose
Scope
Details
 Disable and Enable
 Background Threads
 Consumers
 Instruments
 Single Thread
 Reset To Default
 Save and Restore
 Save Current Settings
 Restore Settings
 Show Configuration
 ps_setup_show_enabled()
 Accounts
 ps_is_account_enabled()
 Consumers
 ps_is_consumer_enabled()
 ps_setup_show_disabled_consumers() / ps_setup_show_enabled_consumers()
 Instruments
 ps_is_instrument_default_enabled() / ps_is_instrument_default_timed()
 ps_setup_show_disabled_instruments() / ps_setup_show_enabled_instruments()
 Threads
 ps_is_thread_instrumented()
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.