vulpes

vulpes

MySQL metrics parser.

vulpes provides praser/jsonize function for below metrics.

• SHOW GLOBAL STATUS
• SHOW GLOBAL VARIABLES
• SHOW ENGINE INNODB STATUS
• SHOW SLAVE STATUS

You can use vulpes as formatter of your monitoring tools' output

$ mysql -h127.0.0.1 -umysql -p -e "show global status" | ./vulpes global_status
Enter password:
{"aborted_clients":1,"aborted_connects":5,"binlog_cache_disk_use":0,"binlog_cache_use":0,"binlog_stmt_cache_disk_use":0,"binlog_stmt_cache_use":0,"bytes_received":781526,"bytes_sent":21496471,"com_admin_commands":3,"com_alter_db":0,"com_alter_db_upgrade":0,"com_alter_event":0,"com_alter_function":0,"com_alter_instance":0,"com_alter_procedure":0,"com_alter_server":0,"com_alter_table":0,"com_alter_tablespace":0,"com_alter_user":0,"com_analyze":0,"com_assign_to_keycache":0,"com_begin":1,"com_binlog":0,"com_call_procedure":0,"com_change_db":1234,"com_change_master":0,"com_change_repl_filter":0,"com_check":0,"com_checksum":0,"com_commit":0,"com_create_db":0,"com_create_event":0,"com_create_function":0,"com_create_index":0,"com_create_procedure":0,"com_create_server":0,"com_create_table":0,"com_create_trigger":0,"com_create_udf":0,"com_create_user":0,"com_create_view":0,"com_dealloc_sql":0,"com_delete":0,"com_delete_multi":0,"com_do":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":0,"com_drop_trigger":0,"com_drop_user":0,"com_drop_view":0,"com_empty_query":0,"com_execute_sql":0,"com_explain_other":0,"com_flush":4,"com_get_diagnostics":0,"com_grant":0,"com_group_replication_start":0,"com_group_replication_stop":0,"com_ha_close":0,"com_ha_open":0,"com_ha_read":0,"com_help":0,"com_insert":0,"com_insert_select":0,"com_install_plugin":0,"com_kill":0,"com_load":0,"com_lock_tables":0,"com_optimize":0,"com_preload_keys":0,"com_prepare_sql":0,"com_purge":0,"com_purge_before_date":0,"com_release_savepoint":6,"com_rename_table":0,"com_rename_user":0,"com_repair":0,"com_replace":0,"com_replace_select":0,"com_reset":1,"com_resignal":0,"com_revoke":0,"com_revoke_all":0,"com_rollback":0,"com_rollback_to_savepoint":1228,"com_savepoint":6,"com_select":2544,"com_set_option":6158,"com_show_binlog_events":0,"com_show_binlogs":0,"com_show_charsets":0,"com_show_collations":0,"com_show_create_db":6,"com_show_create_event":0,"com_show_create_func":0,"com_show_create_proc":0,"com_show_create_table":1230,"com_show_create_trigger":0,"com_show_create_user":0,"com_show_databases":1,"com_show_engine_logs":0,"com_show_engine_mutex":0,"com_show_engine_status":8,"com_show_errors":0,"com_show_events":6,"com_show_fields":2460,"com_show_function_code":0,"com_show_function_status":0,"com_show_grants":0,"com_show_keys":0,"com_show_master_status":3,"com_show_open_tables":0,"com_show_plugins":0,"com_show_privileges":0,"com_show_procedure_code":0,"com_show_procedure_status":0,"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":6,"com_show_status":6,"com_show_storage_engines":0,"com_show_table_status":1230,"com_show_tables":7,"com_show_triggers":1228,"com_show_variables":2,"com_show_warnings":0,"com_shutdown":0,"com_signal":0,"com_slave_start":0,"com_slave_stop":0,"com_stmt_close":51,"com_stmt_execute":51,"com_stmt_fetch":0,"com_stmt_prepare":51,"com_stmt_reprepare":0,"com_stmt_reset":0,"com_stmt_send_long_data":0,"com_truncate":0,"com_uninstall_plugin":0,"com_unlock_tables":2,"com_update":0,"com_update_multi":0,"com_xa_commit":0,"com_xa_end":0,"com_xa_prepare":0,"com_xa_recover":0,"com_xa_rollback":0,"com_xa_start":0,"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":38,"created_tmp_disk_tables":3696,"created_tmp_files":6,"created_tmp_tables":4944,"delayed_errors":0,"delayed_insert_threads":0,"delayed_writes":0,"flush_commands":4,"handler_commit":1276,"handler_delete":0,"handler_discover":0,"handler_external_lock":2803,"handler_mrr_init":0,"handler_prepare":0,"handler_read_first":4932,"handler_read_key":4979,"handler_read_last":0,"handler_read_next":5884,"handler_read_prev":0,"handler_read_rnd":0,"handler_read_rnd_next":280852,"handler_rollback":1,"handler_savepoint":6,"handler_savepoint_rollback":1228,"handler_update":0,"handler_write":7580,"innodb_available_undo_logs":128,"innodb_buffer_pool_bytes_data":67158016,"innodb_buffer_pool_bytes_dirty":0,"innodb_buffer_pool_pages_data":4099,"innodb_buffer_pool_pages_dirty":0,"innodb_buffer_pool_pages_flushed":76,"innodb_buffer_pool_pages_free":4068,"innodb_buffer_pool_pages_misc":25,"innodb_buffer_pool_pages_total":8192,"innodb_buffer_pool_read_ahead":207,"innodb_buffer_pool_read_ahead_evicted":0,"innodb_buffer_pool_read_ahead_rnd":0,"innodb_buffer_pool_read_requests":171855,"innodb_buffer_pool_reads":3843,"innodb_buffer_pool_wait_free":0,"innodb_buffer_pool_write_requests":73555,"innodb_data_fsyncs":15,"innodb_data_pending_fsyncs":0,"innodb_data_pending_reads":0,"innodb_data_pending_writes":0,"innodb_data_read":67719680,"innodb_data_reads":6578,"innodb_data_writes":100,"innodb_data_written":1299456,"innodb_dblwr_pages_written":3,"innodb_dblwr_writes":2,"innodb_log_waits":0,"innodb_log_write_requests":0,"innodb_log_writes":7,"innodb_num_open_files":1222,"innodb_os_log_fsyncs":10,"innodb_os_log_pending_fsyncs":0,"innodb_os_log_pending_writes":0,"innodb_os_log_written":3584,"innodb_page_size":16384,"innodb_pages_created":50,"innodb_pages_read":4049,"innodb_pages_written":76,"innodb_row_lock_current_waits":0,"innodb_row_lock_time":0,"innodb_row_lock_time_avg":0,"innodb_row_lock_time_max":0,"innodb_row_lock_waits":0,"innodb_rows_deleted":0,"innodb_rows_inserted":30242,"innodb_rows_read":270199,"innodb_rows_updated":0,"innodb_truncated_status_writes":0,"key_blocks_not_flushed":0,"key_blocks_unused":6696,"key_blocks_used":3,"key_read_requests":14,"key_reads":5,"key_write_requests":0,"key_writes":0,"locked_connects":0,"max_execution_time_exceeded":0,"max_execution_time_set":0,"max_execution_time_set_failed":0,"max_used_connections":4,"not_flushed_delayed_rows":0,"ongoing_anonymous_transaction_count":0,"open_files":27,"open_streams":0,"open_table_definitions":1232,"open_tables":131,"opened_files":1439,"opened_table_definitions":1341,"opened_tables":1348,"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_index_stat_lost":0,"performance_schema_locker_lost":0,"performance_schema_memory_classes_lost":0,"performance_schema_metadata_lock_lost":0,"performance_schema_mutex_classes_lost":0,"performance_schema_mutex_instances_lost":0,"performance_schema_nested_statement_lost":0,"performance_schema_prepared_statements_lost":0,"performance_schema_program_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_table_lock_stat_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":1,"qcache_free_memory":1031832,"qcache_hits":0,"qcache_inserts":0,"qcache_lowmem_prunes":0,"qcache_not_cached":2544,"qcache_queries_in_cache":0,"qcache_total_blocks":1,"queries":17513,"questions":17409,"select_full_join":0,"select_full_range_join":0,"select_range":1,"select_range_check":0,"select_scan":6168,"slave_open_temp_tables":0,"slow_launch_threads":0,"slow_queries":0,"sort_merge_passes":0,"sort_range":0,"sort_rows":0,"sort_scan":2,"ssl_accept_renegotiates":0,"ssl_accepts":26,"ssl_callback_cache_hits":0,"ssl_cipher":"ECDHE-RSA-AES128-GCM-SHA256","ssl_cipher_list":"ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DHE-DSS-AES256-GCM-SHA384:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DHE-RSA-AES256-GCM-SHA384","ssl_client_connects":0,"ssl_connect_renegotiates":0,"ssl_ctx_verify_depth":18446744073709552000,"ssl_ctx_verify_mode":5,"ssl_default_timeout":7200,"ssl_finished_accepts":26,"ssl_finished_connects":0,"ssl_session_cache_hits":0,"ssl_session_cache_misses":20,"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":18446744073709552000,"ssl_verify_mode":5,"ssl_version":"TLSv1.2","table_locks_immediate":122,"table_locks_waited":0,"table_open_cache_hits":5023,"table_open_cache_misses":1348,"table_open_cache_overflows":1107,"tc_log_max_pages_used":0,"tc_log_page_size":0,"tc_log_page_waits":0,"threads_cached":2,"threads_connected":2,"threads_created":4,"threads_running":2,"uptime":4891,"uptime_since_flush_status":4891}

$ mysql -h127.0.0.1 -umysql -p -e "show global variables" | ./vulpes global_variables
Enter password:
{"auto_generate_certs":"ON","auto_increment_increment":1,"auto_increment_offset":1,"autocommit":"ON","automatic_sp_privileges":"ON","avoid_temporal_upgrade":"OFF","back_log":80,"basedir":"/usr/","big_tables":"OFF","bind_address":"*","binlog_cache_size":32768,"binlog_checksum":"CRC32","binlog_direct_non_transactional_updates":"OFF","binlog_error_action":"ABORT_SERVER","binlog_format":"MIXED","binlog_group_commit_sync_delay":0,"binlog_group_commit_sync_no_delay_count":0,"binlog_gtid_simple_recovery":"ON","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,"binlog_transaction_dependency_history_size":25000,"binlog_transaction_dependency_tracking":"COMMIT_ORDER","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/mysql/charsets/","check_proxy_users":"OFF","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","datadir":"/var/lib/mysql/","date_format":"%Y-%m-%d","default_authentication_plugin":"mysql_native_password","default_password_lifetime":0,"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","eq_range_index_dive_limit":200,"event_scheduler":"OFF","expire_logs_days":0,"explicit_defaults_for_timestamp":"OFF","flush":"OFF","flush_time":0,"foreign_key_checks":"ON","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/5460d1f69e95.log","group_concat_max_len":1024,"gtid_executed_compression_period":1000,"gtid_mode":"OFF","have_compress":"YES","have_crypt":"YES","have_dynamic_loading":"YES","have_geometry":"YES","have_openssl":"YES","have_profiling":"YES","have_query_cache":"YES","have_rtree_keys":"YES","have_ssl":"YES","have_statement_timeout":"YES","have_symlink":"DISABLED","host_cache_size":279,"hostname":"5460d1f69e95","ignore_builtin_innodb":"OFF","innodb_adaptive_flushing":"ON","innodb_adaptive_flushing_lwm":10,"innodb_adaptive_hash_index":"ON","innodb_adaptive_hash_index_parts":8,"innodb_adaptive_max_sleep_delay":150000,"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":1,"innodb_buffer_pool_chunk_size":134217728,"innodb_buffer_pool_dump_at_shutdown":"ON","innodb_buffer_pool_dump_now":"OFF","innodb_buffer_pool_dump_pct":25,"innodb_buffer_pool_filename":"ib_buffer_pool","innodb_buffer_pool_instances":1,"innodb_buffer_pool_load_abort":"OFF","innodb_buffer_pool_load_at_startup":"ON","innodb_buffer_pool_load_now":"OFF","innodb_buffer_pool_size":134217728,"innodb_change_buffer_max_size":25,"innodb_change_buffering":"all","innodb_checksum_algorithm":"crc32","innodb_checksums":"ON","innodb_cmp_per_index_enabled":"OFF","innodb_commit_concurrency":0,"innodb_compression_failure_threshold_pct":5,"innodb_compression_level":6,"innodb_compression_pad_pct_max":50,"innodb_concurrency_tickets":5000,"innodb_data_file_path":"ibdata1:12M:autoextend","innodb_deadlock_detect":"ON","innodb_default_row_format":"dynamic","innodb_disable_sort_file_cache":"OFF","innodb_doublewrite":"ON","innodb_fast_shutdown":1,"innodb_file_format":"Barracuda","innodb_file_format_check":"ON","innodb_file_format_max":"Barracuda","innodb_file_per_table":"ON","innodb_fill_factor":100,"innodb_flush_log_at_timeout":1,"innodb_flush_log_at_trx_commit":1,"innodb_flush_neighbors":1,"innodb_flush_sync":"ON","innodb_flushing_avg_loops":30,"innodb_force_load_corrupted":"OFF","innodb_force_recovery":0,"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_sort_pll_degree":2,"innodb_ft_total_cache_size":640000000,"innodb_io_capacity":200,"innodb_io_capacity_max":2000,"innodb_large_prefix":"ON","innodb_lock_wait_timeout":50,"innodb_locks_unsafe_for_binlog":"OFF","innodb_log_buffer_size":16777216,"innodb_log_checksums":"ON","innodb_log_compressed_pages":"ON","innodb_log_file_size":50331648,"innodb_log_files_in_group":2,"innodb_log_group_home_dir":"./","innodb_log_write_ahead_size":8192,"innodb_lru_scan_depth":1024,"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_max_undo_log_size":1073741824,"innodb_numa_interleave":"OFF","innodb_old_blocks_pct":37,"innodb_old_blocks_time":1000,"innodb_online_alter_log_max_size":134217728,"innodb_open_files":2000,"innodb_optimize_fulltext_only":"OFF","innodb_page_cleaners":1,"innodb_page_size":16384,"innodb_print_all_deadlocks":"OFF","innodb_purge_batch_size":300,"innodb_purge_rseg_truncate_frequency":128,"innodb_purge_threads":4,"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_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":"ON","innodb_support_xa":"ON","innodb_sync_array_size":1,"innodb_sync_spin_loops":30,"innodb_table_locks":"ON","innodb_temp_data_file_path":"ibtmp1:12M:autoextend","innodb_thread_concurrency":0,"innodb_thread_sleep_delay":10000,"innodb_undo_directory":"./","innodb_undo_log_truncate":"OFF","innodb_undo_logs":128,"innodb_undo_tablespaces":0,"innodb_use_native_aio":"ON","innodb_version":"5.7.29","innodb_write_io_threads":4,"interactive_timeout":28800,"internal_tmp_disk_storage_engine":"InnoDB","join_buffer_size":262144,"keep_files_on_create":"OFF","key_buffer_size":8388608,"key_cache_age_threshold":300,"key_cache_block_size":1024,"key_cache_division_limit":100,"keyring_operations":"ON","large_files_support":"ON","large_page_size":0,"large_pages":"OFF","lc_messages":"en_US","lc_messages_dir":"/usr/share/mysql/","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/log/mysql/bin-log","log_bin_index":"/var/log/mysql/bin-log.index","log_bin_trust_function_creators":"OFF","log_bin_use_v1_row_events":"OFF","log_builtin_as_identified_by_password":"OFF","log_error":"stderr","log_error_verbosity":3,"log_output":"FILE","log_queries_not_using_indexes":"OFF","log_slave_updates":"OFF","log_slow_admin_statements":"OFF","log_slow_slave_statements":"OFF","log_statements_unsafe_for_binlog":"ON","log_syslog":"OFF","log_syslog_facility":"daemon","log_syslog_include_pid":"ON","log_throttle_queries_not_using_indexes":0,"log_timestamps":"UTC","log_warnings":2,"long_query_time":10,"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":4194304,"max_binlog_cache_size":18446744073709548000,"max_binlog_size":1073741824,"max_binlog_stmt_cache_size":18446744073709548000,"max_connect_errors":100,"max_connections":151,"max_delayed_threads":20,"max_digest_length":1024,"max_error_count":64,"max_execution_time":0,"max_heap_table_size":16777216,"max_insert_delayed_threads":20,"max_join_size":18446744073709552000,"max_length_for_sort_data":1024,"max_points_in_geometry":65536,"max_prepared_stmt_count":16382,"max_relay_log_size":0,"max_seeks_for_key":18446744073709552000,"max_sort_length":1024,"max_sp_recursion_depth":0,"max_tmp_tables":32,"max_user_connections":0,"max_write_lock_count":18446744073709552000,"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":9223372036853727000,"myisam_mmap_size":18446744073709552000,"myisam_recover_options":"OFF","myisam_repair_threads":1,"myisam_sort_buffer_size":8388608,"myisam_stats_method":"nulls_unequal","myisam_use_mmap":"OFF","mysql_native_password_proxy_users":"OFF","net_buffer_length":16384,"net_read_timeout":30,"net_retry_count":10,"net_write_timeout":60,"new":"OFF","ngram_token_size":2,"offline_mode":"OFF","old":"OFF","old_alter_table":"OFF","old_passwords":0,"open_files_limit":1048576,"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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=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,"parser_max_mem_size":18446744073709552000,"performance_schema":"ON","performance_schema_accounts_size":-1,"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_transactions_history_long_size":10000,"performance_schema_events_transactions_history_size":10,"performance_schema_events_waits_history_long_size":10000,"performance_schema_events_waits_history_size":10,"performance_schema_hosts_size":-1,"performance_schema_max_cond_classes":80,"performance_schema_max_cond_instances":-1,"performance_schema_max_digest_length":1024,"performance_schema_max_file_classes":80,"performance_schema_max_file_handles":32768,"performance_schema_max_file_instances":-1,"performance_schema_max_index_stat":-1,"performance_schema_max_memory_classes":320,"performance_schema_max_metadata_locks":-1,"performance_schema_max_mutex_classes":210,"performance_schema_max_mutex_instances":-1,"performance_schema_max_prepared_statements_instances":-1,"performance_schema_max_program_instances":-1,"performance_schema_max_rwlock_classes":50,"performance_schema_max_rwlock_instances":-1,"performance_schema_max_socket_classes":10,"performance_schema_max_socket_instances":-1,"performance_schema_max_sql_text_length":1024,"performance_schema_max_stage_classes":150,"performance_schema_max_statement_classes":193,"performance_schema_max_statement_stack":10,"performance_schema_max_table_handles":-1,"performance_schema_max_table_instances":-1,"performance_schema_max_table_lock_stat":-1,"performance_schema_max_thread_classes":50,"performance_schema_max_thread_instances":-1,"performance_schema_session_connect_attrs_size":512,"performance_schema_setup_actors_size":-1,"performance_schema_setup_objects_size":-1,"performance_schema_users_size":-1,"pid_file":"/var/run/mysqld/mysqld.pid","plugin_dir":"/usr/lib/mysql/plugin/","port":3306,"preload_buffer_size":32768,"profiling":"OFF","profiling_history_size":15,"protocol_version":10,"query_alloc_block_size":8192,"query_cache_limit":1048576,"query_cache_min_res_unit":4096,"query_cache_size":1048576,"query_cache_type":"OFF","query_cache_wlock_invalidate":"OFF","query_prealloc_size":8192,"range_alloc_block_size":4096,"range_optimizer_max_mem_size":8388608,"rbr_exec_mode":"STRICT","read_buffer_size":131072,"read_only":"OFF","read_rnd_buffer_size":262144,"relay_log_basename":"/var/lib/mysql/5460d1f69e95-relay-bin","relay_log_index":"/var/lib/mysql/5460d1f69e95-relay-bin.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_port":3306,"require_secure_transport":"OFF","rpl_stop_slave_timeout":31536000,"secure_auth":"ON","secure_file_priv":"/var/lib/mysql-files/","server_id":1,"server_id_bits":32,"server_uuid":"f8b8d2e3-7c1c-11ea-a3c4-0242ac120002","session_track_gtids":"OFF","session_track_schema":"ON","session_track_state_change":"OFF","session_track_system_variables":"time_zone,autocommit,character_set_client,character_set_results,character_set_connection","session_track_transaction_info":"OFF","sha256_password_auto_generate_rsa_keys":"ON","sha256_password_private_key_path":"private_key.pem","sha256_password_proxy_users":"OFF","sha256_password_public_key_path":"public_key.pem","show_compatibility_56":"OFF","show_create_table_verbosity":"OFF","show_old_temporals":"OFF","skip_external_locking":"ON","skip_name_resolve":"ON","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":60,"slave_parallel_type":"DATABASE","slave_parallel_workers":0,"slave_pending_jobs_size_max":16777216,"slave_preserve_commit_order":"OFF","slave_rows_search_algorithms":"TABLE_SCAN,INDEX_SCAN","slave_skip_errors":"OFF","slave_sql_verify_checksum":"ON","slave_transaction_retries":10,"slow_launch_time":2,"slow_query_log":"OFF","slow_query_log_file":"/var/lib/mysql/5460d1f69e95-slow.log","socket":"/var/run/mysqld/mysqld.sock","sort_buffer_size":262144,"sql_auto_is_null":"OFF","sql_big_selects":"ON","sql_buffer_result":"OFF","sql_log_off":"OFF","sql_mode":"ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION","sql_notes":"ON","sql_quote_show_create":"ON","sql_safe_updates":"OFF","sql_select_limit":18446744073709552000,"sql_slave_skip_counter":0,"sql_warnings":"OFF","ssl_ca":"ca.pem","ssl_cert":"server-cert.pem","ssl_key":"server-key.pem","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":"JST","table_definition_cache":1400,"table_open_cache":2000,"table_open_cache_instances":16,"thread_cache_size":9,"thread_handling":"one-thread-per-connection","thread_stack":262144,"time_format":"%H:%i:%s","time_zone":"SYSTEM","tls_version":"TLSv1,TLSv1.1,TLSv1.2","tmp_table_size":16777216,"tmpdir":"/tmp","transaction_alloc_block_size":8192,"transaction_isolation":"REPEATABLE-READ","transaction_prealloc_size":4096,"transaction_read_only":"OFF","transaction_write_set_extraction":"OFF","tx_isolation":"REPEATABLE-READ","tx_read_only":"OFF","unique_checks":"ON","updatable_views_with_limit":"YES","version":"5.7.29-log","version_compile_machine":"x86_64","version_compile_os":"Linux","wait_timeout":28800}

$ mysql -h127.0.0.1 -umysql -p -e "show engine innodb status\G" | ./vulpes innodb_status
Enter password:
{"background_active_thread_loops":32,"background_idle_thread_loops":2985,"background_shutdown_thread_loops":0,"background_thread_log_flush_and_writes":3017,"buffer_pool_database_pages":4099,"buffer_pool_dictionary_memory_allocated":10876495,"buffer_pool_free_buffers":4068,"buffer_pool_io_cur":0,"buffer_pool_io_sum":0,"buffer_pool_io_unzip_cur":0,"buffer_pool_io_unzip_sum":0,"buffer_pool_lru_len":4099,"buffer_pool_modified_db_pages":0,"buffer_pool_old_database_pages":1533,"buffer_pool_page_evicted_wo_access_per_sec":0,"buffer_pool_page_random_reads_ahead_per_sec":0,"buffer_pool_page_reads_ahead_per_sec":0,"buffer_pool_pages_created":50,"buffer_pool_pages_creates_per_sec":0,"buffer_pool_pages_made_young":0,"buffer_pool_pages_made_young_per_sec":0,"buffer_pool_pages_not_made_young":0,"buffer_pool_pages_not_made_youngs_per_sec":0,"buffer_pool_pages_read":4049,"buffer_pool_pages_reads_per_sec":0,"buffer_pool_pages_writes_per_sec":0,"buffer_pool_pages_written":76,"buffer_pool_pending_reads":0,"buffer_pool_size":8192,"buffer_pool_total_large_memory_allocated":137428992,"buffer_pool_unzip_lru_len":0,"calculated_from_last_secs":9,"current_transactions":1,"hash_searches_per_sec":0,"history_list_length":29,"insert_buffer_discarded_delete_marks":0,"insert_buffer_discarded_deletes":0,"insert_buffer_discarded_inserts":0,"insert_buffer_free_list_len":0,"insert_buffer_merged_delete_marks":0,"insert_buffer_merged_deletes":0,"insert_buffer_merged_inserts":0,"insert_buffer_merges":0,"insert_buffer_seg_size":2,"insert_buffer_size":1,"insert_buffer_threads_num":1,"log_flushed_up_to":68438842,"log_iops":0,"log_ios_done":16,"log_last_checkpoint_at":68438833,"log_pending_checkpoint_writes":0,"log_pending_log_flushes":0,"log_sequence_number":68438842,"log_threads_num":1,"non_hash_searches_per_sec":0,"os_file_bytes_per_read":0,"os_file_fsyncs":15,"os_file_fsyncs_per_sec":0,"os_file_reads":6578,"os_file_reads_per_sec":0,"os_file_writes":100,"os_file_writes_per_sec":0,"os_waits_sync_array_reservations":17,"os_waits_sync_array_signals":15,"pending_buf_pool_flushes":0,"pending_log_flushes":0,"purge_done_for_trx_num":41117,"purge_done_for_undo_num":0,"queries_in_queue":0,"queries_inside_innodb":0,"read_threads_num":4,"read_views_inside_innodb":0,"rows_deleted":0,"rows_deleted_per_sec":0,"rows_inserted":30242,"rows_inserted_per_sec":0,"rows_read":270199,"rows_read_per_sec":0,"rows_updated":0,"rows_updated_per_sec":0,"rw_excl_os_waits":0,"rw_excl_spin_rounds":0,"rw_excl_spin_waits":0,"rw_shared_os_waits":7,"rw_shared_spin_rounds":16,"rw_shared_spin_waits":0,"rw_sx_os_waits":0,"rw_sx_spin_rounds":0,"rw_sx_spin_waits":0,"trx_id_counter":45494,"write_threads_num":4}

$ mysql -h127.0.0.1 -umysql -p -P13306 -e "show slave status\G" | ./vulpes slave_status
Enter password:
{"auto_position":0,"channel_name":"","connect_retry":60,"exec_master_log_pos":154,"executed_gtid_set":"","last_errno":0,"last_error":"","last_io_errno":0,"last_io_error":"","last_io_error_timestamp":"","last_sql_errno":0,"last_sql_error":"","last_sql_error_timestamp":"","master_bind":"","master_host":"db","master_info_file":"/var/lib/mysql/master.info","master_log_file":"bin-log.000002","master_port":3306,"master_retry_count":86400,"master_server_id":1,"master_ssl_allowed":"No","master_ssl_ca_file":"","master_ssl_ca_path":"","master_ssl_cert":"","master_ssl_cipher":"","master_ssl_crl":"","master_ssl_crlpath":"","master_ssl_key":"","master_ssl_verify_server_cert":"No","master_tls_version":"","master_user":"mysql","master_uuid":"f8b8d2e3-7c1c-11ea-a3c4-0242ac120002","read_master_log_pos":154,"relay_log_file":"29dc768b9532-relay-bin.000004","relay_log_pos":318,"relay_log_space":532,"relay_master_log_file":"bin-log.000002","replicate_do_db":"","replicate_do_table":"","replicate_ignore_db":"","replicate_ignore_server_ids":"","replicate_ignore_table":"","replicate_rewrite_db":"","replicate_wild_do_table":"","replicate_wild_ignore_table":"","retrieved_gtid_set":"","seconds_behind_master":0,"skip_counter":0,"slave_io_running":"Yes","slave_io_state":"Waiting for master to send event","slave_sql_running":"Yes","slave_sql_running_state":"Slave has read all relay log; waiting for more updates","sql_delay":0,"sql_remaining_delay":"NULL","until_condition":"None","until_log_file":"","until_log_pos":0}
relay_master_log_fi