Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MariaDB user statistics are different from Percona version #2910

Closed
akrus opened this issue Jun 12, 2017 · 11 comments
Closed

MariaDB user statistics are different from Percona version #2910

akrus opened this issue Jun 12, 2017 · 11 comments
Assignees
@glinton
Labels
area/mysql bug unexpected problem or unintended behavior
Milestone
1.7.1

Comments

@akrus
Copy link

akrus commented Jun 12, 2017 •
edited
Loading

Bug report

System info:

Telegraf 1.3.1, MariaDB 10.1.24

Steps to reproduce:

  1. Configure Telegraf with MySQL input plugin
  2. Turn on gather_user_statistics in Telegraf and userstat in MariaDB

Expected behavior:

Information should be collected.

Actual behavior:

Error in logs:
Jun 12 14:43:10 db1 telegraf[14838]: 2017-06-12T13:43:10Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
Jun 12 14:43:10 db1 telegraf[14838]: 2017-06-12T13:43:10Z E! Error in plugin [inputs.mysql]: sql: expected 26 destination arguments in Scan, not 23

Additional info:

            USER: stats
      TOTAL_CONNECTIONS: 83
 CONCURRENT_CONNECTIONS: 0
         CONNECTED_TIME: 55
              BUSY_TIME: 1.2070639999999992
               CPU_TIME: 1.1825710000000003
         BYTES_RECEIVED: 82791
             BYTES_SENT: 1655069
   BINLOG_BYTES_WRITTEN: 0
              ROWS_READ: 0
              ROWS_SENT: 2264
           ROWS_DELETED: 0
          ROWS_INSERTED: 0
           ROWS_UPDATED: 0
        SELECT_COMMANDS: 443
        UPDATE_COMMANDS: 0
         OTHER_COMMANDS: 0
    COMMIT_TRANSACTIONS: 0
  ROLLBACK_TRANSACTIONS: 0
     DENIED_CONNECTIONS: 27
       LOST_CONNECTIONS: 0
          ACCESS_DENIED: 6
          EMPTY_QUERIES: 117
  TOTAL_SSL_CONNECTIONS: 0
   MAX_STATEMENT_TIME_EXCEEDED: 0
@danielnelson danielnelson added the bug unexpected problem or unintended behavior label Jun 12, 2017
@danielnelson
Copy link
Contributor

@gioxchopper Do you know what version of the database you used when you wrote this?

@danielnelson
Copy link
Contributor

https://www.percona.com/doc/percona-server/5.7/diagnostics/user_stats.html#information-schema-tables

@rashidmahmood
Copy link

rashidmahmood commented Aug 31, 2017 •
edited
Loading

I am struggling with the same issue, any idea how to resolve it ?

@danielnelson
Copy link
Contributor

We probably should have a fallback query: optimistically try with the existing percona query and if it fails then try a mysql specific one.

@thekoma
Copy link

thekoma commented Oct 20, 2017

I'm having this problem too, i cannot monitor any of my mariadb servers sadly.

@danielnelson danielnelson added this to the 1.5.0 milestone Oct 20, 2017
@etiennecarriere etiennecarriere mentioned this issue Oct 24, 2017
Closed
3 tasks
@etiennecarriere
Copy link

I had this issue too so I propose a PR with a logic based on @danielnelson proposal

@danielnelson danielnelson modified the milestones: 1.5.0, 1.6.0 Nov 29, 2017
@skord skord mentioned this issue Dec 6, 2017
Closed
@etiennecarriere etiennecarriere mentioned this issue Dec 27, 2017
Closed
@russorat russorat modified the milestones: 1.6.0, 1.7.0 Feb 1, 2018
@nsteinmetz nsteinmetz mentioned this issue May 4, 2018
Closed
@danielnelson danielnelson modified the milestones: 1.7.0, 1.8.0 Jun 3, 2018
glinton added a commit that referenced this issue Jun 15, 2018
@glinton
Handle variations in the user_statistics collecting
d639493 
MariaDB has two different table definitions:
 - https://mariadb.com/kb/en/library/information-schema-user_statistics-table/
Percona has it's own:
 - https://www.percona.com/doc/percona-server/LATEST/diagnostics/user_stats.html#USER_STATISTICS
MySQL doesn't have the table, but there may be a patch:
 - https://www.byte.nl/blog/enhancing-mysql-with-user-statistics

Resolves #2910
Closes #3382
@glinton glinton mentioned this issue Jun 15, 2018
Merged
3 tasks
@danielnelson danielnelson modified the milestones: 1.8.0, 1.7.1 Jun 30, 2018
@rmacian
Copy link

rmacian commented Sep 27, 2018

I am in 1.8.0 and still the same error occurs

@danielnelson
Copy link
Contributor

@rmacian What version of MariaDB?

@rmacian
Copy link

rmacian commented Sep 28, 2018

@danielnelson is version 5.5.52

@danielnelson
Copy link
Contributor

Can you open it as a new issue?

@rdxmb
Copy link
Contributor

rdxmb commented Feb 12, 2019

something similar: #5418

yabberyabber added a commit to aristanetworks/telegraf that referenced this issue Jun 26, 2019
@yabberyabber
Upgrade mysql plugin to version 1.8
a303e6b 
This solves issue with collecting user stats from mariadb 10

See influxdata#2910 (Note - the
person claiming 1.8 didn't work for them is using mariadb 5... we are
using mariadb 10 which is explicitly handled in the new plugin)
yabberyabber added a commit to aristanetworks/telegraf that referenced this issue Jun 27, 2019
@yabberyabber
Upgrade mysql plugin to version 1.8
5bb8c50 
This solves issue with collecting user stats from mariadb 10

See influxdata#2910 (Note - the
person claiming 1.8 didn't work for them is using mariadb 5... we are
using mariadb 10 which is explicitly handled in the new plugin)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@glinton glinton

Labels
area/mysql bug unexpected problem or unintended behavior
Projects
None yet
Milestone
1.7.1
Development

No branches or pull requests
9 participants
@akrus @thekoma @danielnelson @rmacian @glinton @russorat @rashidmahmood @etiennecarriere @rdxmb