MySQL Server

  • version: 2.3

  • Compatibility: v 7.6.4

  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collection Interval (Mandatory)

  • Operation: monitors the MySQL Server.

  • Change from Last version: Improved Security Vulnerabilities

  • Plugin-Metrics:

MySQL Server

MySQL Server


  • version: 2.2

  • Compatibility: v 7.5.3

  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collection Interval (Mandatory)

  • Operation: monitors the MySQL Server.

  • Plugin-Metrics:

MySQL Server

MySQL Server

Metric

Data Type

Installation Directory

String

Data Directory

String

UpTime

String

Version

String

System UpTime (Seconds)

Numeric

Aborted Clients

Numeric

Aborted Connections

Numeric

Received Bytes

Numeric

Received Bytes/sec

Numeric

Sent Bytes

Numeric

Sent Bytes/sec

Numeric

Connections

Numeric

Connections/sec

Numeric

MySQL Questions

Numeric

Connection Timeout (MS)

Numeric

Open Connections

Numeric

Delayed Errors

Numeric

Delayed Writes

Numeric

MySQL Flushes

Numeric

MySQL Flushes/sec

Numeric

Key Used Blocks

Numeric

Key Read Requests

Numeric

Key Reads

Numeric

Key Writes

Numeric

Key Write Requests

Numeric

Not Flushed Delayed Rows

Numeric

Deleted Rows

Numeric

Deleted Rows/sec

Numeric

Inserted Rows

Numeric

Inserted Rows/sec

Numeric

Read Rows From Fixed Position

Numeric

Next Row Read

Numeric

Previous Row Read

Numeric

Previous Row Read/sec

Numeric

Read First Row

Numeric

Read First Row/sec

Numeric

Read Keys

Numeric

Updated Rows

Numeric

Updated Rows/sec

Numeric

Delayed Insert Threads

Numeric

Slow Launch Threads

Numeric

Cached Threads

Numeric

Connected Threads

Numeric

Created Threads

Numeric

Running Threads

Numeric

Thread Cache size

Numeric

Open Tables

Numeric

Open Files

Numeric

Open Streams

Numeric

Select Full Joins

Numeric

Select Range

Numeric

Select Range Check

Numeric

Select Scans

Numeric

Slave Open Temp Tables

Numeric

Slow Queries

Numeric

Sort Merge Passes

Numeric

Sort Ranges

Numeric

Table Lock Waited

Numeric

Table Locks Immediate

Numeric

Created Temp Disk Tables

Numeric

Created Temp Files

Numeric

Created Temp Tables

Numeric

Query Cache Limit

Numeric

Query Cache Hits

Numeric

Query Cache Inserts

Numeric

Query Cache Hit Ratio (%)

Numeric

Key Buffer Size (KB)

Numeric

Used Key Blocks

Numeric

Key Hit Ratio (%)

Numeric

Admin Commands

Numeric

Analyze Commands

Numeric

Backup Tables Commands

Numeric

Change Database Commands

Numeric

Change Master Commands

Numeric

Check Commands

Numeric

Create Database Commands

Numeric

Drop Database Commands

Numeric

Flush Commands

Numeric

Grant Commands

Numeric

Kill Commands

Numeric

Optimize Commands

Numeric

Repair Commands

Numeric

Reset Commands

Numeric

Revoke Commands

Numeric

Alter Table Commands

Numeric

Create Function Commands

Numeric

Create Index Commands

Numeric

Create Table Commands

Numeric

Drop Function Commands

Numeric

Drop Index Commands

Numeric

Drop Table Commands

Numeric

Rename Table Commands

Numeric

Delete Multi Commands

Numeric

Handler Close Commands

Numeric

Handler Open Commands

Numeric

Handler Read Commands

Numeric

Master Data Commands

Numeric

Select Commands

Numeric

Set Option Commands

Numeric

Slave Start Commands

Numeric

Slave Stop Commands

Numeric

Delete Commands

Numeric

Insert Commands

Numeric

Insert Select Commands

Numeric

Load Commands

Numeric

Load Master Table Commands

Numeric

Purge Commands

Numeric

Replace Commands

Numeric

Replace Select Commands

Numeric

Restore Table Commands

Numeric

Truncate Commands

Numeric

Update Commands

Numeric

Show Binary logs Commands

Numeric

Show binary Log Events Commands

Numeric

Show Databases Commands

Numeric

Show Field Commands

Numeric

Show Rants Commands

Numeric

Show Keys Commands

Numeric

Show Engine Logs Commands

Numeric

Show Master Status Commands

Numeric

Show New Master Commands

Numeric

Show Open Tables Commands

Numeric

Show Processlist Commands

Numeric

Show Slave Hosts Commands

Numeric

Show Slave Status Commands

Numeric

Show Tables Commands

Numeric

Show Variables Commands

Numeric

Show Status Commands

Numeric

Begin Transactions Commands

Numeric

Commit Transactions Commands

Numeric

Lock Tables Commands

Numeric

Rollback Transactions Commands

Numeric

Unlock Tables Commands

Numeric

Buffer Pool Pages Data

Numeric

Buffer Pool Dirty Pages

Numeric

Buffer Pool Flush Page

Numeric

Buffer Pool Free Pages

Numeric

Buffer Pool Misc Pages

Numeric

Buffer Pool Pages

Numeric

Buffer Pool Reads Random Ahead

Numeric

Buffer Pool Sequential Reads

Numeric

Buffer Pool Read Requests

Numeric

Buffer Pool Reads

Numeric

Buffer Pool Wait Free

Numeric

Buffer Pool Write Requests

Numeric

Data Fsyncs

Numeric

Data Pending Fsyncs

Numeric

Data Pending Reads

Numeric

Data Pending Writes

Numeric

Data Reads

Numeric

Data Writes

Numeric

Data Written

Numeric

Double Write Written Pages

Numeric

Double Write Writes

Numeric

Log Waits

Numeric

Log Write Requests

Numeric

Log Writes

Numeric

OS Log Fsyncs

Numeric

OS Log Pending Fsyncs

Numeric

OS Log Pending Writes

Numeric

OS Log Written

Numeric

Page Size (KB)

Numeric

Created Pages

Numeric

Read Pages

Numeric

Innodb Written Pages

Numeric

Row Lock Current Waits

Numeric

Row Lock Time

Numeric

Average Row Lock Time

Numeric

Row Lock Waits

Numeric

Deleted Innodb Rows

Numeric

Inserted Innodb Rows

Numeric

Innodb Read Rows

Numeric

Innodb Updated Rows

Numeric

Sent Bytes/sec

Numeric

Key Read Requests/sec

Numeric

Key Write Requests/sec

Numeric

Key Writes/sec

Numeric

Key Reads/sec

Numeric

Select Commands/sec

Numeric

Delete Commands/sec

Numeric

Insert Commands/sec

Numeric

Update Commands/sec

Numeric

Commit Transactions Commands/sec

Numeric

Rollback Transactions Commands/sec

Numeric

Lock Tables Commands/sec

Numeric

Unlock Tables Commands/sec

Numeric

Begin Transactions Commands/sec

Numeric

Kill Commands/sec

Numeric

Buffer Pool Sequential Reads/sec

Numeric

Buffer Pool Read Requests/sec

Numeric

Buffer Pool Reads/sec

Numeric

Buffer Pool Write Requests/sec

Numeric

Data Reads/sec

Numeric

Data Writes/sec

Numeric

Deleted Innodb Rows/sec

Numeric

Inserted Innodb Rows/sec

Numeric

Read Rows/sec

Numeric

Updated Rows/sec

Numeric

Created Pages/sec

Numeric

Read Pages/sec

Numeric

Innodb Written Pages/sec

Numeric

Received Byte/sec

Numeric