Using the MySQL Proxy functionality built into MySQL Enterprise Agent. This is the method offered and supported since MySQL Enterprise Monitor 2.0.

When using the proxy, queries from the client application are directed through the proxy to the MySQL server, with all results from the MySQL server being returned from the proxy to the client application. While this transmission of information takes place, the proxy component keeps statistical information and supplies this information to MySQL Enterprise Service Manager for analysis.

The following figure shows the structure of this process in relation to the MySQL server containing the client application data, the client application, and the MySQL Enterprise Monitor components:

Figure 3.1. MySQL Enterprise Monitor Architecture using Query Analyzer with Proxy

For more information on using this method, see Section 3.1.5, “Using the Agent Proxy”.

Use a MySQL connector with a corresponding MySQL Enterprise Monitor Plugin that provides tracing and statistical information directly to MySQL Enterprise Service Manager.

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.

The following figure shows the structure of this solution:

Figure 3.2. MySQL Enterprise Monitor Architecture using Query Analyzer Directly from Connector

For more information on using this method, see the following table for information on which connectors support this method of operation.

Using a MySQL connector with a corresponding MySQL Enterprise Monitor Plugin that uses the aggregator functionality in MySQL Enterprise Agent to communicate information to MySQL Enterprise Service Manager.

Using the aggregator method, the MySQL Connector communicates raw statistical information about the queries and then sends this information to the MySQL Enterprise Agent, which aggregates the information into a format suitable for MySQL Enterprise Service Manager to perform the analysis and present the information.

Figure 3.3. MySQL Enterprise Monitor Architecture using Query Analyzer with Aggregator

For more information on using this method, see the following table for information on which connectors support this method of operation.