New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
« galera 状态指标集 MySQL 查询指标集 »
Elastic 文档 ›Metricbeat 参考 [8.17] ›模块 ›MySQL 模块

MySQL 性能指标集

编辑

MySQL 性能指标集

编辑

此功能为 Beta 版，可能会发生更改。其设计和代码不如正式 GA 功能成熟，按“原样”提供，不提供任何保证。Beta 功能不受正式 GA 功能的支持 SLA 约束。

performance 指标集从 MySQL 获取与性能相关的指标（事件语句和表 IO 等待）。

字段

有关指标集中每个字段的描述，请参阅导出的字段部分。

以下是此指标集生成的示例文档

{
    "@timestamp": "2024-02-27T07:33:02.881Z",
    "@metadata": {
        "beat": "metricbeat",
        "type": "_doc",
        "version": "8.14.0"
    },
    "mysql": {
        "performance": {
            "events_statements": {
                "digest": {
                    "text": "SHOW SCHEMAS"
                },
                "count": {
                    "star": 5
                },
                "avg": {
                    "timer": {
                        "wait": 1.6439131e+10
                    }
                },
                "max": {
                    "timer": {
                        "wait": 4.0834164e+10
                    }
                },
                "last": {
                    "seen": "2024-02-27 06:44:17.296246"
                },
                "quantile": {
                    "95": 4.1686938347e+10
                },
                "schemaname": "performance_schema"
            }
        }
    },
    "host": {
        "id": "41359f29035549cda159ae8d1a533d72",
        "containerized": false,
        "ip": [
            "127.0.0.1"
        ],
        "name": "localhost",
        "mac": [
            "86-32-76-45-EB-2B"
        ],
        "hostname": "localhost",
        "architecture": "x86_64",
        "os": {
            "name": "CentOS Linux",
            "kernel": "3.10.0-1160.102.1.el7.x86_64",
            "codename": "Core",
            "type": "linux",
            "platform": "centos",
            "version": "7 (Core)",
            "family": "redhat"
        }
    },
    "agent": {
        "type": "metricbeat",
        "version": "8.14.0",
        "ephemeral_id": "539a163b-91ab-433c-9893-31a48d09b5a7",
        "id": "e5bcfbf0-4c74-44dd-b711-c5e90a69ab7a",
        "name": "localhost"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "event": {
        "dataset": "mysql.performance",
        "module": "mysql",
        "duration": 14244062
    },
    "metricset": {
        "period": 10000,
        "name": "performance"
    },
    "service": {
        "address": "tcp(127.0.0.1:3306)/?readTimeout=10s&timeout=10s&writeTimeout=10s",
        "type": "mysql"
    }
}
« galera 状态指标集 MySQL 查询指标集 »
Was this helpful?
Feedback