MySQL

Use the following procedure for monitoring the MySQL database.

1. Navigate to Database monitoring on the left pane.
2. Select MySQL from the Select database type drop-down list.
3. Select a service from the Select service drop-down list.
4. Select a cluster from the Select cluster drop-down list.
5. Select a node from the Select node drop-down list.

The following screen appears along with the various available tabs.

• Database hardware
• Query performance
• Connections
• Metrics

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.