The MySQL Query Analyzer can be fed information from a number of different sources. The provider supplies the statistical information about the queries, execution times, result counts and other data to display and analyze on the Query Analyzer page.
There are a number of different methods available for supplying query information to MySQL Enterprise Service Manager:
Using the Performance Schema statement digests with MySQL Server 5.6.14 and above, data can be gathered directly from MySQL Server without requiring additional configuring. Simply point a MySQL Enterprise Monitor Agent at the MySQL Server, and Query Analyzer information will be available to MySQL Enterprise Service Manager.
Enabling the connector plugin will gather additional information.
Using this method requires a connector that is capable of collecting and sending the query statistical data directly to MySQL Enterprise Service Manager. The connectors handles all of the collection of the basic query statistics, such as the execution time for each query, and the row counts, and provides this information to MySQL Enterprise Service Manager for analysis. This solution negates the need the proxy component, providing you with maximum speed between your application, connector and MySQL server containing your client application data.
Using the MySQL Enterprise Monitor Proxy and Aggregator For more information, see Chapter 11, Proxy and Aggregator Installation