Mysql, Adding a mysql application monitor – H3C Technologies H3C Intelligent Management Center User Manual
Page 257
243
•
Database—Name of the running database in the SQL server when APM last polled the SQL server.
"_Total" indicates whole statistic for all databases.
•
Size—Disk space for the database.
•
Transactions—Number of transactions that the database started per minute.
•
Active Transactions—Number of active transactions of the database.
•
Log File—Disk space for the database log files.
•
Log Files Used—Size of used log files in the database.
•
Log Files Usage Ratio—Usage ratio of the log files in the database. Log Files Usage Ratio = Log Files
Used/Log Files *100%.
•
Log Writes—Times of writing the log to the log file per minute.
•
Log Write Waits—Number of the logs that were waiting to be written to the log files.
•
Log Write Wait Time—Calculated waiting time before the log was written to the log file.
•
Set Threshold—Click the Set Threshold icon
to set alarm thresholds for the log file usage ratio.
The data is highlighted in orange when the log file usage ratio reaches the level-1 threshold, and is
highlighted in red when the deadlocks reach the level-2 threshold. Use the global thresholds or
custom thresholds. For information about setting the thresholds, see "
•
More—Click More to view all database details.
MySQL
MySQL is an open source DBMS that directly impacts the service performance. So APM supports the
monitor function to MySQL.
APM can monitor MySQL 5.x.
Adding a MySQL application monitor
APM monitors the MySQL through the server port (3306 by default). When you add the application
monitors for MySQL, follow these guidelines:
•
Add MySQL hosts to the IMC platform so APM can obtain and display network connections of the
hosts and their access devices in the application topology. For more information about adding hosts
to the IMC platform, see H3C IMC Base Platform Administrator Guide.
•
Obtain the correct username and password of the user who has the MySQL administrator's
privileges.
•
To view traffic statistics in the monitor report of the MySQL application, make sure at least one
probe is configured in APM. After a MySQL application monitor is added, APM sends the IP
address and service port of the monitored MySQL application to the probes for traffic collection.
To add a My SQL application monitor:
1.
Click the Resource tab.
2.
Enter the Add Application page in one of the following ways:
{
Select Application Management > Add Application from the navigation tree.
The page displays all application types that can be monitored by APM.