# Mysql Module not retrieving data

**URL:** <https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [December 14, 2019, 1:32am UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859 "2019-12-14T01:32:42Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![JValenzani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jvalenzani/32/59147_2.png) [@JValenzani](https://discuss.elastic.co/u/JValenzani)\
**Post date:** [December 14, 2019, 1:32am UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/1 "2019-12-14T01:32:42Z")

</div>

I have the exact same problem described in this topic ([No data MySQL dashboard - version mismatch?](https://discuss.elastic.co/t/no-data-mysql-dashboard-version-mismatch/146480)). I'm using metricbeat 7.4.2 (amd64) with CentOS 7 and Percona Server 5.7.22  
The topic ends with no resolution. So i'm wondering if there's something special about this config or i hit a bug. Logs doesn't show any errors regarding mysql.

---

<div class="post-metadata">

**Author:** ![jsoriano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsoriano/32/27920_2.png) [@jsoriano](https://discuss.elastic.co/u/jsoriano)\
**Post date:** [December 16, 2019, 1:29pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/2 "2019-12-16T13:29:47Z")

</div>

Hey @JValenzani,

What is exactly the problem in your case? You don't see anything in the MySQL dashboard?

What configuration are you using? Do you see any error in Metricbeat logs?

---

<div class="post-metadata">

**Author:** ![JValenzani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jvalenzani/32/59147_2.png) [@JValenzani](https://discuss.elastic.co/u/JValenzani)\
**Post date:** [December 16, 2019, 2:15pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/3 "2019-12-16T14:15:27Z")

</div>

Same problem as described in the linked post. No data in the MySQL Dashboard, no errors in log.  
Module seems to be loading:  
2019-12-16T11:10:15.928-0300 DEBUG [module] module/wrapper.go:182 Starting metricSetWrapper[module=mysql, name=status, host=/var/lib/mysql/mysql.sock]

---

<div class="post-metadata">

**Author:** ![jsoriano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsoriano/32/27920_2.png) [@jsoriano](https://discuss.elastic.co/u/jsoriano)\
**Post date:** [December 16, 2019, 4:12pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/4 "2019-12-16T16:12:59Z")

</div>

Could you share your configuration? (remember to hide credentials)

Could you check from Kibana if there is any document from the mysql module? For that look for events in `metricbeat-*` indexes, for example from the developer console:

```auto
GET metricbeat-*/_search?q=event.module:mysql

```

---

<div class="post-metadata">

**Author:** ![JValenzani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jvalenzani/32/59147_2.png) [@JValenzani](https://discuss.elastic.co/u/JValenzani)\
**Post date:** [December 16, 2019, 4:48pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/5 "2019-12-16T16:48:16Z")

</div>

I've passed the yml file through a linter and found a typo. Seems to be working now. Anyway, the log file /var/log/metricbeat/ is empty, even with logging.level: debug and logging.selectors: ["\*"] enabled.

---

<div class="post-metadata">

**Author:** ![jsoriano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsoriano/32/27920_2.png) [@jsoriano](https://discuss.elastic.co/u/jsoriano)\
**Post date:** [December 16, 2019, 7:00pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/6 "2019-12-16T19:00:50Z")

</div>

If you are running metricbeat in a system with systemd logs will be written to stdout and captured by journald, take a look to [https://www.elastic.co/guide/en/beats/metricbeat/7.5/running-with-systemd.html#\_customize\_systemd\_unit\_for\_metricbeat](https://www.elastic.co/guide/en/beats/metricbeat/7.5/running-with-systemd.html#_customize_systemd_unit_for_metricbeat)

---

<div class="post-metadata">

**Author:** ![JValenzani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jvalenzani/32/59147_2.png) [@JValenzani](https://discuss.elastic.co/u/JValenzani)\
**Post date:** [December 16, 2019, 7:55pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/7 "2019-12-16T19:55:03Z")

</div>

Great. Thanks.

---

<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:** [January 13, 2020, 8:02pm UTC](https://discuss.elastic.co/t/mysql-module-not-retrieving-data/211859/8 "2020-01-13T20:02:52Z")

</div>

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