|
AdventNet ManageEngine® Applications Manager |
||
|
Chapter 6.2.1 MySQL DB Servers |
||
The following versions of the MySQL DB Servers can be monitored by the Applications Manager:
MySQL 3.23.x
MySQL 4.x, 5.x
Availability tab, gives the Availability history for the past 24 hours or 30 days. Performance tab gives the Health Status and events for the past 24 hours or 30 days. List view enables you to perform bulk admin configurations. Click on the individual monitors listed, to view the following information.
| Parameter |
Description |
|---|---|
|
Name |
Denotes the name of MySQL server monitor. |
|
Health |
Denotes the health (Clear, Warning, Critical) of the MySQL server. |
|
Type |
Denotes the type you are monitoring. |
|
MySQL Version |
Specifies the version of the database server. |
|
Port |
Specifies the port number at which the database server is running. |
|
Base Directory |
Specifies the directory in which the database server is installed. |
|
Data Directory |
Specifies the directory in the hard disk of the system where the data for the database server is stored. |
|
Host Name |
Specifies the host at which the database server is running. |
|
Host OS |
Specifies the OS of the host where the database server is running. |
|
Last Alarm |
Specifies the last alarm that was generated for the database server. |
|
Last Polled at |
Specifies the time at which the last poll was performed. |
|
Next Poll at |
Specifies the time at which the next poll is scheduled. |
|
Availability |
Shows the current status of the server - available or not available. |
| Parameter |
Description |
|---|---|
|
Connection Time |
Specifies the time taken to connect to the database |
|
Request Rate |
Number of request received in one second. |
| Parameter |
Description |
|---|---|
|
Request Rate |
Number of request received in one second. |
|
Bytes Received Rate |
Number of bytes received in one second. |
|
Bytes Sent Rate |
Number of bytes sent in one second. |
| Parameter |
Description |
|---|---|
|
Open Connections |
The number of connections opened at present in the MySql Server. |
|
Aborted Connections |
Number of tries to connect to the MySQL server that failed. |
|
Aborted Clients |
Number of clients aborted by MySQL server. |
| Parameter |
Description |
|---|---|
|
Threads Used |
Number of threads processing the request. |
|
Threads in Cache |
Number of threads currently placed in the thread cache. |
|
Thread Cache Size |
Specifies the cache size in the MySQL server. |
| Parameter |
Description |
|---|---|
|
Database Name |
Name of the database instance. |
|
Database Size |
Size of the various databases in the MySQL server. |
| Parameter |
Description |
|---|---|
|
Immediate Locks |
Number of times a table lock for the table is acquired immediately. |
|
Locks Wait |
Number of times a table lock could not be acquired after waiting. |
| Parameter |
Description |
|---|---|
|
Key Hitrate |
Percentage of key read requests that resulted in actual key reads from the key buffer. |
|
Key Buffer Used |
Amount of allocated key buffer in use. |
|
Key Buffer Size |
Size of the buffer used for index blocks. Also known as the key cache. |
| Parameter |
Description |
|---|---|
|
Queries Inserted/Min |
No. of Insert Queries executed per minute |
|
Queries Deleted/Min |
No. of Delete Queries executed per minute |
|
Queries Updated/Min |
No. of Update Queries executed per minute |
| Queries Selected/Min | No. of Select Queries executed per minute |
Note: This performance data is not available for MySQL versions 3.23.x
| Parameter |
Description |
|---|---|
|
Query Cache Hitrate |
Ratio of queries that were cached and queries that were not cached. |
|
Query Cache Size |
Amount of memory allocated for caching query results. |
|
Query Cache Limit |
Maximum amount of memory for storing cache results. |
| Parameter |
Description |
|---|---|
|
Replication Status |
The status of Slave process in MySQL Server |
|
Slave IO Running |
Status of the Slave IO Process in MySQL Server. Possible values are Yes/No |
|
Slave SQL Running |
Status of the Slate SQL Process in MySQL Server.Possible values are Yes/N. |
| Last Error | The last error occured when Slave is synching the data from master. |
| Master Host | The hostname or IP number of the master replication server. |
| Master Port | The TCP/IP port number that the master is listening on |
| Master User | The username of the account that the slave thread uses for authentication when it connects to the master |
| Time Behind Master | This indicates of how “late” the slave is behind the Master |
Creating New Monitor - MySQL Database Server
|
Database Servers |
Oracle DB Servers |