Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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: 704 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