MySQL Query component fields

You may configure the following boxes for the MySQL Query component:

• Name. Enter a unique name for the component.
• Description. (Optional) Enter additional information about the component.
• Critical. Click to select this check box if the component is critical.

  Note: Components specified as critical cause the application to go into a down state when the component is out of threshold. Non-critical components cause the application to go into a warning state. For more information on application states, see Working with application states.

• Polling frequency. Select a time (in minutes or hours) you want APM to wait between polls.
• Server Address. Enter in ServerName format (for example, WUGServer).

  Important: To use the SQL Query monitor to monitor a MySQL database, you must first download and install the MySQL .NET Connector on the WhatsUp Gold machine. Note that only MySQL version 5.2.5 .NET Connector is supported due to compatibility issues. The connector is located on the WhatsUp Gold website (http://www.whatsupgold.com/MySQL525Connector). This link downloads the mysql-connector-net-5.2.5.zip file. After the file downloads, extract the MySQL.Data.msi and run the MySQL Connector setup utility by double-clicking on the MySQL.Data.msi icon. On the Choose Setup Type dialog, select Typical, then click Install. The MySQL .NET Connector is installed in the following location: C:\Program Files\MySQL\MySQL Connector Net 5.2.5\. After the .NET Connector has been installed, restart the WhatsUp Gold machine.

• Port Number. Enter the database server port number if other than the standard database port number.
• Polling timeout. Enter the length of time APM attempts to connect to the selected device. When the time you enter is exceeded without connecting, a timeout occurs and APM stops trying to connect to the device. This is considered a failed connection.
• Query to Run. Enter a query you want to run against a database to monitor and check for certain database conditions. Only SQL SELECT queries are allowed.

  Important: Make sure that you include the full database name in your query.

• Warning threshold. Enter the component thresholds for the warning state. For example, if the component value is greater than 90 for 5 minutes, put the component in the warning state.
• Down threshold. Enter the component thresholds for the down state. For example, if the component value is greater than 95 for 5 minutes, put the component in the down state.