Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > MySQL Performance Schema configuration options

MySQL Performance Schema configuration options

Created by Anthony.Rinaldi_ret, last modified by MindTouch on Jun 23, 2016

Views: 58 Votes: 0 Revisions: 2

Overview

The following Advanced Options can be used to configure the MySQL Performance Schema:

  • MYSQL_PERFORMANCE_SCHEMA
  • MYSQL_PS_UPDATE_BEHAVIOR
  • MYSQL_PS_ACCESS_ALLOWED

Environment

  • All versions of DPA

Detail

MYSQL_PERFORMANCE_SCHEMA

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

  MySQL
Default
DPA
Recommended
Detailed Leave
MySQL
as it 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_PERFORMANCE_SCHEMA configuration scope are untouched. For example, an instrument named “stage” exists in the MySQL Performance Schema. If you enable or disable that instrument, DPA will not change it.

Notes:

  • The MySQL Performance Schema must be enabled.
  • If you select the Leave MySQL as it 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

While the previous option specifies what will be set in the performance schema, the MYSQL_PS_UPDATE_BEHAVIOR 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_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_PERFORMANCE_SCHEMA configuration scope are untouched.  For example, an instrument named “stage” exists in the MySQL 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_PERFORMANCE_SCHEMA configuration. This option does not disable any consumers or instruments.

MYSQL_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.

 

 

 

 

Last modified
19:16, 22 Jun 2016

Tags

Classifications

Public