Contributors netapp-alavoie dgracenetapp

Cloud Insights uses this data collector to gather metrics from MySQL.

Installation

  1. From Admin > Data Collectors, click +Data Collector. Under Services, choose MySQL.

    Select the Operating System or Platform on which the Telegraf agent is installed.

  2. If you haven’t already installed an Agent for collection, or you wish to install an Agent for a different Operating System or Platform, click Show Instructions to expand the Agent installation instructions.

  3. Select the Agent Access Key for use with this data collector. You can add a new Agent Access Key by clicking the + Agent Access Key button. Best practice: Use a different Agent Access Key only when you want to group data collectors, for example, by OS/Platform.

  4. Follow the configuration steps to configure the data collector. The instructions vary depending on the type of Operating System or Platform you are using to collect data.

MySQL Configuration

Setup

Information may be found in the MySQL documentation.

Objects and Counters

The following objects and their counters are collected:

Object: Identifiers: Attributes: Datapoints:

MySQL

Namespace
MySQL Server

Node IP
Node Name

Aborted Clients (per sec)
Aborted Connects (per sec)
RX Bytes (per sec)
TX Bytes (per sec)
Commands Admin (per sec)
Commands Alter Event
Commands Alter Function
Commands Alter Instance
Commands Alter Procedure
Commands Alter Server
Commands Alter Table
Commands Alter Tablespace
Commands Alter User
Commands Analyze
Commands Assign To Keycache
Commands Begin
Commands Binlog
Commands Call Procedure
Commands Change DB
Commands Change Master
Commands Change Repl Filter
Commands Check
Commands Checksum
Commands Commit
Commands Create DB
Commands Create Event
Commands Create Function
Commands Create Index
Commands Create Procedure
Commands Create Server
Commands Create Table
Commands Create Trigger
Commands Create UDF
Commands Create User
Commands Create View
Commands Dealloc SQL
Connection Errors Accept
Created Tmp Disk Tables
Delayed Errors
Flush Commands
Handler Commit
Innodb Buffer Pool Bytes Data
Key Blocks Not Flushed
Key Read Requests
Key Write Requests
Key Writes
Max Execution Time Exceeded
Max Used Connections
Open Files
Performance Schema Accounts Lost
Prepared Stmt Count
Qcache Free Blocks
Queries
Questions
Select Full Join
Select Full Range Join
Select Range Check
Select Scan
Table Locks Immediate

Troubleshooting

Additional information may be found from the Support page.