- Metricbeat Reference: other versions:
- Overview
- Contributing to Beats
- Getting started with Metricbeat
- Setting up and running Metricbeat
- Upgrading Metricbeat
- How Metricbeat works
- Configuring Metricbeat
- Specify which modules to run
- Specify general settings
- Load external configuration files
- Configure the internal queue
- Configure the output
- Specify SSL settings
- Filter and enhance the exported data
- Parse logs by using ingest node
- Set up project paths
- Set up the Kibana endpoint
- Load the Kibana dashboards
- Load the Elasticsearch index template
- Set up logging
- Use environment variables in the configuration
- YAML tips and gotchas
- Regular expression support
- metricbeat.reference.yml
- Modules
- Aerospike module
- Apache module
- Ceph module
- Couchbase module
- Docker module
- Dropwizard module
- Elasticsearch module
- Golang module
- HAProxy module
- HTTP module
- Jolokia module
- Kafka module
- Kibana module
- Kubernetes module
- Kubernetes container metricset
- Kubernetes event metricset
- Kubernetes node metricset
- Kubernetes pod metricset
- Kubernetes state_container metricset
- Kubernetes state_deployment metricset
- Kubernetes state_node metricset
- Kubernetes state_pod metricset
- Kubernetes state_replicaset metricset
- Kubernetes system metricset
- Kubernetes volume metricset
- Memcached module
- MongoDB module
- MySQL module
- Nginx module
- PHP-FPM module
- PostgreSQL Module
- Prometheus module
- RabbitMQ module
- Redis module
- System module
- vSphere module
- Windows module
- ZooKeeper module
- Exported Fields
- Aerospike Fields
- Apache Fields
- Beat Fields
- Ceph Fields
- Cloud Provider Metadata Fields
- Common Fields
- Couchbase Fields
- docker Fields
- Docker Fields
- Dropwizard Fields
- Elasticsearch Fields
- Golang Fields
- HAProxy Fields
- HTTP Fields
- Jolokia Fields
- Kafka Fields
- Kibana Fields
- kubernetes Fields
- Kubernetes Fields
- Memcached Fields
- MongoDB Fields
- MySQL Fields
- Nginx Fields
- PHP-FPM Fields
- PostgreSQL Fields
- Prometheus Fields
- RabbitMQ Fields
- Redis Fields
- System Fields
- vSphere Fields
- Windows Fields
- ZooKeeper Fields
- Securing Metricbeat
- Troubleshooting
WARNING: Version 6.0 of Metricbeat has passed its EOL date.
This documentation is no longer being maintained and may be removed. If you are running this version, we strongly advise you to upgrade. For the latest information, see the current release documentation.
MySQL status metricset
editMySQL status metricset
editThe MySQL status metricset collects data from MySQL by running a
SHOW GLOBAL STATUS;
SQL query. This query returns a large number of metrics.
raw config option
editThis functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.
The MySQL Status Metricset supports the raw config option. When enabled, in
addition to the existing data structure, all fields available from the mysql
service through "SHOW /*!50002 GLOBAL */ STATUS;" will be added to the event.
These fields will be added under the namespace mysql.status.raw. The fields
can vary from one MySQL instance to an other and no guarantees are provided for
the mapping of the fields as the mapping happens dynamically. This option is
intended for advanced use cases.
Fields
editFor a description of each field in the metricset, see the exported fields section.
Here is an example document generated by this metricset:
{ "@timestamp": "2016-05-23T08:05:34.853Z", "beat": { "hostname": "host.example.com", "name": "host.example.com" }, "metricset": { "host": "mysql:3306", "module": "mysql", "name": "status", "rtt": 115 }, "mysql": { "status": { "aborted": { "clients": 4, "connects": 2 }, "binlog": { "cache": { "disk_use": 0, "use": 0 } }, "bytes": { "received": 992, "sent": 40657 }, "command": { "delete": 0, "insert": 0, "select": 9, "update": 0 }, "connections": 11, "created": { "tmp": { "disk_tables": 0, "files": 6, "tables": 0 } }, "delayed": { "errors": 0, "insert_threads": 0, "writes": 0 }, "flush_commands": 1, "max_used_connections": 3, "open": { "files": 14, "streams": 0, "tables": 103 }, "opened_tables": 110, "threads": { "cached": 0, "connected": 3, "created": 3, "running": 1 } } }, "type": "metricsets" }
On this page