MySQL metricbeat module error

Elastic Stack Beats
1

hello !

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

image
image1675×406 29.5 KB

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:

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:

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!

2

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