ManageEngine® Applications Manager


MySQL DB Servers

<< Prev

Home

Next >>

MySQL DB Servers


Supported Versions

Monitored Parameters

The Availability tab gives the Availability history for the past 24 hours or 30 days. The Performance tab gives the health status and events for the past 24 hours or 30 days. The List view enables you to perform bulk admin configurations.

 

To view detailed performance metrics of a MySQL server, click the corresponding monitor listed in the Availability tab. These metrics are categorized into two different tabs for better understanding.


Overview

This tab provides information into the overall performance of the MySQL server.

 

Parameter

Description

Monitor Information

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.

Connection Time

Connection Time

Specifies the time taken to connect to the database

Connection Time Out

Specifies the maximum time taken by the application to connect to MySQL Server

Request Statistics

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.

Connection Statistics

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.

Thread Details

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.

Database Details

Database Name

Name of the database instance.

Database Size

Size of the various databases in the MySQL server.

Table Lock Statistics

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.

Key Efficiency

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.

Query Statistics

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
Query Cache Hitrate (This performance data is not available for MySQL versions 3.23.x)

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.

Replication Details

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

 

Configuration

This tab provides information about the system variables maintained by the MySQL server. These system variables indicate how the server is configured.

 

You can also view realtime and historical data of any of the attributes present in the 'Configuration Information' section in the Configuration tab. Click on any attribute under the Configuration tab. This will open up a new window named 'History Data' that provides more information about these attributes.

There are two tabs in the History Data window - History Report and Global View.

History Report: This tab provides historical reports of the attribute selected based on the time period chosen. You can also use the Select Attribute drop-down box and view reports for other attributes.

Global View: This tab displays the current values of the attribute selected, across multiple monitors. To view information about other attributes present in the monitor, use the Select Attribute drop-down box and change the attribute.

If you want to view data of multiple attributes, click the Customize Columns link present at the top left corner of the window. This will take you to the Edit Global View screen. In this screen, you can change the monitor type using the Filter by Monitor Type drop-down box, select the metrics to be displayed, and show monitors on a monitor basis or a monitor group basis. After you select your options, click the Show Report button to view those information in the Global View tab.

 

The View Process List option present on the right side under the Show Status section gives you information on the current threads that are running in the MySQL server.

 

See Also

Creating New Monitor - MySQL Database Server

Top

 

 

<< Prev

Home

Next >>

Database Servers

Oracle DB Servers