MySQL

Integration Installation

1. Install the Astradot Infra Agent on your server

2. Edit /etc/astradot-infra/integrations/mysql.toml

   #For every mysql instance to monitor, add an [[instance]] block
   [[instance]]
   host = "localhost"
   port = 3306
   database = "mysql"
   username = "user1"
   password = "xx"

3. Restart astradot-infra agent

   service astradot-infra restart

Metrics

Metric	Description
Max Available Connections	Maximum permitted number of simultaneous client connections
Max Used Connections	The maximum number of connections that have been in use simultaneously since the server started.
Aborted clients	The number of connections that were aborted because the client died without closing the connection properly
Aborted connects	The number of failed attempts to connect to the MySQL server
Innodb Data - Reads	Number of data reads (OS file reads)
Innodb Data - Writes	Number of data writes
Innodb Data - Fsyncs	Number of fsyncs
Innodb Data - Row Lock Waits	Number of times operations on InnoDB tables had to wait for a row lock
Innodb Buffer Pool - Dirty	Number of bytes held in dirty pages in the InnoDB buffer pool
Innodb Buffer Pool - Reads	Number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk
Innodb Buffer Pool - Read Requests	Number of logical read requests
Created Tmp Tables	Number of internal temporary tables created by the server while executing statements
Created Tmp Disk Tables	Number of internal on-disk temporary tables created by the server while executing statements
Created Tmp Files	Number of temporary files mysqld has created
Open Files	Number of files that are open. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. Also, the count does not include files that storage engines open using their own internal functions rather than asking the server level to do so.
Open Tables	Number of tables that are open
Network - Sent	Number of bytes sent over network
Network - Received	Number of bytes received over network
Threads - Connected	Number of currently open connections
Threads - Running	Number of threads that are not sleeping
Threads - Cached	Number of threads in the thread cache
Threads - Created	Rate of thread creation to handle connections
Queries	Rate of statements executed by the server. This includes statements executed within stored programs, unlike the Questions metric. It does not count COM_PING or COM_STATISTICS commands.
Questions	Rate of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries metric. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands.
Slow Queries	Rate of slow queries
Table Locks Waited	Number of times that a request for a table lock could not be granted immediately and a wait was needed
Commands - <statement>	Number of times each statement of type <statment> has been executed. 'Delete-Multi' and 'Update-Multi' specifically apply to DELETE and UPDATE statements that use multiple-table syntax.