MySQL Module

edit

This module periodically fetches metrics from MySQL servers.

Module-Specific Configuration Notes

edit

When configuring the hosts option, you must use a MySQL Data Source Name (DSN) of the following format:

[username[:password]@][protocol[(address)]]/

Compatibility

edit

The mysql MetricSets were tested with mysql 5.7.12 and are expected to work with all versions >= 5.7.0.

Example Configuration

edit

The MySQL module supports the standard configuration options that are described in Modules Configuration. Here is an example configuration:

metricbeat.modules:
- module: mysql
  metricsets: ["status"]
  enabled: true
  period: 10s

  # Host DSN should be defined as "tcp(127.0.0.1:3306)/"
  # The username and password can either be set in the DSN or for all hosts in username and password config option
  hosts: ["root@tcp(127.0.0.1:3306)/"]

Metricsets

edit

The following metricsets are available: