MySQL
Use the following procedure for monitoring the MySQL database.
- Navigate to Database monitoring on the left pane.
- Select MySQL from the Select database type drop-down list.
- Select a service from the Select service drop-down list.
- Select a cluster from the Select cluster drop-down list.
- Select a node from the Select node drop-down list.
The following screen appears along with the various available tabs.
Database hardware
The Database hardware tab is selected by default. The following widgets are displayed.
| Widget Name | Description |
|---|---|
| Host disk usage | Disk usage of the host machine where the DB server is running |
| CPU usage | Percentage CPU usage of the DB server in the host machine(Value is zero if the connection is remote or is installed in docker container) |
| Memory usage | Total memory allocated (being used) by DB server |
| Network I/O | Total bytes received and sent by DB server(represented in MB) |
| Total read & write | No of times DB server read and written from the files (count value) |
| Total bytes written & read | Total bytes written and read by DB server (represented in bytes) |
Query performance
Clicking the Query Performance tab and selecting the threshold from the Query threshold drop-down list displays the following screen.
note
You can download the Query Performance table in PDF format by clicking the 
icon. Only the top 100 entries are downloaded if there are more than 100 entries for downloading.
Connections
Clicking the Connections tab displays the following widgets as in the following screen.
| Widget Name | Description |
|---|---|
| Total threads connected | Represents the total connections to the DB server (Count) |
| Total threads running | Represents the total active connections to the DB server (Count) |
| Session details | Details of all unique users, number of queries the user is currently running, and last active time of the user |
Metrics
Clicking the Metrics tab displays the following widgets.
| Widget Name | Description |
|---|---|
| Inno DB buffer pool pages data | This widget is a graph widget which displays the Inno DB buffer pool pages of the selected node. |
| Inno DB buffer pool pages free | This widget is a graph widget which displays the Inno DB buffer pool pages freed from memory of the selected node. |
| Inno DB row lock current waits | This widget is a graph widget which displays the Inno DB row lock current waits of the selected node. |
| Inno DB row lock time average | This widget is a graph widget which displays the Inno DB row lock time average of the selected node. |
| Inno DB row lock waits per second | This widget is a graph widget which displays the Inno DB row lock waits per second of the selected node. |
| Total open files | This widget is a graph widget which displays the total open files of the selected node. |
| Total open tables | This widget is a graph widget which displays the total open tables of the selected node. |
| Table locks waited per second | This widget is a graph widget which displays the number of times per second that queries had to wait for a table lock to be released before they could proceed. |
| Max connection errors per second | This widget is a graph widget which displays the maximum connection errors per second of the selected node. |
| Max used connections | This widget is a graph widget which displays the maximum connections used of the selected node. |
| Insert queries per second | This widget is a graph widget which displays the inserted queries per second of the selected node. |
| Select queries per second | This widget is a graph widget which displays the selected queries per second of the selected node. |
| Prepared stmt count per second | This widget is a graph widget which displays the prepared statement count per second of the selected node. |
| Queries per second | This widget is a graph widget which displays the queries per second of the selected node. |
| Slow queries per second | This widget is a graph widget which displays the slow queries per second of the selected node. |
| Total threads connected | This widget is a graph widget which displays the total threads connected of the selected node. |
| Total threads running | This widget is a graph widget which displays the total threads running of the selected node. |