MySQL plugin

This plugin

monitors local MySQL instances for performance statistics.

Prerequisites

User must have the appropriate privileges granted to connect remotely/locally.

TrueSight Meter version 4.5 or later must be installed.

The MySQLSummary plugin supports the following Operating Systems.

From the top right of the screen, perform one of the following actions:
- Click > Data Collection, select the TrueSight meter, and select the Sources tab.
- Click > Configure Sources.
Use the search box or scroll through the page to find the source system which has the TrueSight meter on which you want to install the plugin.
Click the name of the source to view source details.
Select the Plugins tab.
Use the search box or scroll through the page to find the plugin you want to install.
Click + Install to start the installation.
Refer to the following sections for the configuration details required to collect data and view the list of plugin metrics.

Field Name	Description
Host	The hostname of the MySQL Server (Socket Path or Hostname is required)
Port	Port to use when accessing the MySQL Server
Username	Username to access the MySQL database (Username is required)
Password	Password to access the MySQL database (Password is required)
Poll Interval	How often (in milliseconds) to poll for metrics
Source	The Source to display in the legend for the mysql data. It will default to the hostname of the server

Advanced configuration

To customize this plugin, see MySQL plugin on GitHub.

Metric Name	Description
MySQL Connections	The number of connection attempts
MySQL Aborted Connections	The number of failed connection attempts including those aborted by the client
MySQL Bytes In	bytes in
MySQL Bytes Out	bytes out
MySQL Slow Queries	The number of queries that have taken more than long_query_time seconds
MySQL Row Modification	The number of requests to insert/update/delete a row
MySQL Row Reads	The number of requests to read a row
MySQL Table Locks	The number of table locks granted
MySQL Table Wait Locks	The number of table locks that required a wait
MySQL Commits	The number commits
MySQL Rollback	The number rollbacks
MySQL Query Memory	The percentage of used query memory
MySQL Query Cache Hits	The percentage of queries from cache
MySQL Query Cache Prunes	The number of queries delete from the query cache