Metricbeat/mysql module data not showing

I have the mysql module enabled on a number of mysql hosts. I see this appearing in the logs:


When I go to kibana and search for mysql I don't see any values in the metricbeat-* indices.

I see other system/proc metrics for these hosts.

What am I doing wrong?

Could you please run the following Elasticsearch query in Kibana > Dev Tools > Console and post the output here?

POST metricbeat-*/_search
  "size": 0,
  "aggs": {
    "by_dataset": {
      "terms": {
        "field": "event.dataset",
        "size": 100



It's full of messages like this:

  "took" : 1104,
  "timed_out" : false,
  "_shards" : {
    "total" : 19,
    "successful" : 5,
    "skipped" : 0,
    "failed" : 14,
    "failures" : [
        "shard" : 0,
        "index" : "metricbeat-2021.01.17",
        "node" : "xPg0fK-BR5qX1nAz8bXdbg",
        "reason" : {
          "type" : "illegal_argument_exception",
          "reason" : "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [event.dataset] in order to load field data by uninverting the inverted index. Note that this can use significant memory."

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.