New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« galera status MetricSet Nginx module »
Elastic Docs ›Metricbeat Reference [6.4] ›Modules ›MySQL module

MySQL status metricset

edit

MySQL status metricset

edit

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 option

edit

This 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

edit

For a description of each field in the metricset, see the exported fields section.

Here is an example document generated by this metricset:

{
    "@timestamp": "2017-10-12T08: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": 1,
                "connects": 82
            },
            "binlog": {
                "cache": {
                    "disk_use": 0,
                    "use": 0
                }
            },
            "bytes": {
                "received": 572,
                "sent": 26728
            },
            "command": {
                "delete": 0,
                "insert": 0,
                "select": 4,
                "update": 0
            },
            "connections": 88,
            "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": 101
            },
            "opened_tables": 108,
            "threads": {
                "cached": 0,
                "connected": 3,
                "created": 3,
                "running": 1
            }
        }
    }
}
« galera status MetricSet Nginx module »

On this page

Was this helpful?
Feedback