MySQL Query Monitor monitors and records MySQL server availability and response time to execute user-defined queries. The SQL query to be considered to record server attributes is specified during monitor creation. This query is then executed for every poll cycle.
MySQL Query Monitor supports MySQL Server version 4.x and 5.x.
The following table lists the monitored attributes of a MySQL Query Monitor.
| Attribute | Description |
|---|---|
| Availability (%) | Availability of the monitored database. If connection and data transfer are successful, system returns 100%, otherwise it returns 0. |
| Connect Time (ms) | Time required by the database server to process login requests. |
| Response Time (ms) | Time required by the database server to execute a user-defined query (such as Select, Insert, Update) and respond. Response time includes time of login request (start) and time of response to query (end). |
| Value (#) | Value returned as response after executing the user query. |
Configuring a MySQL Query monitor
The following table describes the information required during configuration of the MySQL Query monitor.
| Configuration information | Description |
|---|---|
| Input fields on the Configuration tab | |
| Instance Name | Specify a name for the monitor instance. This is displayed on folders, graphs, lists, etc. |
| Tag | Specify tag value to search or group the objects. You can enter multiple name-value pairs, text, or include both (name-value pair and text). This gives you the option to group objects in different forms. Click icon + to select a default tag class. The Enter Tag Details screen opens. Select Tag Class from the drop-down list and enter a tag value, click Add to append tag class and value. Click Finish. The tag specified by you is not considered as a default class. You cannot enter special characters &"/<>' in the tag field.
|
| Source Agent | Select the name/IP address of the ProactiveAgent to host the new monitor instance. |
| Target Device | Specify the name/IP address of the machine where the MySQL database server is running. Specifying Host Name will not resolve to IP address and DNS lookup will be done in every stats poll. |
| Port | Specify the TCP Control port. Default port is 2638. |
| Database Name | Specify name of the database to be queried using the SQL statement. |
| User Name | Specify the user name to access the database. The user specified during monitor creation must have suitable privileges (on the system where the source agent is installed) to execute the SQL query. |
| monitor creation must have suitable privileges (on the system where the source agent is installed) to execute the SQL query. Go to http://dev.mysql.com/doc/refman/5.0/en/grant.html for more information about granting rights to MySQL user accounts. | |
| Password | Specify the password corresponding to the user name. |
| SQL Statement | Specify the query to be executed in each poll. |
| System-populated fields | |
| Monitor Version | Version of the installed BMC ProactiveNet Analytics monitor. |
| Control tab | |
| Collect Data | Select/clear check box to enable/disable data collection for the monitored component. By default, data collection is enabled (check box selected). |
| Retry Count | Specify the number of consecutive unsuccessful attempts for recording Zero availability for the poll. Default is 3. |
| Retry Delay | Specify the time interval between two consecutive attempts of a single poll. Default is 20 seconds. |
| Statistics Poll Interval | Specify the time interval between two consecutive Statistical data polls. Default is 5 minutes. |
| Statistics Poll Timeout | Specify the time-out period for each poll of statistical data. If no data is available at the end of this interval, system records Zero availability and proceeds with the next scheduled poll. Default is 20 seconds. |
| Group tab | |
| Group Membership | This allows you to add a device and its monitors to one or more groups. Optionally, you may associate the device with a group. A group is used to logically organize the devices and monitors by department, geographic area, or service. Assigning a device to a group also allows the system administrator to restrict or allow access to certain devices. To associate the device with a group, select the group name here.
|
Additional configuration and setup issues
The following table presents details about additional configuration and setup issues for the MySQL Query monitor.
| Issue | Details |
|---|---|
| Skip validation | Monitors can be created even when the target application/device is not running. Agent must be upgraded to 7.1 for creation of monitor using skip validation. This monitor allows forceful creation when the monitored target is not reachable or specified inputs are wrong. Click Yes on the Skip Validation confirmation message to forcefully create a monitor. Clicking No will fail the monitor creation. Forcefully creating the monitor when target is not reachable or with invalid input(s) may cause Availability to be set to 0. |
| Monitor configuration | No additional configuration requirements for this monitor. Maintain the default configuration of BMC ProactiveNet Analytics. |
| External setup | No external setup requirements for this monitor. |
| External dependencies | This monitor requires a licensed version of the MySQL JDBC driver. Go to http://www.mysql.com/products/connector/j/ for download and related information. Download the driver from the website and rename it as MySQL.jar and store a copy within the '<agent_install_dir>/pw/monitors/shared/apps3rdparty/jdbc' directory. Afterwards, restart ProactiveAgent. MySQL Query monitor is tested with MySQL JDBC driver my sql-connector-java-3.1.12-bin.jar. |
| ProactiveAgent dependencies | ProactiveAgent installation on the monitored host is not mandatory. Monitor instance can be created on any ProactiveAgent. The user specified during monitor creation must have suitable privileges (on the system where the source agent is installed) to execute the SQL query. Go to http://dev.mysql.com/doc/refman/5.0/en/grant.html for more information about granting rights to MySQL user accounts. |
Overview
Content Tools
Apps
Reporter Replacement
com.bmc.atlassian.bmc-util-plugin-2.section.label
Tasks