Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

No metric data for MySQL

Created by Melanie Boyd, last modified by MindTouch on Jun 23, 2016

Views: 11 Votes: 0 Revisions: 3

Overview

If DPA does not show metric data for a MySQL database instance and metric data, 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
19:16, 22 Jun 2016

Tags

Classifications

Public