MySQL Status Metricsetedit

The 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 optionedit

Warning

This functionality is experimental and may be changed or removed completely in a future release. Elastic will take a best effort approach to fix any issues, but experimental features 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.

Fieldsedit

For 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"
}