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.

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

[inputs.mysql]: Not Supported - 21 columns #4965

Closed
chpiter opened this issue Nov 6, 2018 · 4 comments
Closed

[inputs.mysql]: Not Supported - 21 columns #4965

chpiter opened this issue Nov 6, 2018 · 4 comments
Labels
area/mysql bug unexpected problem or unintended behavior
Milestone

Comments

@chpiter
Copy link

chpiter commented Nov 6, 2018

I use telegraf to monitor RDS-MySQL on Aliyun
my conf file:

[[inputs.mysql]]
servers = ["xxxx:HpgxxxxHn369@tcp(xxxx:3306)/xxxx?tls=false"]
perf_events_statements_digest_text_limit = 120
perf_events_statements_limit = 250
perf_events_statements_time_limit = 86400
table_schema_databases = []
gather_table_schema = true
gather_process_list = true
gather_user_statistics = true
gather_info_schema_auto_inc = false
gather_innodb_metrics = true
gather_slave_status = false
gather_binary_logs = false
gather_table_io_waits = false
gather_table_lock_waits = true
gather_index_io_waits = false
gather_event_waits = false
gather_file_events_stats = false
gather_perf_events_statements = false
interval_slow = "30m"

got this error message:

E! Error in plugin [inputs.mysql]: Not Supported - 21 columns

I want to know which metrics not supported on Aliyun Rds MySQL

@glinton glinton added bug unexpected problem or unintended behavior area/mysql labels Nov 6, 2018
@glinton
Copy link
Contributor

glinton commented Nov 6, 2018

Do you know what version of MySQL is being used? Also, can you paste the output of the following query?

SELECT * FROM information_schema.user_statistics LIMIT 2

@chpiter
Copy link
Author

chpiter commented Nov 7, 2018

Do you know what version of MySQL is being used? Also, can you paste the output of the following query?

SELECT * FROM information_schema.user_statistics LIMIT 2

MySQL 5.5
output:
image

@glinton
Copy link
Contributor

glinton commented Nov 7, 2018

Thanks, can you paste the column names (not screenshot)?

@chpiter
Copy link
Author

chpiter commented Nov 8, 2018

Thanks, can you paste the column names (not screenshot)?

USER : root
TOTAL_CONNECTIONS : 8507761
CONCURRENT_CONNECTIONS : 0
CONNECTED_TIME : 36869661
BUSY_TIME : 2577
CPU_TIME : 2596
BYTES_RECEIVED : 1862233492
BYTES_SENT : 2147483647
BINLOG_BYTES_WRITTEN : 0
ROWS_FETCHED : 20064409
ROWS_UPDATED : 0
TABLE_ROWS_READ : 0
SELECT_COMMANDS : 6746933
UPDATE_COMMANDS : 0
OTHER_COMMANDS : 27564730
COMMIT_TRANSACTIONS : 0
ROLLBACK_TRANSACTIONS : 0
DENIED_CONNECTIONS : 0
LOST_CONNECTIONS : 20
ACCESS_DENIED : 0
EMPTY_QUERIES : 141977

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/mysql bug unexpected problem or unintended behavior
Projects
None yet
Development

No branches or pull requests

3 participants