Database Management

MySQL and MariaDB Performance Schema configuration options

The following Advanced Options can be used to configure the MySQL or MariaDB Performance Schema: MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA, MYSQL_OR_MARIADB_PS_UPDATE_BEHAVIOR, and MYSQL_OR_MARIADB_PS_ACCESS_ALLOWED.

First published date

10/22/2018 10:58 AM

Last published date

11/12/2025 11:34 PM

Overview

The following Advanced Options can be used to configure the MySQL Performance Schema or the MariaDB Performance Schema. Note that the names changed in DPA 2024.4 to reflect that they also affect MariaDB.

DPA 2024.3 and earlier	DPA 2024.4 and later
MYSQL_PERFORMANCE_SCHEMA	MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA
MYSQL_PS_UPDATE_BEHAVIOR	MYSQL_OR_MARIADB_PS_UPDATE_BEHAVIOR
MYSQL_PS_ACCESS_ALLOWED	MYSQL_OR_MARIADB_PS_ACCESS_ALLOWED

Product section

Database Performance Analyzer

Resolution

MYSQL_PERFORMANCE_SCHEMA or MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA

Select one of the following options to specify what data the MySQL or MariaDB Performance Schema collects and maintains. The table below shows which consumers and instruments each option enables.

	Server Default	DPA Recommended	Detailed	Leave As Is
Consumer Global Instrumentation	✔	✔	✔	NC
Consumer Thread Instrumentation	✔	✔	✔	NC
Consumer Statement Digest	✔	✔	✔	NC
Consumer Statement (current)	✔	✔	✔	NC
Consumer Wait (current)		✔	✔	NC
Instrument Wait (Lock/*)		✔	✔	NC
Instrument Wait (I/O/table) (I/O/file)		✔	✔	NC
Instrument Wait (I/O/socket)		✔	✔	NC
Instrument Wait (Synch/*)			✔	NC

✔ = Enabled.

NC = No change. SolarWinds DPA does not change the existing Performance Schema configuration.

* Values that are outside of DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration scope are untouched. For example, an instrument named “stage” exists in the MySQL or MariaDB Performance Schema. If you enable or disable that instrument, DPA will not change it.

Notes:

The MySQL or MariaDB Performance Schema must be enabled.
If you select the Leave As Is option, verify that Global Instrumentation and Thread Instrumentation are enabled in the existing Performance Schema configuration. Disabling these instruments has the same effect as disabling the Performance Schema.

MYSQL_PS_UPDATE_BEHAVIOR or MYSQL_OR_MARIADB_PS_UPDATE_BEHAVIOR

While the previous option specifies what will be set in the performance schema, this option’s setting determines how that configuration option will be applied.

Option	Description
Replace Existing Configuration	Updates the Performance Schema to reflect the settings specified in DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration. If a consumer or an instrument is enabled in the user’s Performance Schema but disabled in DPA’s configuration, this option disables the consumer or instrument. Note: Values that are outside of DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration scope are untouched. For example, an instrument named “stage” exists in the MySQL or MariaDB performance schema. If a customer enabled or disabled that instrument, DPA will not change it.
Add to Existing Configuration	Enables all consumers and instruments that are enabled in DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration. This option does not disable any consumers or instruments.

Option

Description

Replace Existing Configuration

Updates the Performance Schema to reflect the settings specified in DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration. If a consumer or an instrument is enabled in the user’s Performance Schema but disabled in DPA’s configuration, this option disables the consumer or instrument.

Note: Values that are outside of DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration scope are untouched. For example, an instrument named “stage” exists in the MySQL or MariaDB performance schema. If a customer enabled or disabled that instrument, DPA will not change it.

Add to Existing Configuration

Enables all consumers and instruments that are enabled in DPA’s MYSQL_OR_MARIADB_PERFORMANCE_SCHEMA configuration. This option does not disable any consumers or instruments.

MYSQL_PS_ACCESS_ALLOWED or MYSQL_OR_MARIADB_PS_ACCESS_ALLOWED

This option specifies whether SolarWinds DPA can access data collected by the Performance Schema. The default value is True.

If this option is set to False, DPA will not be able to access Performance Schema data. Setting this option to False has the same effect as disabling the Performance Schema.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.