Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > No metric data for MySQL

No metric data for MySQL

Created by Melanie Boyd, last modified by Melanie Boyd on Oct 20, 2017

Views: 873 Votes: 0 Revisions: 4

Overview

If DPA does not show metric data for a MySQL database instance, we recommend enabling the following settings to optimize SolarWinds DPA’s reporting capabilities.

Environment

 

  • DPA 10.0 and later
  • MySQL 5.6 and later

Cause 

  • For MySQL 5.6, the MySQL Performance Schema must be enabled
  • For MySQL 5.7.6 and later, Compatibility Mode must be enabled

Resolution

For MySQL 5.6, enable the MySQL Performance Schema

If the monitored database instance is version 5.6, we recommend enabling the MySQL Performance Schema. If the Performance Schema is not enabled, SolarWinds DPA can provide very limited data.

The Performance Schema must be enabled at server startup. In MySQL versions 5.6.6 and later, the Performance Schema is enabled by default. For information about verifying availability and enabling the Performance Schema, see the MySQL documentation.

For MySQL 5.7.6 and later, enable Compatibility Mode

If the monitored database instance is version 5.7.6 or higher, we recommend turning on the show_compatibilty_56 system variable to enable 5.6 compatibility mode.

If:

DPA can collect:

Compatibility mode is enabled

All metrics

Compatibility mode is not enabled;
Performance Schema is enabled

All metrics except the following:

  • Selects
  • Inserts
  • Updates
  • Deletes

Compatibility mode is not enabled;
Performance Schema is not enabled

No metrics

To see what the current mode is and to change the mode, execute the following statements against the MySQL instance:

       select @@show_compatibility_56;
       set GLOBAL show_compatibility_56=1;  -- turns 5.6 compatibility on

 

 

Last modified

Tags

Classifications

Public