MySQL integration does not ingest performance metrics

[hendry.lim (Hendry)]

Hi,

We noticed that the MySQL performance metricset is not ingesting any data.

If we refer to the Fleet policy that we have for MySQL integration, we noticed that the host details are missing for mysql.performance metricset. Is this the reason why the MySQL performance dataset is not being ingested?

  - id: e2e1142c-2749-40da-a44d-91c7df793a80
    name: mysql-1
    revision: 1
    type: mysql/metrics
    use_output: default
    meta:
      package:
        name: mysql
        version: 1.1.0
    data_stream:
      namespace: default
    streams:
      - id: mysql/metrics-mysql.performance-e2e1142c-2749-40da-a44d-91c7df793a80
        data_stream:
          dataset: mysql.performance
          type: metrics
        metricsets:
          - performance
      - id: mysql/metrics-mysql.status-e2e1142c-2749-40da-a44d-91c7df793a80
        data_stream:
          dataset: mysql.status
          type: metrics
        metricsets:
          - status
        hosts:
          - 'tcp(127.0.0.1:32666)/'
        password: somepassword
        period: 30s
        username: someusername