# MySQL metricbeat module error

**URL:** <https://discuss.elastic.co/t/mysql-metricbeat-module-error/285662>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [October 1, 2021, 8:43am UTC](https://discuss.elastic.co/t/mysql-metricbeat-module-error/285662 "2021-10-01T08:43:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rodri.gz](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@rodri.gz](https://discuss.elastic.co/u/rodri.gz)\
**Post date:** [October 1, 2021, 8:43am UTC](https://discuss.elastic.co/t/mysql-metricbeat-module-error/285662/1 "2021-10-01T08:43:22Z")

</div>

hello !

im trying to use de mysql module of metricbeat but it only works without performance and query.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/d/adb8fa6b2553c3079f01746c4d2d0ba43278b5a7.png)

some visualizations work fine but others don't, I guess this occurs because I can't activate performance and query in the module because when I have it I receive the following errors

**Performance:**

```auto
Oct 01 10:36:32 g99dnap797 metricbeat[105122]: table %!s(bool=true)}%!(EXTRA *mysql.MySQLError=Error 1054: Unknown column 'quantile_95' in 'field list')
Oct 01 10:36:42 g99dnap797 metricbeat[105122]: 2021-10-01T10:36:42.017+0200 ERROR [mysql.performance] query/query.go:92 error doing query {events_statements SELECT di
Oct 01 10:36:42 g99dnap797 metricbeat[105122]: FROM performance_schema.events_statements_summary_by_digest
Oct 01 10:36:42 g99dnap797 metricbeat[105122]: ORDER BY avg_timer_wait DESC
Oct 01 10:36:42 g99dnap797 metricbeat[105122]: LIMIT 10

```

**Query:**

```auto
Oct 01 10:42:14 g99dnap797 metricbeat[106221]: 2021-10-01T10:42:14.703+0200 ERROR instance/beat.go:989 Exiting: 1 error: missing required field accessing '0.queries' (source
Oct 01 10:42:14 g99dnap797 metricbeat[106221]: Exiting: 1 error: missing required field accessing '0.queries' (source:'/etc/metricbeat/modules.d/mysql.yml')
Oc

```

How can i use de full metricset of this module?

Thanks in advanced!

---

<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:** [October 29, 2021, 10:43am UTC](https://discuss.elastic.co/t/mysql-metricbeat-module-error/285662/2 "2021-10-29T10:43:41Z")

</div>

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