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.

Linux(tick)
Windows(tick)
OS X(tick)

To install the plugin

  1. From the top right of the screen, perform one of the following actions:
    • Click Settings > Data Collection, select the TrueSight meter, and select the Sources tab.

    • Click Settings > Configure Sources.
  2. 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.
  3. Click the name of the source to view source details.
  4. Select the Plugins tab.
  5. Use the search box or scroll through the page to find the plugin you want to install.
  6. 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.

Configuration details

Field NameDescription
HostThe hostname of the MySQL Server (Socket Path or Hostname is required)
PortPort to use when accessing the MySQL Server
UsernameUsername to access the MySQL database (Username is required)
PasswordPassword to access the MySQL database (Password is required)
Poll IntervalHow often (in milliseconds) to poll for metrics
SourceThe 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.

Plugin metrics

Metric NameDescription
MySQL ConnectionsThe number of connection attempts
MySQL Aborted ConnectionsThe number of failed connection attempts including those aborted by the client
MySQL Bytes Inbytes in
MySQL Bytes Outbytes out
MySQL Slow QueriesThe number of queries that have taken more than long_query_time seconds
MySQL Row ModificationThe number of requests to insert/update/delete a row
MySQL Row ReadsThe number of requests to read a row
MySQL Table LocksThe number of table locks granted
MySQL Table Wait LocksThe number of table locks that required a wait
MySQL CommitsThe number commits
MySQL RollbackThe number rollbacks
MySQL Query MemoryThe percentage of used query memory
MySQL Query Cache HitsThe percentage of queries from cache
MySQL Query Cache PrunesThe number of queries delete from the query cache
Was this page helpful? Yes No Submitting... Thank you

Comments