Open axlroden opened 5 years ago
Hi
I have successfully gotten my userparameters to work on my first test database host.
But Zabbix server is not happy with the results. Zabbix Server/Client 4.2
Discover seems to be missing a data array in the json. Any idea what to do ?
discovery rule "HOSTNAME:cluster" became not supported: Cannot find the "data" array in the received JSON object.
Zabbix-agent -p info:
mysql.status [t|{"Aborted_clients":"22986","Aborted_connects":"98386","Binlog_snapshot_file":"mysql-bin.000724","Binlog_snapshot_position":"608820529","Binlog_cache_disk_use":"4109073","Binlog_cache_use":"13946135","Binlog_stmt_cache_disk_use":"0","Binlog_stmt_cache_use":"364","Bytes_received":"189069784675","Bytes_sent":"1424033604535","Com_admin_commands":"1009032","Com_assign_to_keycache":"0","Com_alter_db":"0","Com_alter_db_upgrade":"0","Com_alter_event":"0","Com_alter_function":"0","Com_alter_procedure":"0","Com_alter_server":"0","Com_alter_table":"140","Com_alter_tablespace":"0","Com_alter_user":"0","Com_analyze":"0","Com_begin":"10203026","Com_binlog":"0","Com_call_procedure":"0","Com_change_db":"17486775","Com_change_master":"0","Com_check":"0","Com_checksum":"0","Com_commit":"1536647","Com_create_compression_dictionary":"0","Com_create_db":"1","Com_create_event":"0","Com_create_function":"0","Com_create_index":"0","Com_create_procedure":"0","Com_create_server":"0","Com_create_table":"91","Com_create_trigger":"0","Com_create_udf":"0","Com_create_user":"7","Com_create_view":"0","Com_dealloc_sql":"0","Com_delete":"10377","Com_delete_multi":"0","Com_do":"2","Com_drop_compression_dictionary":"0","Com_drop_db":"0","Com_drop_event":"0","Com_drop_function":"0","Com_drop_index":"0","Com_drop_procedure":"0","Com_drop_server":"0","Com_drop_table":"91","Com_drop_trigger":"0","Com_drop_user":"2","Com_drop_view":"0","Com_empty_query":"0","Com_execute_sql":"0","Com_flush":"11","Com_get_diagnostics":"0","Com_grant":"6","Com_ha_close":"0","Com_ha_open":"0","Com_ha_read":"0","Com_help":"0","Com_insert":"3661200","Com_insert_select":"0","Com_install_plugin":"0","Com_kill":"0","Com_load":"0","Com_lock_tables":"0","Com_lock_tables_for_backup":"0","Com_lock_binlog_for_backup":"0","Com_optimize":"0","Com_preload_keys":"0","Com_prepare_sql":"0","Com_purge":"0","Com_purge_before_date":"0","Com_purge_archived":"0","Com_purge_archived_before_date":"0","Com_release_savepoint":"0","Com_rename_table":"0","Com_rename_user":"0","Com_repair":"0","Com_replace":"0","Com_replace_select":"0","Com_reset":"0","Com_resignal":"0","Com_revoke":"2","Com_revoke_all":"0","Com_rollback":"9636","Com_rollback_to_savepoint":"0","Com_savepoint":"0","Com_select":"211343623","Com_set_option":"30572679","Com_signal":"0","Com_show_binlog_events":"0","Com_show_binlogs":"0","Com_show_charsets":"32","Com_show_client_statistics":"0","Com_show_collations":"9","Com_show_create_db":"0","Com_show_create_event":"0","Com_show_create_func":"0","Com_show_create_proc":"0","Com_show_create_table":"43","Com_show_create_trigger":"0","Com_show_databases":"25","Com_show_engine_logs":"0","Com_show_engine_mutex":"0","Com_show_engine_status":"0","Com_show_events":"0","Com_show_errors":"0","Com_show_fields":"16626","Com_show_function_code":"0","Com_show_function_status":"8","Com_show_grants":"0","Com_show_index_statistics":"0","Com_show_keys":"13","Com_show_master_status":"0","Com_show_open_tables":"0","Com_show_plugins":"7","Com_show_privileges":"9","Com_show_procedure_code":"0","Com_show_procedure_status":"8","Com_show_processlist":"0","Com_show_profile":"0","Com_show_profiles":"0","Com_show_relaylog_events":"0","Com_show_slave_hosts":"0","Com_show_slave_status":"9","Com_show_slave_status_nolock":"0","Com_show_status":"10165640","Com_show_storage_engines":"9","Com_show_table_statistics":"0","Com_show_table_status":"36","Com_show_tables":"5932","Com_show_thread_statistics":"0","Com_show_triggers":"0","Com_show_user_statistics":"0","Com_show_variables":"944451","Com_show_warnings":"47","Com_slave_start":"0","Com_slave_stop":"0","Com_stmt_close":"7779902","Com_stmt_execute":"7778034","Com_stmt_fetch":"0","Com_stmt_prepare":"7779914","Com_stmt_reprepare":"0","Com_stmt_reset":"0","Com_stmt_send_long_data":"0","Com_truncate":"2","Com_uninstall_plugin":"0","Com_unlock_binlog":"0","Com_unlock_tables":"0","Com_update":"17683967","Com_update_multi":"238269","Com_xa_commit":"0","Com_xa_end":"0","Com_xa_prepare":"0","Com_xa_recover":"0","Com_xa_rollback":"0","Com_xa_start":"0","Compression":"OFF","Connection_errors_accept":"0","Connection_errors_internal":"0","Connection_errors_max_connections":"0","Connection_errors_peer_address":"0","Connection_errors_select":"0","Connection_errors_tcpwrap":"0","Connections":"30032188","Created_tmp_disk_tables":"3476721","Created_tmp_files":"331879","Created_tmp_tables":"16780890","Delayed_errors":"0","Delayed_insert_threads":"0","Delayed_writes":"0","Flush_commands":"1","Handler_commit":"477754753","Handler_delete":"255673","Handler_discover":"0","Handler_external_lock":"573861190","Handler_mrr_init":"0","Handler_prepare":"85453612","Handler_read_first":"18187777","Handler_read_key":"13831228615","Handler_read_last":"309782","Handler_read_next":"645572431689","Handler_read_prev":"144096339565","Handler_read_rnd":"8358618355","Handler_read_rnd_next":"51460965641","Handler_rollback":"646474","Handler_savepoint":"0","Handler_savepoint_rollback":"0","Handler_update":"7504204749","Handler_write":"5574770319","Innodb_buffer_pool_dump_status":"not","Innodb_buffer_pool_load_status":"not","Innodb_background_log_sync":"3470410","Innodb_buffer_pool_pages_data":"628301","Innodb_buffer_pool_bytes_data":"10294083584","Innodb_buffer_pool_pages_dirty":"16959","Innodb_buffer_pool_bytes_dirty":"277856256","Innodb_buffer_pool_pages_flushed":"395440994","Innodb_buffer_pool_pages_LRU_flushed":"0","Innodb_buffer_pool_pages_free":"9050","Innodb_buffer_pool_pages_made_not_young":"7907137","Innodb_buffer_pool_pages_made_young":"12453392","Innodb_buffer_pool_pages_misc":"83537","Innodb_buffer_pool_pages_old":"231768","Innodb_buffer_pool_pages_total":"720888","Innodb_buffer_pool_read_ahead_rnd":"0","Innodb_buffer_pool_read_ahead":"43021","Innodb_buffer_pool_read_ahead_evicted":"0","Innodb_buffer_pool_read_requests":"2925944168661","Innodb_buffer_pool_reads":"1451929","Innodb_buffer_pool_wait_free":"0","Innodb_buffer_pool_write_requests":"16752319976","Innodb_checkpoint_age":"81209409","Innodb_checkpoint_max_age":"434154333","Innodb_data_fsyncs":"51365677","Innodb_data_pending_fsyncs":"0","Innodb_data_pending_reads":"0","Innodb_data_pending_writes":"0","Innodb_data_read":"28590035456","Innodb_data_reads":"1745405","Innodb_data_writes":"428106099","Innodb_data_written":"13818019688960","Innodb_dblwr_pages_written":"395441011","Innodb_dblwr_writes":"11624938","Innodb_deadlocks":"20506","Innodb_have_atomic_builtins":"ON","Innodb_history_list_length":"224","Innodb_ibuf_discarded_delete_marks":"0","Innodb_ibuf_discarded_deletes":"0","Innodb_ibuf_discarded_inserts":"0","Innodb_ibuf_free_list":"1284","Innodb_ibuf_merged_delete_marks":"56461","Innodb_ibuf_merged_deletes":"1304","Innodb_ibuf_merged_inserts":"254631","Innodb_ibuf_merges":"281048","Innodb_ibuf_segment_size":"1286","Innodb_ibuf_size":"1","Innodb_log_waits":"0","Innodb_log_write_requests":"1693177362","Innodb_log_writes":"17214862","Innodb_lsn_current":"26077438102386","Innodb_lsn_flushed":"26077438102386","Innodb_lsn_last_checkpoint":"26077356892977","Innodb_master_thread_active_loops":"3180260","Innodb_master_thread_idle_loops":"290151","Innodb_max_trx_id":"8584530662","Innodb_mem_adaptive_hash":"1536321568","Innodb_mem_dictionary":"52425026","Innodb_mem_total":"12295602176","Innodb_mutex_os_waits":"23758085","Innodb_mutex_spin_rounds":"8910098717","Innodb_mutex_spin_waits":"8601008712","Innodb_oldest_view_low_limit_trx_id":"8584527401","Innodb_os_log_fsyncs":"17672237","Innodb_os_log_pending_fsyncs":"0","Innodb_os_log_pending_writes":"0","Innodb_os_log_written":"859971696640","Innodb_page_size":"16384","Innodb_pages_created":"198961","Innodb_pages_read":"1744992","Innodb_pages_written":"395441011","Innodb_purge_trx_id":"8584527404","Innodb_purge_undo_no":"0","Innodb_row_lock_current_waits":"3","Innodb_current_row_locks":"18446744073709538649","Innodb_row_lock_time":"1274298502","Innodb_row_lock_time_avg":"1655","Innodb_row_lock_time_max":"51969","Innodb_row_lock_waits":"769860","Innodb_rows_deleted":"255671","Innodb_rows_inserted":"3665497","Innodb_rows_read":"845351933624","Innodb_rows_updated":"6961412114","Innodb_num_open_files":"504","Innodb_read_views_memory":"2824","Innodb_descriptors_memory":"8000","Innodb_s_lock_os_waits":"1468991","Innodb_s_lock_spin_rounds":"142768765","Innodb_s_lock_spin_waits":"132676163","Innodb_truncated_status_writes":"0","Innodb_available_undo_logs":"128","Innodb_x_lock_os_waits":"2404238","Innodb_x_lock_spin_rounds":"1008704994","Innodb_x_lock_spin_waits":"27701348","Innodb_secondary_index_triggered_cluster_reads":"633115367289","Innodb_secondary_index_triggered_cluster_reads_avoided":"0","Innodb_buffered_aio_submitted":"43021","Innodb_scan_pages_contiguous":"0","Innodb_scan_pages_disjointed":"0","Innodb_scan_pages_total_seek_distance":"0","Innodb_scan_data_size":"0","Innodb_scan_deleted_recs_size":"0","Key_blocks_not_flushed":"0","Key_blocks_unused":"26648","Key_blocks_used":"395","Key_read_requests":"90684062","Key_reads":"146","Key_write_requests":"57801092","Key_writes":"14","Last_query_cost":"0.000000","Last_query_partial_plans":"0","Max_statement_time_exceeded":"0","Max_statement_time_set":"0","Max_statement_time_set_failed":"0","Max_used_connections":"51","Not_flushed_delayed_rows":"0","Open_files":"69","Open_streams":"0","Open_table_definitions":"564","Open_tables":"927","Opened_files":"14253563","Opened_table_definitions":"805","Opened_tables":"1078","Performance_schema_accounts_lost":"0","Performance_schema_cond_classes_lost":"0","Performance_schema_cond_instances_lost":"0","Performance_schema_digest_lost":"0","Performance_schema_file_classes_lost":"0","Performance_schema_file_handles_lost":"0","Performance_schema_file_instances_lost":"0","Performance_schema_hosts_lost":"0","Performance_schema_locker_lost":"0","Performance_schema_mutex_classes_lost":"0","Performance_schema_mutex_instances_lost":"0","Performance_schema_rwlock_classes_lost":"0","Performance_schema_rwlock_instances_lost":"0","Performance_schema_session_connect_attrs_lost":"0","Performance_schema_socket_classes_lost":"0","Performance_schema_socket_instances_lost":"0","Performance_schema_stage_classes_lost":"0","Performance_schema_statement_classes_lost":"0","Performance_schema_table_handles_lost":"0","Performance_schema_table_instances_lost":"0","Performance_schema_thread_classes_lost":"0","Performance_schema_thread_instances_lost":"0","Performance_schema_users_lost":"0","Prepared_stmt_count":"0","Qcache_free_blocks":"0","Qcache_free_memory":"0","Qcache_hits":"0","Qcache_inserts":"0","Qcache_lowmem_prunes":"0","Qcache_not_cached":"0","Qcache_queries_in_cache":"0","Qcache_total_blocks":"0","Queries":"350254914","Questions":"312432498","Rsa_public_key":"","Select_full_join":"99342","Select_full_range_join":"4287","Select_range":"1401781","Select_range_check":"0","Select_scan":"29589722","Slave_heartbeat_period":"0.000","Slave_last_heartbeat":"","Slave_open_temp_tables":"0","Slave_received_heartbeats":"0","Slave_retried_transactions":"0","Slave_running":"OFF","Slow_launch_threads":"0","Slow_queries":"51926","Sort_merge_passes":"157312","Sort_range":"8766045","Sort_rows":"3235866981","Sort_scan":"10024712","Ssl_accept_renegotiates":"0","Ssl_accepts":"119","Ssl_callback_cache_hits":"0","Ssl_cipher":"","Ssl_cipher_list":"","Ssl_client_connects":"0","Ssl_connect_renegotiates":"0","Ssl_ctx_verify_depth":"18446744073709551615","Ssl_ctx_verify_mode":"5","Ssl_default_timeout":"0","Ssl_finished_accepts":"119","Ssl_finished_connects":"0","Ssl_server_not_after":"","Ssl_server_not_before":"","Ssl_session_cache_hits":"0","Ssl_session_cache_misses":"39","Ssl_session_cache_mode":"SERVER","Ssl_session_cache_overflows":"0","Ssl_session_cache_size":"128","Ssl_session_cache_timeouts":"0","Ssl_sessions_reused":"0","Ssl_used_session_cache_entries":"0","Ssl_verify_depth":"0","Ssl_verify_mode":"0","Ssl_version":"","Table_locks_immediate":"286879455","Table_locks_waited":"0","Table_open_cache_hits":"294687825","Table_open_cache_misses":"1076","Table_open_cache_overflows":"0","Tc_log_max_pages_used":"0","Tc_log_page_size":"0","Tc_log_page_waits":"0","Threadpool_idle_threads":"0","Threadpool_threads":"0","Threads_cached":"32","Threads_connected":"19","Threads_created":"54","Threads_running":"4","Uptime":"3489204","Uptime_since_flush_status":"3489204","wsrep_local_state_uuid":"ebbf4aef-fc8c-11e1-0800-6e2554e31d31","wsrep_protocol_version":"9","wsrep_last_committed":"658086535","wsrep_replicated":"5261181","wsrep_replicated_bytes":"173655038408","wsrep_repl_keys":"2292890057","wsrep_repl_keys_bytes":"18472989592","wsrep_repl_data_bytes":"142318129412","wsrep_repl_other_bytes":"0","wsrep_received":"11319330","wsrep_received_bytes":"734833589241","wsrep_local_commits":"5235315","wsrep_local_cert_failures":"2797","wsrep_local_replays":"74","wsrep_local_send_queue":"0","wsrep_local_send_queue_max":"34","wsrep_local_send_queue_min":"0","wsrep_local_send_queue_avg":"0.001361","wsrep_local_recv_queue":"0","wsrep_local_recv_queue_max":"985","wsrep_local_recv_queue_min":"0","wsrep_local_recv_queue_avg":"0.301248","wsrep_local_cached_downto":"658039225","wsrep_flow_control_paused_ns":"832903458796","wsrep_flow_control_paused":"0.000239","wsrep_flow_control_sent":"319","wsrep_flow_control_recv":"804","wsrep_cert_deps_distance":"15.257749","wsrep_apply_oooe":"0.169250","wsrep_apply_oool":"0.002866","wsrep_apply_window":"1.243265","wsrep_commit_oooe":"0.000000","wsrep_commit_oool":"0.002812","wsrep_commit_window":"1.141685","wsrep_local_state":"4","wsrep_local_state_comment":"Synced","wsrep_cert_index_size":"19967","wsrep_cert_bucket_count":"256290","wsrep_gcache_pool_size":"3221226376","wsrep_causal_reads":"0","wsrep_cert_interval":"1.187255","wsrep_open_transactions":"0","wsrep_open_connections":"0","wsrep_incoming_addresses":"172.16.24.31:3306,172.16.25.31:3306,172.16.1.32:3306,172.16.1.30:3306,172.16.1.31:3306","wsrep_cluster_weight":"5","wsrep_desync_count":"0","wsrep_evs_delayed":"1859ffdd-db99-11e9-802f-ff6681ee15e2:tcp://172.16.25.31:4567:1","wsrep_evs_evict_list":"","wsrep_evs_repl_latency":"0.10066/0.118417/0.179771/0.0238917/24","wsrep_evs_state":"OPERATIONAL","wsrep_gcomm_uuid":"76e58b80-f166-11e9-a9a8-d73d1be8402f","wsrep_cluster_conf_id":"200","wsrep_cluster_size":"5","wsrep_cluster_state_uuid":"ebbf4aef-fc8c-11e1-0800-6e2554e31d31","wsrep_cluster_status":"Primary","wsrep_connected":"ON","wsrep_local_bf_aborts":"174409","wsrep_local_index":"3","wsrep_provider_name":"Galera","wsrep_provider_vendor":"Codership","wsrep_provider_version":"3.28(rf216443)","wsrep_ready":"ON"}] mysql.config [t|{"auto_increment_increment":"5","auto_increment_offset":"4","autocommit":"ON","automatic_sp_privileges":"ON","avoid_temporal_upgrade":"OFF","back_log":"150","basedir":"/usr/","big_tables":"OFF","bind_address":"*","binlog_cache_size":"32768","binlog_checksum":"CRC32","binlog_direct_non_transactional_updates":"OFF","binlog_error_action":"IGNORE_ERROR","binlog_format":"ROW","binlog_gtid_simple_recovery":"OFF","binlog_max_flush_queue_time":"0","binlog_order_commits":"ON","binlog_row_image":"FULL","binlog_rows_query_log_events":"OFF","binlog_stmt_cache_size":"32768","binlogging_impossible_mode":"IGNORE_ERROR","block_encryption_mode":"aes-128-ecb","bulk_insert_buffer_size":"8388608","character_set_client":"latin1","character_set_connection":"latin1","character_set_database":"latin1","character_set_filesystem":"binary","character_set_results":"latin1","character_set_server":"latin1","character_set_system":"utf8","character_sets_dir":"/usr/share/percona-xtradb-cluster/charsets/","collation_connection":"latin1_swedish_ci","collation_database":"latin1_swedish_ci","collation_server":"latin1_swedish_ci","completion_type":"NO_CHAIN","concurrent_insert":"AUTO","connect_timeout":"10","core_file":"OFF","csv_mode":"","datadir":"/var/lib/mysql/data/","date_format":"%Y-%m-%d","datetime_format":"%Y-%m-%d","default_storage_engine":"InnoDB","default_tmp_storage_engine":"InnoDB","default_week_format":"0","delay_key_write":"ON","delayed_insert_limit":"100","delayed_insert_timeout":"300","delayed_queue_size":"1000","disconnect_on_expired_password":"ON","div_precision_increment":"4","end_markers_in_json":"OFF","enforce_gtid_consistency":"OFF","enforce_storage_engine":"","eq_range_index_dive_limit":"10","event_scheduler":"OFF","expand_fast_index_creation":"OFF","expire_logs_days":"3","explicit_defaults_for_timestamp":"OFF","extra_max_connections":"1","extra_port":"0","flush":"OFF","flush_time":"0","foreign_key_checks":"ON","ft_boolean_syntax":"+","ft_max_word_len":"84","ft_min_word_len":"4","ft_query_expansion_limit":"20","ft_stopword_file":"(built-in)","general_log":"OFF","general_log_file":"/var/lib/mysql/data/dkdb01.log","group_concat_max_len":"1024","gtid_deployment_step":"OFF","gtid_executed":"","gtid_mode":"OFF","gtid_owned":"","gtid_purged":"","have_backup_locks":"YES","have_backup_safe_binlog_info":"YES","have_compress":"YES","have_crypt":"YES","have_dynamic_loading":"YES","have_elliptic_curve_crypto":"YES","have_geometry":"YES","have_openssl":"YES","have_profiling":"YES","have_query_cache":"YES","have_rtree_keys":"YES","have_snapshot_cloning":"YES","have_ssl":"YES","have_statement_timeout":"YES","have_symlink":"DISABLED","have_tlsv1_2":"YES","host_cache_size":"628","hostname":"dkdb01.danmagi.com","ignore_builtin_innodb":"OFF","ignore_db_dirs":"","init_connect":"","init_file":"","init_slave":"","innodb_adaptive_flushing":"ON","innodb_adaptive_flushing_lwm":"10","innodb_adaptive_hash_index":"ON","innodb_adaptive_hash_index_partitions":"1","innodb_adaptive_max_sleep_delay":"150000","innodb_additional_mem_pool_size":"8388608","innodb_api_bk_commit_interval":"5","innodb_api_disable_rowlock":"OFF","innodb_api_enable_binlog":"OFF","innodb_api_enable_mdl":"OFF","innodb_api_trx_level":"0","innodb_autoextend_increment":"64","innodb_autoinc_lock_mode":"2","innodb_buffer_pool_dump_at_shutdown":"OFF","innodb_buffer_pool_dump_now":"OFF","innodb_buffer_pool_filename":"ib_buffer_pool","innodb_buffer_pool_instances":"8","innodb_buffer_pool_load_abort":"OFF","innodb_buffer_pool_load_at_startup":"OFF","innodb_buffer_pool_load_now":"OFF","innodb_buffer_pool_populate":"OFF","innodb_buffer_pool_size":"11811160064","innodb_change_buffer_max_size":"25","innodb_change_buffering":"all","innodb_checksum_algorithm":"innodb","innodb_checksums":"ON","innodb_cleaner_lsn_age_factor":"high_checkpoint","innodb_cmp_per_index_enabled":"OFF","innodb_commit_concurrency":"0","innodb_compressed_columns_threshold":"96","innodb_compressed_columns_zip_level":"6","innodb_compression_failure_threshold_pct":"5","innodb_compression_level":"6","innodb_compression_pad_pct_max":"50","innodb_concurrency_tickets":"5000","innodb_corrupt_table_action":"assert","innodb_data_file_path":"ibdata1:12M:autoextend","innodb_data_home_dir":"","innodb_disable_sort_file_cache":"OFF","innodb_disallow_writes":"OFF","innodb_doublewrite":"ON","innodb_empty_free_list_algorithm":"backoff","innodb_fast_shutdown":"1","innodb_file_format":"Antelope","innodb_file_format_check":"ON","innodb_file_format_max":"Antelope","innodb_file_per_table":"ON","innodb_flush_log_at_timeout":"1","innodb_flush_log_at_trx_commit":"1","innodb_flush_method":"O_DIRECT","innodb_flush_neighbors":"1","innodb_flushing_avg_loops":"30","innodb_force_load_corrupted":"OFF","innodb_force_recovery":"0","innodb_foreground_preflush":"exponential_backoff","innodb_ft_aux_table":"","innodb_ft_cache_size":"8000000","innodb_ft_enable_diag_print":"OFF","innodb_ft_enable_stopword":"ON","innodb_ft_max_token_size":"84","innodb_ft_min_token_size":"3","innodb_ft_num_word_optimize":"2000","innodb_ft_result_cache_limit":"2000000000","innodb_ft_server_stopword_table":"","innodb_ft_sort_pll_degree":"2","innodb_ft_total_cache_size":"640000000","innodb_ft_user_stopword_table":"","innodb_io_capacity":"200","innodb_io_capacity_max":"2000","innodb_kill_idle_transaction":"0","innodb_large_prefix":"OFF","innodb_lock_wait_timeout":"50","innodb_locks_unsafe_for_binlog":"ON","innodb_log_arch_dir":"./","innodb_log_arch_expire_sec":"0","innodb_log_archive":"OFF","innodb_log_block_size":"512","innodb_log_buffer_size":"8388608","innodb_log_checksum_algorithm":"innodb","innodb_log_compressed_pages":"ON","innodb_log_file_size":"268435456","innodb_log_files_in_group":"2","innodb_log_group_home_dir":"./","innodb_lru_scan_depth":"1024","innodb_max_bitmap_file_size":"104857600","innodb_max_changed_pages":"1000000","innodb_max_dirty_pages_pct":"75","innodb_max_dirty_pages_pct_lwm":"0","innodb_max_purge_lag":"0","innodb_max_purge_lag_delay":"0","innodb_mirrored_log_groups":"1","innodb_monitor_disable":"","innodb_monitor_enable":"","innodb_monitor_reset":"","innodb_monitor_reset_all":"","innodb_numa_interleave":"OFF","innodb_old_blocks_pct":"37","innodb_old_blocks_time":"1000","innodb_online_alter_log_max_size":"134217728","innodb_open_files":"4096","innodb_optimize_fulltext_only":"OFF","innodb_page_size":"16384","innodb_print_all_deadlocks":"OFF","innodb_print_lock_wait_timeout_info":"OFF","innodb_purge_batch_size":"300","innodb_purge_threads":"1","innodb_random_read_ahead":"OFF","innodb_read_ahead_threshold":"56","innodb_read_io_threads":"4","innodb_read_only":"OFF","innodb_replication_delay":"0","innodb_rollback_on_timeout":"OFF","innodb_rollback_segments":"128","innodb_sched_priority_cleaner":"19","innodb_show_locks_held":"10","innodb_show_verbose_locks":"0","innodb_sort_buffer_size":"1048576","innodb_spin_wait_delay":"6","innodb_stats_auto_recalc":"ON","innodb_stats_include_delete_marked":"OFF","innodb_stats_method":"nulls_equal","innodb_stats_on_metadata":"OFF","innodb_stats_persistent":"ON","innodb_stats_persistent_sample_pages":"20","innodb_stats_sample_pages":"8","innodb_stats_transient_sample_pages":"8","innodb_status_output":"OFF","innodb_status_output_locks":"OFF","innodb_strict_mode":"OFF","innodb_support_xa":"ON","innodb_sync_array_size":"1","innodb_sync_spin_loops":"30","innodb_table_locks":"ON","innodb_thread_concurrency":"0","innodb_thread_sleep_delay":"10000","innodb_tmpdir":"","innodb_track_changed_pages":"OFF","innodb_undo_directory":".","innodb_undo_logs":"128","innodb_undo_tablespaces":"0","innodb_use_atomic_writes":"OFF","innodb_use_global_flush_log_at_trx_commit":"ON","innodb_use_native_aio":"ON","innodb_use_sys_malloc":"ON","innodb_version":"5.6.41-84.1","innodb_write_io_threads":"4","interactive_timeout":"28800","join_buffer_size":"262144","keep_files_on_create":"OFF","key_buffer_size":"33554432","key_cache_age_threshold":"300","key_cache_block_size":"1024","key_cache_division_limit":"100","kill_idle_transaction":"0","large_files_support":"ON","large_page_size":"0","large_pages":"OFF","lc_messages":"en_US","lc_messages_dir":"/usr/share/percona-xtradb-cluster/","lc_time_names":"en_US","license":"GPL","local_infile":"ON","lock_wait_timeout":"31536000","locked_in_memory":"OFF","log_bin":"ON","log_bin_basename":"/var/lib/mysql/data/mysql-bin","log_bin_index":"/var/lib/mysql/data/mysql-bin.index","log_bin_trust_function_creators":"OFF","log_bin_use_v1_row_events":"OFF","log_error":"/var/lib/mysql/log/mysql-error.log","log_output":"FILE","log_queries_not_using_indexes":"OFF","log_slave_updates":"ON","log_slow_admin_statements":"OFF","log_slow_filter":"","log_slow_rate_limit":"1","log_slow_rate_type":"session","log_slow_slave_statements":"OFF","log_slow_sp_statements":"ON","log_slow_verbosity":"query_plan","log_throttle_queries_not_using_indexes":"0","log_warnings":"1","log_warnings_suppress":"","long_query_time":"10.000000","low_priority_updates":"OFF","lower_case_file_system":"OFF","lower_case_table_names":"0","master_info_repository":"FILE","master_verify_checksum":"OFF","max_allowed_packet":"16777216","max_binlog_cache_size":"18446744073709547520","max_binlog_files":"0","max_binlog_size":"1073741824","max_binlog_stmt_cache_size":"18446744073709547520","max_connect_errors":"1000000","max_connections":"500","max_delayed_threads":"20","max_digest_length":"1024","max_error_count":"64","max_heap_table_size":"33554432","max_insert_delayed_threads":"20","max_join_size":"18446744073709551615","max_length_for_sort_data":"1024","max_prepared_stmt_count":"16382","max_relay_log_size":"0","max_seeks_for_key":"18446744073709551615","max_slowlog_files":"0","max_slowlog_size":"0","max_sort_length":"1024","max_sp_recursion_depth":"0","max_statement_time":"0","max_tmp_tables":"32","max_user_connections":"0","max_write_lock_count":"18446744073709551615","metadata_locks_cache_size":"1024","metadata_locks_hash_instances":"8","min_examined_row_limit":"0","multi_range_count":"256","myisam_data_pointer_size":"6","myisam_max_sort_file_size":"9223372036853727232","myisam_mmap_size":"18446744073709551615","myisam_recover_options":"BACKUP,FORCE","myisam_repair_threads":"1","myisam_sort_buffer_size":"8388608","myisam_stats_method":"nulls_unequal","myisam_use_mmap":"OFF","net_buffer_length":"16384","net_read_timeout":"30","net_retry_count":"10","net_write_timeout":"60","new":"OFF","old":"OFF","old_alter_table":"OFF","old_passwords":"0","open_files_limit":"65535","optimizer_prune_level":"1","optimizer_search_depth":"62","optimizer_switch":"index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on","optimizer_trace":"enabled=off,one_line=off","optimizer_trace_features":"greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on","optimizer_trace_limit":"1","optimizer_trace_max_mem_size":"16384","optimizer_trace_offset":"-1","performance_schema":"ON","performance_schema_accounts_size":"100","performance_schema_digests_size":"10000","performance_schema_events_stages_history_long_size":"10000","performance_schema_events_stages_history_size":"10","performance_schema_events_statements_history_long_size":"10000","performance_schema_events_statements_history_size":"10","performance_schema_events_waits_history_long_size":"10000","performance_schema_events_waits_history_size":"10","performance_schema_hosts_size":"100","performance_schema_max_cond_classes":"80","performance_schema_max_cond_instances":"10292","performance_schema_max_digest_length":"1024","performance_schema_max_file_classes":"50","performance_schema_max_file_handles":"32768","performance_schema_max_file_instances":"100824","performance_schema_max_mutex_classes":"200","performance_schema_max_mutex_instances":"45960","performance_schema_max_rwlock_classes":"40","performance_schema_max_rwlock_instances":"25976","performance_schema_max_socket_classes":"10","performance_schema_max_socket_instances":"1020","performance_schema_max_stage_classes":"150","performance_schema_max_statement_classes":"181","performance_schema_max_table_handles":"8192","performance_schema_max_table_instances":"12500","performance_schema_max_thread_classes":"50","performance_schema_max_thread_instances":"1100","performance_schema_session_connect_attrs_size":"512","performance_schema_setup_actors_size":"100","performance_schema_setup_objects_size":"100","performance_schema_users_size":"100","pid_file":"/var/lib/mysql/data/mysql.pid","plugin_dir":"/usr/lib64/mysql/plugin/","port":"3306","preload_buffer_size":"32768","profiling":"OFF","profiling_history_size":"15","protocol_version":"10","proxy_protocol_networks":"","query_alloc_block_size":"8192","query_cache_limit":"1048576","query_cache_min_res_unit":"4096","query_cache_size":"0","query_cache_strip_comments":"OFF","query_cache_type":"OFF","query_cache_wlock_invalidate":"OFF","query_prealloc_size":"8192","range_alloc_block_size":"4096","read_buffer_size":"131072","read_only":"OFF","read_rnd_buffer_size":"262144","relay_log":"","relay_log_basename":"","relay_log_index":"","relay_log_info_file":"relay-log.info","relay_log_info_repository":"FILE","relay_log_purge":"ON","relay_log_recovery":"OFF","relay_log_space_limit":"0","report_host":"","report_password":"","report_port":"3306","report_user":"","rpl_stop_slave_timeout":"31536000","secure_auth":"ON","secure_file_priv":"/var/lib/mysql-files/","server_id":"1","server_id_bits":"32","server_uuid":"547345de-f167-11e9-83ce-005056ab49be","sha256_password_private_key_path":"private_key.pem","sha256_password_public_key_path":"public_key.pem","show_old_temporals":"OFF","simplified_binlog_gtid_recovery":"OFF","skip_external_locking":"ON","skip_name_resolve":"OFF","skip_networking":"OFF","skip_show_database":"OFF","slave_allow_batching":"OFF","slave_checkpoint_group":"512","slave_checkpoint_period":"300","slave_compressed_protocol":"OFF","slave_exec_mode":"STRICT","slave_load_tmpdir":"/tmp","slave_max_allowed_packet":"1073741824","slave_net_timeout":"3600","slave_parallel_workers":"0","slave_pending_jobs_size_max":"16777216","slave_rows_search_algorithms":"TABLE_SCAN,INDEX_SCAN","slave_skip_errors":"OFF","slave_sql_verify_checksum":"ON","slave_transaction_retries":"10","slave_type_conversions":"","slow_launch_time":"2","slow_query_log":"ON","slow_query_log_always_write_time":"10.000000","slow_query_log_file":"/var/lib/mysql/log/mysql-slow.log","slow_query_log_timestamp_always":"OFF","slow_query_log_timestamp_precision":"second","slow_query_log_use_global_control":"","socket":"/var/lib/mysql/mysql.sock","sort_buffer_size":"262144","sql_auto_is_null":"OFF","sql_big_selects":"ON","sql_buffer_result":"OFF","sql_log_bin":"ON","sql_log_off":"OFF","sql_mode":"NO_ENGINE_SUBSTITUTION","sql_notes":"ON","sql_quote_show_create":"ON","sql_safe_updates":"OFF","sql_select_limit":"18446744073709551615","sql_slave_skip_counter":"0","sql_warnings":"OFF","ssl_ca":"/var/lib/mysql/certs/danmagi.com.ca.crt","ssl_capath":"","ssl_cert":"/var/lib/mysql/certs/dkdb01.danmagi.com.crt","ssl_cipher":"","ssl_crl":"","ssl_crlpath":"","ssl_key":"/var/lib/mysql/certs/dkdb01.danmagi.com.key","storage_engine":"InnoDB","stored_program_cache":"256","super_read_only":"OFF","sync_binlog":"1","sync_frm":"ON","sync_master_info":"10000","sync_relay_log":"10000","sync_relay_log_info":"10000","system_time_zone":"UTC","table_definition_cache":"4096","table_open_cache":"4096","table_open_cache_instances":"1","thread_cache_size":"50","thread_concurrency":"10","thread_handling":"one-thread-per-connection","thread_pool_high_prio_mode":"transactions","thread_pool_high_prio_tickets":"4294967295","thread_pool_idle_timeout":"60","thread_pool_max_threads":"100000","thread_pool_oversubscribe":"3","thread_pool_size":"4","thread_pool_stall_limit":"500","thread_stack":"262144","thread_statistics":"OFF","time_format":"%H:%i:%s","time_zone":"SYSTEM","timed_mutexes":"OFF","tls_version":"TLSv1.1,TLSv1.2","tmp_table_size":"33554432","tmpdir":"/tmp","transaction_alloc_block_size":"8192","transaction_prealloc_size":"4096","tx_isolation":"REPEATABLE-READ","tx_read_only":"OFF","unique_checks":"ON","updatable_views_with_limit":"YES","userstat":"OFF","version":"5.6.41-84.1-56-log","version_comment":"Percona","version_compile_machine":"x86_64","version_compile_os":"Linux","version_suffix":"-56-log","wait_timeout":"28800","wsrep_OSU_method":"TOI","wsrep_RSU_commit_timeout":"5000","wsrep_auto_increment_control":"ON","wsrep_causal_reads":"OFF","wsrep_certification_rules":"strict","wsrep_certify_nonPK":"ON","wsrep_cluster_address":"gcomm://172.16.24.31,172.16.1.31,172.16.1.32,172.16.25.31","wsrep_cluster_name":"danmagi","wsrep_convert_LOCK_to_trx":"OFF","wsrep_data_home_dir":"/var/lib/mysql/data/","wsrep_dbug_option":"","wsrep_debug":"OFF","wsrep_desync":"OFF","wsrep_dirty_reads":"OFF","wsrep_drupal_282555_workaround":"OFF","wsrep_forced_binlog_format":"NONE","wsrep_load_data_splitting":"ON","wsrep_log_conflicts":"OFF","wsrep_max_ws_rows":"0","wsrep_max_ws_size":"2147483647","wsrep_mysql_replication_bundle":"0","wsrep_node_address":"","wsrep_node_incoming_address":"AUTO","wsrep_node_name":"dkdb1","wsrep_notify_cmd":"","wsrep_preordered":"OFF","wsrep_provider":"/usr/lib64/libgalera_smm.so","wsrep_provider_options":"base_dir","wsrep_recover":"OFF","wsrep_reject_queries":"NONE","wsrep_replicate_myisam":"OFF","wsrep_restart_slave":"OFF","wsrep_retry_autocommit":"1","wsrep_slave_FK_checks":"ON","wsrep_slave_UK_checks":"OFF","wsrep_slave_threads":"2","wsrep_sst_auth":"********","wsrep_sst_donor":"","wsrep_sst_donor_rejects_queries":"OFF","wsrep_sst_method":"xtrabackup-v2","wsrep_sst_receive_address":"AUTO","wsrep_start_position":"00000000-0000-0000-0000-000000000000:-1","wsrep_sync_wait":"0"}] mysql.slave [t|] mysql.innodb_active_transactions [t|3] mysql.ping [t|1] mysql.version [t|mysql Ver 14.14 Distrib 5.6.41-84.1, for Linux (x86_64) using 6.2]
From what I can see, i'm getting data in graphs though.. so not sure what is not actually working.
Hi
I have successfully gotten my userparameters to work on my first test database host.
But Zabbix server is not happy with the results. Zabbix Server/Client 4.2
Discover seems to be missing a data array in the json. Any idea what to do ?
discovery rule "HOSTNAME:cluster" became not supported: Cannot find the "data" array in the received JSON object.
Zabbix-agent -p info: