# Metricbeat/mysql module data not showing

**URL:** <https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [January 29, 2021, 1:04pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648 "2021-01-29T13:04:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ethrbunny](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethrbunny/32/34603_2.png) [@ethrbunny](https://discuss.elastic.co/u/ethrbunny)\
**Post date:** [January 29, 2021, 1:04pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648/1 "2021-01-29T13:04:11Z")

</div>

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

```
"metricbeat":{"mysql":{"status":{"events":7,"success":7}}}

```

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?

---

<div class="post-metadata">

**Author:** ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)\
**Post date:** [January 29, 2021, 8:23pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648/2 "2021-01-29T20:23:28Z")

</div>

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

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

```

Thanks,

Shaunak

---

<div class="post-metadata">

**Author:** ![ethrbunny](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethrbunny/32/34603_2.png) [@ethrbunny](https://discuss.elastic.co/u/ethrbunny)\
**Post date:** [January 30, 2021, 1:15pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648/3 "2021-01-30T13:15:32Z")

</div>

It's full of messages like this:

```auto
{
  "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."
        }

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 27, 2021, 3:16pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-data-not-showing/262648/4 "2021-02-27T15:16:30Z")

</div>

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