This plugin monitors local MySQL instances for performance statistics.
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.
To install the plugin
- 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.
|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|
|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|