MySQL DB Servers

Introduction:

This section is common to all the editions of IT360, as per the below constraints;

Professional Edition
Enterprise Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]
MSP Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]

Supported Versions:

The following versions of the MySQL DB Servers can be monitored by IT360;

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:

Note: To view detailed performance metrics of a MySQL server, click the corresponding monitor listed in the Availability tab.

Monitor 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.

Connection Time:

Parameter	Description
Connection Time	Specifies the time taken to connect to the database.
Request Rate	Number of requests received in one second.

Requests Statistics:

Parameter	Description
Request Rate	Number of requests received in one second.
Bytes Received Rate	Number of bytes received in one second.
Bytes Sent Rate	Number of bytes sent in one second.

Top

Connection Statistics:

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 the MySQL server.

Thread Details:

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.

Database Details:

Parameter	Description
Database Name	Name of the database instance.
Database Size	Size of the various databases in the MySQL server.

Table Lock Statistics:

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.

Key Efficiency:

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 buffers, in use.
Key Buffer Size	Size of the buffer, used for index blocks. Also known as the key cache.

Query Statistics:

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.

Query Cache Hitrate:

Note: This performance data is not available for MySQL version 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.

Top

Replication Details:

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/No.
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. Refer the screenshots below;

There are two tabs in the History Data window - History Report and Global View. Refer the screenshots below;

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