JDBC Input Plugin with MySQL show commands

Elastic Stack Logstash
1

Hi,

i am trying to to query a MySQL 5.7.19 with the "show variables" or the "show slave status" command but always receive a syntax error. All other select queries working fine.

When using the jdbc plugin there seem to be some extra requests being created becaus it is complaining about a statement like "select count(*) from (show variables)........". This does not seem to work.

As information_schema.gloabal status is not available any more and MySQL is heavily relying on this showcommands is there a way to get this working?

Kind regards

Moe

2

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