This section describes the required configurations as well as the optional configurations available for the Solution Package for MySql Database in the RTView Configuration Application. You must define the classpath to the MySQL JDBC jar file and you must also define data source connections for each connection that you want to monitor. 

Configuring Data Connection

Use the RTView Configuration Application to configure your data collection.

• Navigate to Solution Package Configuration > MySQL Database from the list.

• On the CONNECTIONS tab, provide the correct full path to the directory containing the MySQL JDBC jar files in the Classpath field.
• In the Connections region, click the  icon.

The Add Connection dialog displays.

• Specify the connection information and click SAVE where:

Connection Name: Enter the desired name for the connection.

Database URL: Enter the complete URL for the database connection.

Username: The username is used when creating the connection to the database. This field is optional.

Password: This password is used when creating the connection to the database. This field is optional. By default, the password entered is hidden. Click the  icon to view the password text.

Select at least one: Select at least one of the following options for this connection:

Monitor Statistics: Enables monitoring of MySQL Statistics. If this is not selected the MySQL Statistics displays in the monitor will not contain data for this connection.

Monitor Tables: Enables monitoring of MySQL Tables. If this is not selected the MySQL Tables displays in the monitor will not contain data for this connection.

Monitor Properties: Enables monitoring of MySQL Properties. If this is not selected the MySQL Properties displays in the monitor will not contain data for this connection.

The newly created connection displays in the Connections section.

• You can optionally modify the Poll Rates (query interval, in seconds) that will be used to collect the metric data for the Poll Rate (MysqlServerPropertiesForDisplay cache) and the  Poll Rate Large (MysqlAborted, MysqlBytes, MysqlCRUD, MysqlUptime, MysqlThreads, MysqlQcache, MysqlQueries, MysqlSummaryTable, MysqlCreatedTemp, MysqlOpenedMetrics, MysqlTableLockMetrics, MysqlBinlogMetrics, MysqlConnection, MysqlSelectMetrics and MysqlTableStats caches) caches by clicking on the DATA COLLECTION tab and entering the desired polling rate for each cache.