MySQL DB Servers / MariaDB

Supported Versions

MySQL 3.23.x
MySQL 4.x, 4.1.x
MySQL 5.x, 5.1.x, 5.5.x, 5.6.x, 5.7.x
All Versions of MariaDB

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.

Top

<< Prev	Home	Next >>
Database Servers		Oracle DB Servers