# JDBC Input Plugin with MySQL show commands

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-with-mysql-show-commands/111027>\
**Category:** Logstash\
**Created:** [December 11, 2017, 7:35am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-mysql-show-commands/111027 "2017-12-11T07:35:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmoeller](https://avatars.discourse-cdn.com/v4/letter/t/f0a364/32.png) [@tmoeller](https://discuss.elastic.co/u/tmoeller)\
**Post date:** [December 11, 2017, 7:35am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-mysql-show-commands/111027/1 "2017-12-11T07:35:03Z")

</div>

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

---

<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 8, 2018, 7:35am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-mysql-show-commands/111027/2 "2018-01-08T07:35:21Z")

</div>

Closed on January 8, 2018, 7:35am UTC

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