[MySQL] gather_table_schema not working for MariaDB

[Allineer]

Relevant telegraf.conf:

[[inputs.mysql]]
  servers = ["username:password@tcp(127.0.0.1:3306)/"]
  gather_table_schema = true
  gather_process_list = true
  gather_user_statistics = true
  gather_info_schema_auto_inc = true
  gather_innodb_metrics = true
  gather_slave_status = true
  gather_binary_logs = true
  gather_table_io_waits = true
  gather_table_lock_waits = true
  gather_index_io_waits = true
  gather_event_waits = true
  gather_file_events_stats = true
  gather_perf_events_statements = true
  interval_slow = "30m"
  table_schema_databases = []

System info:

Linux shkoder 4.9.0-4-amd64 #1 SMP Debian 4.9.51-1 (2017-09-28) x86_64 GNU/Linux
Telegraf v1.5.0 (git: release-1.5 a1668bbf)
mysql  Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Steps to reproduce:

1. Configure Telegraf
2. telegraf --config /etc/telegraf/telegraf.conf --test | grep mysql | sort

Expected behavior:

Per-table information

Actual behavior:

No information about tables/databases.

Additional info:

tail /var/log/telegraf/telegraf.log
2017-12-17T20:19:08Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
2017-12-17T20:19:08Z E! Error in plugin [inputs.mysql]: Error 1381: You are not using binary logging
2017-12-17T20:20:19Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
2017-12-17T20:20:19Z E! Error in plugin [inputs.mysql]: Error 1381: You are not using binary logging
2017-12-17T20:21:25Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
2017-12-17T20:21:25Z E! Error in plugin [inputs.mysql]: Error 1381: You are not using binary logging
2017-12-17T20:27:00Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
2017-12-17T20:27:00Z E! Error in plugin [inputs.mysql]: Error 1381: You are not using binary logging
2017-12-17T20:28:54Z E! MySQL Error gathering user stats: Error 1054: Unknown column 'rows_fetched' in 'field list'
2017-12-17T20:28:54Z E! Error in plugin [inputs.mysql]: Error 1381: You are not using binary logging

> mysql,server=127.0.0.1:3306 aborted_connects=3i,bytes_received=732199597i,commands_admin_commands=97721i,commands_alter_tablespace=0i,commands_begin=1028i,commands_alter_db=0i,commands_alter_db_upgrade=0i,commands_alter_function=0i,commands_alter_procedure=0i,commands_alter_server=0i,access_denied_errors=21i,bytes_sent=17747496445i,commands_alter_table=50i,commands_analyze=0i,commands_assign_to_keycache=0i,commands_binlog=0i,aborted_clients=61i,busy_time=0i,commands_alter_event=0i,commands_call_procedure=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_create_trigger=0i,commands_create_view=0i,commands_dealloc_sql=0i,commands_check=0i,commands_checksum=0i,commands_create_db=4i,commands_create_table=36i,commands_create_temporary_table=0i,commands_change_db=15993i,commands_change_master=0i,commands_create_user=2i,commands_create_role=0i,commands_create_server=0i,commands_create_event=0i,commands_create_function=0i,commands_create_index=58i,commands_create_procedure=0i,commands_create_udf=0i,commands_commit=920i,commands_compound_sql=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_drop_index=9i,commands_drop_role=0i,commands_drop_server=0i,commands_do=0i,commands_drop_event=0i,commands_drop_function=0i,commands_drop_table=19i,commands_execute_sql=0i,commands_grant=7i,commands_delete=1083i,commands_delete_multi=0i,commands_drop_procedure=0i,commands_drop_temporary_table=0i,commands_drop_trigger=0i,commands_drop_view=0i,commands_flush=15i,commands_get_diagnostics=0i,commands_drop_db=5i,commands_drop_user=0i,commands_empty_query=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_ha_close=0i,commands_ha_open=0i,commands_insert=86114i,commands_kill=0i,commands_optimize=0i,commands_preload_keys=0i,commands_release_savepoint=2i,commands_rename_user=0i,commands_repair=0i,commands_ha_read=0i,commands_insert_select=36i,commands_load=0i,commands_purge=0i,commands_rename_table=1i,commands_grant_role=0i,commands_help=0i,commands_install_plugin=0i,commands_lock_tables=233i,commands_prepare_sql=0i,commands_purge_before_date=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_rollback=108i,commands_show_authors=0i,commands_show_binlogs=9i,commands_show_charsets=1i,commands_revoke_role=0i,commands_rollback_to_savepoint=0i,commands_savepoint=2i,commands_select=381488i,commands_set_option=56399i,commands_show_create_event=0i,commands_reset=0i,commands_revoke_all=0i,commands_show_collations=2i,commands_show_create_db=8i,commands_replace=752i,commands_replace_select=0i,commands_resignal=0i,commands_revoke=1i,commands_show_binlog_events=0i,commands_show_contributors=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_show_generic=0i,commands_show_grants=14i,commands_show_open_tables=0i,commands_show_plugins=0i,commands_show_create_trigger=0i,commands_show_engine_logs=0i,commands_show_errors=0i,commands_show_explain=0i,commands_show_fields=12392i,commands_show_function_status=19i,commands_show_privileges=0i,commands_show_create_func=0i,commands_show_create_table=9814i,commands_show_engine_mutex=0i,commands_show_events=3i,commands_show_keys=0i,commands_show_master_status=0i,commands_show_create_proc=0i,commands_show_databases=34i,commands_show_engine_status=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_show_variables=41i,commands_show_relaylog_events=0i,commands_show_slave_status=0i,commands_show_warnings=0i,commands_signal=0i,commands_stmt_close=31027i,commands_show_profile=0i,commands_show_profiles=0i,commands_show_tables=737i,commands_start_all_slaves=0i,commands_stmt_execute=31027i,commands_show_processlist=0i,commands_show_slave_hosts=0i,commands_show_storage_engines=2i,commands_show_table_status=2033i,commands_show_triggers=2033i,commands_shutdown=0i,commands_start_slave=0i,commands_show_procedure_status=19i,commands_show_status=35i 1513542659000000000
> mysql,server=127.0.0.1:3306 commands_xa_end=0i,commands_xa_rollback=0i,connection_errors_internal=0i,commands_stop_all_slaves=0i,commands_update_multi=0i,commands_xa_commit=0i,commands_stmt_fetch=0i,commands_truncate=0i,commands_uninstall_plugin=0i,commands_xa_prepare=0i,commands_xa_recover=0i,commands_stmt_prepare=31027i,commands_stmt_reprepare=0i,commands_stop_slave=0i,commands_update=3904i,commands_xa_start=0i,connection_errors_accept=0i,commands_stmt_reset=0i,commands_stmt_send_long_data=0i,commands_unlock_tables=251i 1513542659000000000
> mysql,server=127.0.0.1:3306 feature_delay_key_write=0i,feature_gis=0i,connection_errors_select=0i,created_tmp_tables=48956i,connection_errors_tcpwrap=0i,created_tmp_disk_tables=22167i,delayed_insert_threads=0i,empty_queries=87370i,feature_dynamic_columns=0i,connection_errors_max_connections=0i,connection_errors_peer_address=0i,executed_triggers=0i,feature_fulltext=0i,created_tmp_files=5552i,delayed_errors=0i,executed_events=0i,feature_locale=0i,feature_subquery=42325i,connections=12715i,delayed_writes=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 feature_timezone=258i,handler_external_lock=0i,handler_mrr_key_refills=0i,handler_read_key=64205993i,handler_read_prev=498i,handler_read_retry=0i,feature_trigger=0i,handler_icp_match=433237i,handler_mrr_init=0i,feature_xml=0i,flush_commands=1i,handler_commit=21000i,handler_discover=52i,handler_mrr_rowid_refills=0i,handler_prepare=0i,handler_read_last=164i,handler_delete=922i,handler_icp_attempts=453293i,handler_read_first=36028i,handler_read_next=276945180i 1513542659000000000
> mysql,server=127.0.0.1:3306 handler_read_rnd_next=133424928i,handler_rollback=5i,handler_savepoint=2i,handler_savepoint_rollback=0i,innodb_background_log_sync=1611870i,innodb_buffer_pool_load_status=0i,innodb_buffer_pool_pages_data=1576i,innodb_buffer_pool_pages_flushed=9532i,handler_read_rnd_deleted=13133i,handler_update=7854i,innodb_available_undo_logs=128i,innodb_buffer_pool_bytes_data=25821184i,innodb_buffer_pool_dump_status=0i,handler_tmp_update=4088155i,handler_tmp_write=4320302i,innodb_buffer_pool_bytes_dirty=0i,handler_read_rnd=22810534i,handler_write=87129i,innodb_buffer_pool_pages_dirty=0i,innodb_buffer_pool_pages_free=6611i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_checkpoint_max_age=80826164i,innodb_buffer_pool_pages_total=8191i,innodb_buffer_pool_write_requests=43526i,innodb_data_pending_reads=0i,innodb_buffer_pool_pages_misc=4i,innodb_buffer_pool_pages_old=562i,innodb_buffer_pool_read_ahead=0i,innodb_buffer_pool_read_ahead_evicted=0i,innodb_buffer_pool_read_ahead_rnd=0i,innodb_buffer_pool_read_requests=428481i,innodb_data_pending_fsyncs=0i,innodb_buffer_pool_pages_made_not_young=0i,innodb_buffer_pool_pages_made_young=0i,innodb_buffer_pool_reads=1078i,innodb_buffer_pool_wait_free=0i,innodb_checkpoint_age=0i,innodb_data_fsyncs=6059i,innodb_data_pending_writes=0i,innodb_data_read=17732096i,innodb_buffer_pool_pages_lru_flushed=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_data_writes=13412i,innodb_data_written=320945664i,innodb_dblwr_writes=806i,innodb_deadlocks=0i,innodb_ibuf_discarded_inserts=0i,innodb_ibuf_merged_delete_marks=0i,innodb_ibuf_segment_size=2i,innodb_ibuf_size=1i,innodb_ibuf_merged_deletes=0i,innodb_ibuf_merges=0i,innodb_dblwr_pages_written=9532i,innodb_have_atomic_builtins=0i,innodb_ibuf_discarded_delete_marks=0i,innodb_ibuf_merged_inserts=0i,innodb_log_write_requests=15096i,innodb_data_reads=1203i,innodb_history_list_length=31i,innodb_ibuf_discarded_deletes=0i,innodb_ibuf_free_list=0i,innodb_log_waits=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_encryption_key_rotation_list_length=0i,innodb_scrub_background_page_splits=0i,innodb_scrub_background_page_split_failures_missing_index=0i,key_blocks_unused=9023i,master_gtid_wait_time=0i,innodb_encryption_rotation_estimated_iops=0i,innodb_scrub_background_page_reorganizations=0i,innodb_scrub_background_page_split_failures_underflow=0i,innodb_scrub_background_page_split_failures_unknown=0i,key_blocks_used=4805i,key_write_requests=91336i,master_gtid_wait_count=0i,innodb_encryption_num_key_requests=0i,key_blocks_not_flushed=0i,key_read_requests=197346271i,key_writes=91038i,last_query_cost=0i,innodb_scrub_background_page_split_failures_out_of_filespace=0i,key_blocks_warm=2360i,key_reads=4893i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_have_snappy=0i,innodb_defragment_failures=0i,innodb_defragment_count=0i,innodb_secondary_index_triggered_cluster_reads_avoided=0i,innodb_encryption_rotation_pages_flushed=0i,innodb_num_pages_page_compression_error=0i,innodb_num_pages_encrypted=0i,innodb_encryption_rotation_pages_read_from_disk=0i,innodb_defragment_compression_failures=0i,innodb_onlineddl_pct_progress=0i,innodb_have_lzo=0i,innodb_have_bzip2=0i,innodb_onlineddl_rowlog_pct_used=0i,innodb_encryption_rotation_pages_read_from_cache=0i,innodb_encryption_rotation_pages_modified=0i,innodb_num_pages_decrypted=0i,innodb_have_lz4=0i,innodb_secondary_index_triggered_cluster_reads=8343i,innodb_have_lzma=0i,innodb_onlineddl_rowlog_rows=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_lsn_last_checkpoint=37817192i,innodb_mem_adaptive_hash=2283104i,innodb_oldest_view_low_limit_trx_id=0i,innodb_os_log_fsyncs=2776i,innodb_os_log_pending_fsyncs=0i,innodb_os_log_written=8250880i,innodb_log_writes=2092i,innodb_mutex_os_waits=1615i,innodb_os_log_pending_writes=0i,innodb_page_size=16384i,innodb_pages_created=499i,innodb_max_trx_id=59945i,innodb_lsn_flushed=37817192i,innodb_master_thread_idle_loops=1611462i,innodb_mem_dictionary=2411734i,innodb_mutex_spin_rounds=57379i,innodb_mutex_spin_waits=6609i,innodb_lsn_current=37817192i,innodb_mem_total=140574720i,innodb_master_thread_active_loops=681i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_rows_updated=565i,innodb_system_rows_inserted=0i,innodb_pages0_read=115i,innodb_read_views_memory=976i,innodb_rows_deleted=182i,innodb_row_lock_waits=52i,innodb_rows_read=187704i,innodb_pages_read=1077i,innodb_purge_undo_no=0i,innodb_row_lock_time_avg=22i,innodb_system_rows_read=0i,innodb_system_rows_updated=0i,innodb_row_lock_time_max=246i,innodb_rows_inserted=554i,innodb_system_rows_deleted=0i,innodb_row_lock_time=1173i,innodb_s_lock_os_waits=1157i,innodb_pages_written=9532i,innodb_purge_trx_id=59865i,innodb_row_lock_current_waits=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 innodb_s_lock_spin_rounds=34862i,innodb_x_lock_os_waits=86i,innodb_page_compression_trim_sect512=0i,innodb_page_compression_trim_sect32768=0i,innodb_num_pages_page_compressed=0i,innodb_num_page_compressed_trim_op=0i,innodb_num_pages_page_decompressed=0i,innodb_x_lock_spin_waits=17i,innodb_page_compression_trim_sect1024=0i,innodb_page_compression_trim_sect2048=0i,innodb_num_index_pages_written=3032i,innodb_num_non_index_pages_written=10104i,innodb_page_compression_saved=0i,innodb_page_compression_trim_sect4096=0i,innodb_page_compression_trim_sect8192=0i,innodb_page_compression_trim_sect16384=0i,innodb_s_lock_spin_waits=1135i,innodb_truncated_status_writes=0i,innodb_x_lock_spin_rounds=2794i,innodb_num_page_compressed_trim_op_saved=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 opened_table_definitions=657i,performance_schema_file_classes_lost=0i,open_streams=0i,opened_files=95579i,opened_plugin_libraries=0i,performance_schema_cond_instances_lost=0i,performance_schema_file_handles_lost=0i,not_flushed_delayed_rows=0i,open_table_definitions=391i,performance_schema_cond_classes_lost=0i,opened_views=0i,performance_schema_accounts_lost=0i,master_gtid_wait_timeouts=0i,memory_used=189463216i,open_tables=747i,opened_tables=897i,performance_schema_digest_lost=0i,max_statement_time_exceeded=0i,max_used_connections=56i,open_files=574i 1513542659000000000
> mysql,server=127.0.0.1:3306 performance_schema_socket_instances_lost=0i,performance_schema_statement_classes_lost=0i,performance_schema_table_handles_lost=0i,performance_schema_mutex_instances_lost=0i,performance_schema_rwlock_classes_lost=0i,performance_schema_mutex_classes_lost=0i,performance_schema_rwlock_instances_lost=0i,qcache_free_blocks=1876i,performance_schema_file_instances_lost=0i,performance_schema_locker_lost=0i,performance_schema_users_lost=0i,performance_schema_stage_classes_lost=0i,performance_schema_thread_instances_lost=0i,performance_schema_socket_classes_lost=0i,performance_schema_table_instances_lost=0i,performance_schema_thread_classes_lost=0i,prepared_stmt_count=0i,qcache_free_memory=6538552i,performance_schema_hosts_lost=0i,performance_schema_session_connect_attrs_lost=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 select_scan=86630i,slave_heartbeat_period=0i,qcache_inserts=87927i,select_full_range_join=0i,select_range=1040i,select_range_check=0i,qcache_queries_in_cache=7377i,rows_read=432129182i,rows_sent=58319059i,slave_open_temp_tables=0i,qcache_lowmem_prunes=62065i,questions=589015i,rows_tmp_read=5605096i,select_full_join=1540i,rpl_status=0i,slave_connections=0i,qcache_hits=265202i,qcache_not_cached=3068i,qcache_total_blocks=16768i,queries=651069i 1513542659000000000
> mysql,server=127.0.0.1:3306 sort_range=6181i,subquery_cache_miss=7785i,table_locks_waited=3i,tc_log_page_waits=0i,threadpool_idle_threads=0i,sort_merge_passes=2773i,slow_launch_threads=0i,subquery_cache_hit=1418i,tc_log_max_pages_used=0i,slave_received_heartbeats=0i,slave_running=0i,slow_queries=0i,tc_log_page_size=4096i,slave_retried_transactions=0i,sort_priority_queue_sorts=194i,sort_rows=22812986i,sort_scan=19451i,syncs=86i,table_locks_immediate=269669i,slave_skipped_errors=0i 1513542659000000000
> mysql,server=127.0.0.1:3306 uptime_since_flush_status=1614274i,wsrep_local_bf_aborts=0i,wsrep_provider_name=0i,uptime=1614274i,wsrep_cluster_state_uuid=0i,wsrep_local_index=9223372036854775807i,wsrep_provider_vendor=0i,wsrep_provider_version=0i,wsrep_thread_count=0i,wsrep_cluster_conf_id=9223372036854775807i,threads_running=1i,wsrep_cluster_size=0i,wsrep_ready=0i,threadpool_threads=0i,threads_connected=10i,threads_created=262i,wsrep_cluster_status=0i,wsrep_connected=0i,threads_cached=6i 1513542659000000000
> mysql_users,server=127.0.0.1:3306,user=[hidden] connections=6i 1513542659000000000
> mysql_users,server=127.0.0.1:3306,user=[hidden] connections=1i 1513542659000000000
> mysql_users,server=127.0.0.1:3306,user=[hidden] connections=1i 1513542659000000000
> mysql_users,user=[hidden],server=127.0.0.1:3306 connections=2i 1513542659000000000
> mysql_variables,protocol_version=10,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 slow_query_log=0,sql_notes=1,slave_parallel_threads=0,slave_sql_verify_checksum=1,slave_transaction_retries=10,sql_log_off=0,sql_quote_show_create=1,slave_compressed_protocol=0,slave_domain_parallel_threads=0,slave_net_timeout=3600,slave_parallel_max_queued=131072,sql_big_selects=1,sql_log_bin=1,sql_buffer_result=0,slave_max_allowed_packet=1073741824,slave_skip_errors=0,slave_type_conversions="",slow_launch_time=2,sort_buffer_size=2097152,sql_auto_is_null=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 aria_log_file_size=1073741824,aria_max_sort_file_size=9223372036853727000,aria_used_for_temp_tables=1,auto_increment_offset=1,aria_encrypt_tables=0,aria_force_start_after_recovery_failures=0,aria_pagecache_age_threshold=300,aria_pagecache_buffer_size=134217728,aria_repair_threads=1,auto_increment_increment=1,autocommit=1,aria_pagecache_file_hash_size=512,aria_sort_buffer_size=268434432,aria_block_size=8192,aria_checkpoint_interval=30,aria_checkpoint_log_activity=1048576,aria_group_commit_interval=0,aria_page_checksum=1,aria_pagecache_division_limit=100,automatic_sp_privileges=1 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 binlog_stmt_cache_size=32768,delay_key_write=1,big_tables=0,binlog_direct_non_transactional_updates=0,deadlock_timeout_long=50000000,binlog_annotate_row_events=0,binlog_cache_size=32768,binlog_commit_wait_usec=100000,binlog_optimize_thread_scheduling=1,deadlock_timeout_short=10000,default_week_format=0,delayed_insert_timeout=300,back_log=80,bulk_insert_buffer_size=8388608,connect_timeout=10,deadlock_search_depth_long=15,deadlock_search_depth_short=4,debug_no_thread_alarm=0,delayed_insert_limit=100,binlog_commit_wait_count=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 extra_max_connections=1,extra_port=0,div_precision_increment=4,flush_time=0,general_log=0,encrypt_binlog=0,encrypt_tmp_files=0,event_scheduler=0,expire_logs_days=10,explicit_defaults_for_timestamp=0,ft_max_word_len=84,ft_min_word_len=4,ft_query_expansion_limit=20,encrypt_tmp_disk_tables=0,gtid_domain_id=0,group_concat_max_len=1024,expensive_subquery_limit=100,flush=0,foreign_key_checks=1,delayed_queue_size=1000 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 host_cache_size=279,innodb_adaptive_flushing_lwm=10,innodb_adaptive_hash_index=1,innodb_adaptive_max_sleep_delay=150000,innodb_api_bk_commit_interval=5,innodb_api_disable_rowlock=0,gtid_ignore_duplicates=0,gtid_strict_mode=0,innodb_background_scrub_data_compressed=0,innodb_api_enable_binlog=0,innodb_autoextend_increment=64,innodb_additional_mem_pool_size=8388608,innodb_api_trx_level=0,innodb_autoinc_lock_mode=1,ignore_builtin_innodb=0,innodb_adaptive_hash_index_partitions=1,histogram_size=0,innodb_background_scrub_data_check_interval=3600,innodb_adaptive_flushing=1,innodb_api_enable_mdl=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_change_buffer_max_size=25,innodb_compression_level=6,innodb_background_scrub_data_interval=604800,innodb_buf_dump_status_frequency=0,innodb_buffer_pool_size=134217728,innodb_buffer_pool_dump_pct=100,innodb_buffer_pool_load_abort=0,innodb_compression_pad_pct_max=50,innodb_concurrency_tickets=5000,innodb_background_scrub_data_uncompressed=0,innodb_buffer_pool_dump_at_shutdown=0,innodb_buffer_pool_load_at_startup=0,innodb_buffer_pool_populate=0,innodb_checksums=1,innodb_cmp_per_index_enabled=0,innodb_commit_concurrency=0,innodb_compression_failure_threshold_pct=5,innodb_buffer_pool_dump_now=0,innodb_buffer_pool_instances=8,innodb_buffer_pool_load_now=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_defragment_fill_factor_n_recs=20,innodb_encryption_threads=0,innodb_fast_shutdown=1,innodb_defragment_n_pages=7,innodb_defragment_stats_accuracy=0,innodb_disable_sort_file_cache=0,innodb_encrypt_tables=0,innodb_encryption_rotation_iops=100,innodb_default_encryption_key_id=1,innodb_defragment_fill_factor=0.9,innodb_defragment_frequency=40,innodb_fake_changes=0,innodb_encryption_rotate_key_age=1,innodb_file_format_check=1,innodb_file_per_table=1,innodb_defragment=0,innodb_disallow_writes=0,innodb_encrypt_log=0,innodb_doublewrite=1,innodb_fatal_semaphore_wait_threshold=600 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_ft_total_cache_size=640000000,innodb_ft_sort_pll_degree=2,innodb_instrument_semaphores=0,innodb_flush_log_at_timeout=1,innodb_force_load_corrupted=0,innodb_force_primary_key=0,innodb_force_recovery=0,innodb_ft_enable_stopword=1,innodb_immediate_scrub_data_uncompressed=0,innodb_io_capacity=200,innodb_flush_log_at_trx_commit=1,innodb_flushing_avg_loops=30,innodb_ft_max_token_size=84,innodb_ft_num_word_optimize=2000,innodb_ft_result_cache_limit=2000000000,innodb_flush_neighbors=1,innodb_ft_cache_size=8000000,innodb_ft_enable_diag_print=0,innodb_ft_min_token_size=3,innodb_idle_flush_pct=100 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_io_capacity_max=2000,innodb_kill_idle_transaction=0,innodb_log_archive=0,innodb_log_file_size=50331648,innodb_max_dirty_pages_pct_lwm=0.001,innodb_large_prefix=1,innodb_locks_unsafe_for_binlog=0,innodb_log_block_size=512,innodb_log_buffer_size=16777216,innodb_max_changed_pages=1000000,innodb_log_compressed_pages=1,innodb_lru_scan_depth=1024,innodb_max_bitmap_file_size=104857600,innodb_max_purge_lag=0,innodb_max_purge_lag_delay=0,innodb_lock_wait_timeout=50,innodb_locking_fake_changes=1,innodb_log_arch_expire_sec=0,innodb_log_files_in_group=2,innodb_max_dirty_pages_pct=75 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_mirrored_log_groups=1,innodb_old_blocks_pct=37,innodb_open_files=2000,innodb_optimize_fulltext_only=0,innodb_random_read_ahead=0,innodb_rollback_on_timeout=0,innodb_rollback_segments=128,innodb_online_alter_log_max_size=134217728,innodb_page_size=16384,innodb_read_io_threads=4,innodb_replication_delay=0,innodb_mtflush_threads=8,innodb_print_all_deadlocks=0,innodb_purge_batch_size=300,innodb_purge_threads=1,innodb_sched_priority_cleaner=19,innodb_old_blocks_time=1000,innodb_prefix_index_cluster_optimization=0,innodb_read_ahead_threshold=56,innodb_read_only=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306 innodb_show_verbose_locks=0,innodb_sort_buffer_size=1048576,innodb_spin_wait_delay=6,innodb_stats_include_delete_marked=0,innodb_status_output_locks=0,innodb_show_locks_held=10,innodb_simulate_comp_failures=0,innodb_stats_modified_counter=0,innodb_stats_traditional=1,innodb_stats_transient_sample_pages=8,innodb_support_xa=1,innodb_scrub_log=0,innodb_stats_sample_pages=8,innodb_status_output=0,innodb_strict_mode=0,innodb_stats_auto_recalc=1,innodb_stats_on_metadata=0,innodb_stats_persistent=1,innodb_stats_persistent_sample_pages=20,innodb_scrub_log_speed=256 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 innodb_use_atomic_writes=0,innodb_use_sys_malloc=1,innodb_use_trim=0,innodb_write_io_threads=4,innodb_sync_spin_loops=30,innodb_table_locks=1,innodb_track_changed_pages=0,innodb_undo_tablespaces=0,join_buffer_size=262144,innodb_thread_sleep_delay=10000,innodb_use_global_flush_log_at_trx_commit=1,innodb_use_stacktrace=0,interactive_timeout=28800,innodb_use_fallocate=0,innodb_use_mtflush=0,innodb_version="5.6.36-82.1",innodb_sync_array_size=1,innodb_thread_concurrency=0,innodb_undo_logs=128,innodb_use_native_aio=1 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 key_cache_age_threshold=300,key_cache_file_hash_size=512,large_page_size=0,large_pages=0,local_infile=1,join_buffer_space_limit=2097152,join_cache_level=2,key_buffer_size=16777216,log_bin_trust_function_creators=0,log_queries_not_using_indexes=0,locked_in_memory=0,log_bin=0,keep_files_on_create=0,large_files_support=1,lock_wait_timeout=31536000,key_cache_block_size=1024,key_cache_division_limit=100,log_slow_admin_statements=0,key_cache_segments=0,log_slave_updates=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 max_connections=151,max_delayed_threads=20,max_heap_table_size=16777216,log_slow_slave_statements=0,low_priority_updates=0,max_digest_length=1024,max_insert_delayed_threads=20,master_verify_checksum=0,max_allowed_packet=16777216,max_connect_errors=100,log_slow_rate_limit=1,log_tc_size=24576,lower_case_file_system=0,lower_case_table_names=0,max_binlog_cache_size=18446744073709548000,max_binlog_size=104857600,max_binlog_stmt_cache_size=18446744073709548000,max_error_count=64,log_warnings=1,long_query_time=10 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 max_sort_length=1024,max_statement_time=0,max_session_mem_used=9223372036854776000,max_user_connections=0,min_examined_row_limit=0,myisam_block_size=1024,mrr_buffer_size=262144,max_length_for_sort_data=1024,max_long_data_size=16777216,max_prepared_stmt_count=16382,max_relay_log_size=104857600,max_tmp_tables=32,metadata_locks_cache_size=1024,metadata_locks_hash_instances=8,max_join_size=18446744073709552000,max_seeks_for_key=4294967295,max_sp_recursion_depth=0,max_write_lock_count=4294967295,multi_range_count=256,myisam_data_pointer_size=6 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 myisam_mmap_size=18446744073709552000,optimizer_use_condition_selectivity=1,old_passwords=0,optimizer_search_depth=62,optimizer_selectivity_sampling_limit=100,myisam_max_sort_file_size=9223372036853727000,net_buffer_length=16384,net_read_timeout=30,net_retry_count=10,old=0,myisam_sort_buffer_size=134216704,net_write_timeout=60,old_alter_table=0,performance_schema_accounts_size=-1,performance_schema=0,myisam_repair_threads=1,myisam_use_mmap=0,mysql56_temporal_format=1,open_files_limit=16364,optimizer_prune_level=1 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1 performance_schema_max_cond_instances=-1,performance_schema_max_file_classes=50,performance_schema_max_file_instances=-1,performance_schema_max_mutex_classes=200,performance_schema_digests_size=-1,performance_schema_events_stages_history_long_size=-1,performance_schema_events_waits_history_size=-1,performance_schema_events_statements_history_size=-1,performance_schema_events_waits_history_long_size=-1,performance_schema_max_cond_classes=80,performance_schema_max_digest_length=1024,performance_schema_max_mutex_instances=-1,performance_schema_max_rwlock_classes=40,performance_schema_max_rwlock_instances=-1,performance_schema_events_stages_history_size=-1,performance_schema_hosts_size=-1,performance_schema_max_socket_classes=10,performance_schema_max_socket_instances=-1,performance_schema_events_statements_history_long_size=-1,performance_schema_max_file_handles=32768 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1,protocol_version=10 preload_buffer_size=32768,profiling=0,protocol_version=10,query_cache_min_res_unit=4096,performance_schema_max_statement_classes=178,performance_schema_session_connect_attrs_size=-1,performance_schema_max_table_instances=-1,query_cache_size=16777216,progress_report_time=5,query_alloc_block_size=16384,performance_schema_setup_actors_size=100,performance_schema_setup_objects_size=100,performance_schema_max_thread_classes=50,performance_schema_max_thread_instances=-1,performance_schema_users_size=-1,port=3306,profiling_history_size=15,query_cache_limit=1048576,performance_schema_max_stage_classes=150,performance_schema_max_table_handles=-1 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1,protocol_version=10 rowid_merge_buff_size=8388608,query_cache_wlock_invalidate=0,range_alloc_block_size=4096,relay_log_recovery=0,relay_log_space_limit=0,server_id=0,query_cache_type=1,read_only=0,replicate_annotate_row_events=0,skip_name_resolve=0,read_buffer_size=131072,query_prealloc_size=24576,read_rnd_buffer_size=262144,relay_log_purge=1,report_port=3306,secure_auth=1,skip_external_locking=1,skip_networking=0,query_cache_strip_comments=0,skip_show_database=0 1513542659000000000
> mysql_variables,server=127.0.0.1:3306,innodb_version=5.6.36-82.1,protocol_version=10 thread_pool_max_threads=1000,sql_warnings=0,sync_relay_log=10000,thread_concurrency=10,thread_pool_size=2,stored_program_cache=256,sync_binlog=0,sync_relay_log_info=10000,sync_master_info=10000,table_open_cache=2000,thread_cache_size=8,thread_pool_idle_timeout=60,sql_select_limit=18446744073709552000,strict_password_validation=1,sync_frm=1,thread_pool_oversubscribe=3,thread_pool_stall_limit=500,sql_safe_updates=0,sql_slave_skip_counter=0,table_definition_cache=400 1513542659000000000
> mysql_variables,version_compile_machine=x86_64,version_malloc_library=system\ jemalloc,version_ssl_library=YaSSL\ 2.4.2,wsrep_patch_version=wsrep_25.19,server=127.0.0.1:3306,version=10.1.26-MariaDB-0+deb9u1,version_comment=Debian\ 9.1,version_compile_os=debian-linux-gnu,innodb_version=5.6.36-82.1,protocol_version=10 wsrep_gtid_mode=0,wsrep_max_ws_size=2147483647,wsrep_patch_version="wsrep_25.19",wsrep_slave_threads=1,wsrep_desync=0,wsrep_replicate_myisam=0,wsrep_retry_autocommit=1,wsrep_mysql_replication_bundle=0,wsrep_max_ws_rows=0,wsrep_on=0,wsrep_slave_fk_checks=1,wsrep_slave_uk_checks=0,wsrep_gtid_domain_id=0,wsrep_drupal_282555_workaround=0,wsrep_load_data_splitting=1,wsrep_log_conflicts=0,wsrep_recover=0,wsrep_restart_slave=0,wsrep_sst_donor_rejects_queries=0,wsrep_dirty_reads=0 1513542659000000000
> mysql_variables,version_ssl_library=YaSSL\ 2.4.2,server=127.0.0.1:3306,version=10.1.26-MariaDB-0+deb9u1,version_compile_machine=x86_64,version_malloc_library=system\ jemalloc,version_compile_os=debian-linux-gnu,innodb_version=5.6.36-82.1,protocol_version=10,version_comment=Debian\ 9.1 timed_mutexes=0,tmp_table_size=16777216,transaction_prealloc_size=4096,version_compile_machine="x86_64",version_ssl_library="YaSSL 2.4.2",wsrep_auto_increment_control=1,version_compile_os="debian-linux-gnu",wsrep_causal_reads=0,thread_stack=196608,tx_read_only=0,unique_checks=1,userstat=0,version="10.1.26-MariaDB-0+deb9u1",version_comment="Debian 9.1",wsrep_certify_nonpk=1,wait_timeout=28800,wsrep_convert_lock_to_trx=0,wsrep_debug=0,transaction_alloc_block_size=8192,version_malloc_library="system jemalloc" 1513542659000000000
> mysql_variables,wsrep_patch_version=wsrep_25.19,server=127.0.0.1:3306,version=10.1.26-MariaDB-0+deb9u1,version_compile_machine=x86_64,version_malloc_library=system\ jemalloc,version_ssl_library=YaSSL\ 2.4.2,innodb_version=5.6.36-82.1,protocol_version=10,version_comment=Debian\ 9.1,version_compile_os=debian-linux-gnu wsrep_sync_wait=0 1513542659000000000
* Plugin: inputs.mysql, Collection 1

[etiennecarriere]

Same issue as #2910

[Allineer]

@etiennecarriere, nop. In my case, no privileges to read tables data.