Collects metrics from a MySQL database instance. See video walkthrough.
| OS | Linux | Windows | SmartOS | OS X |
|---|---|---|---|---|
| Supported | v | v | v | v |
- To install new meter go to Settings->Installation or see instructons.
- To upgrade the meter to the latest version - see instructons.
| Runtime | node.js | Python | Java |
|---|---|---|---|
| Required | + |
None
| Field Name | Description |
|---|---|
| Hostname | 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) |
| Source | The Source to display in the legend for the mysql data. It will default to the hostname of the server |
| Poll Interval | How often to poll for metrics |
| 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 |
- MySQL
Tracks the following metrics for mysql