7.1 Providing Query Analyzer Data

7.1.1 Using the MySQL Performance Schema
7.1.2 Using the MySQL Enterprise Plugin for Connector/J
7.1.3 Using the MySQL Enterprise Plugin for Connector/PHP
7.1.4 Using the MySQL Enterprise Plugin for Connector/Net
7.1.5 Using the 2.3 MySQL Enterprise Agent Aggregator
7.1.6 Using the 2.3 Agent Proxy

The MySQL Query Analyzer can be fed information from a number of different sources, in each case with the provider supplying the statistical information about the queries, execution times, result counts and other data to be displayed and analyzed with the Query Analyzer tab within MySQL Enterprise Monitor User Interface.

There are a number of different methods available for supplying query information to MySQL Enterprise Service Manager:

Note

The minimum Agent version that can report Query Analyzer data is 2.3, although version 3.x is recommended.

Different connectors support either the direct and aggregator methods of supplying statistical information through a plugin that provides the necessary code to communicate either directly with MySQL Enterprise Service Manager, or indirectly through the MySQL Enterprise Monitor Agent aggregator. The following table provides information on which connectors support the different functionality types.

Table 7.1 Query Analyzer Feeding Solution Comparison

FeatureC/JavaC/NETC/PHPPerformance SchemaProxy
Uses AggregatorNoNoYesNoNo
Uses ProxyNoNoNoNoYes
Supports EXPLAINYesYesNoYesYes