Skip to content

Instantly share code, notes, and snippets.

@axper
Created June 23, 2017 08:27
Show Gist options
  • Save axper/b3cb999ab571fe314fcfc3d93d46702e to your computer and use it in GitHub Desktop.
Save axper/b3cb999ab571fe314fcfc3d93d46702e to your computer and use it in GitHub Desktop.
netdata mysql debug
BEGIN mysql_local.net 0
SET Bytes_received = 9384614
SET Bytes_sent = 207033427
END
BEGIN mysql_local.queries 0
SET Queries = 53915
SET Questions = 53492
SET Slow_queries = 0
END
BEGIN mysql_local.handlers 0
SET Handler_commit = 15267
SET Handler_delete = 0
SET Handler_prepare = 0
SET Handler_read_first = 8124
SET Handler_read_key = 42917
SET Handler_read_next = 1607136
SET Handler_read_prev = 0
SET Handler_read_rnd = 3
SET Handler_read_rnd_next = 2485815561
SET Handler_rollback = 0
SET Handler_savepoint = 0
SET Handler_savepoint_rollback = 0
SET Handler_update = 33
SET Handler_write = 456681
END
BEGIN mysql_local.table_locks 0
SET Table_locks_immediate = 1316
SET Table_locks_waited = 0
END
BEGIN mysql_local.join_issues 0
SET Select_full_join = 339
SET Select_full_range_join = 0
SET Select_range = 109
SET Select_range_check = 0
SET Select_scan = 13567
END
BEGIN mysql_local.sort_issues 0
SET Sort_merge_passes = 0
SET Sort_range = 56
SET Sort_scan = 1342
END
BEGIN mysql_local.tmp 0
SET Created_tmp_disk_tables = 3446
SET Created_tmp_files = 6
SET Created_tmp_tables = 8227
END
BEGIN mysql_local.connections 0
SET Connections = 107
SET Aborted_connects = 2
END
BEGIN mysql_local.connection_errors 0
SET Connection_errors_accept = 0
SET Connection_errors_internal = 0
SET Connection_errors_max_connections = 0
SET Connection_errors_peer_address = 0
SET Connection_errors_select = 0
SET Connection_errors_tcpwrap = 0
END
BEGIN mysql_local.binlog_cache 0
SET Binlog_cache_disk_use = 0
SET Binlog_cache_use = 0
END
BEGIN mysql_local.binlog_stmt_cache 0
SET Binlog_stmt_cache_disk_use = 0
SET Binlog_stmt_cache_use = 0
END
BEGIN mysql_local.threads 0
SET Threads_connected = 34
SET Threads_created = 43
SET Threads_cached = 5
SET Threads_running = 2
END
BEGIN mysql_local.thread_cache_misses 0
SET Thread_cache_misses = 4019
END
BEGIN mysql_local.innodb_io 0
SET Innodb_data_read = 533942063616
SET Innodb_data_written = 12448256
END
BEGIN mysql_local.innodb_io_ops 0
SET Innodb_data_reads = 32589319
SET Innodb_data_writes = 633
SET Innodb_data_fsyncs = 279
END
BEGIN mysql_local.innodb_io_pending_ops 0
SET Innodb_data_pending_reads = 0
SET Innodb_data_pending_writes = 0
SET Innodb_data_pending_fsyncs = 0
END
BEGIN mysql_local.innodb_log 0
SET Innodb_log_waits = 0
SET Innodb_log_write_requests = 81
SET Innodb_log_writes = 114
END
BEGIN mysql_local.innodb_os_log 0
SET Innodb_os_log_fsyncs = 168
SET Innodb_os_log_pending_fsyncs = 0
SET Innodb_os_log_pending_writes = 0
END
BEGIN mysql_local.innodb_os_log_io 0
SET Innodb_os_log_written = 132608
END
BEGIN mysql_local.innodb_cur_row_lock 0
SET Innodb_row_lock_current_waits = 0
END
BEGIN mysql_local.innodb_rows 0
SET Innodb_rows_inserted = 18269
SET Innodb_rows_read = 2486551881
SET Innodb_rows_updated = 33
SET Innodb_rows_deleted = 0
END
BEGIN mysql_local.innodb_buffer_pool_pages 0
SET Innodb_buffer_pool_pages_data = 8158
SET Innodb_buffer_pool_pages_dirty = 0
SET Innodb_buffer_pool_pages_free = 0
SET Innodb_buffer_pool_pages_flushed = 424
SET Innodb_buffer_pool_pages_misc = 33
SET Innodb_buffer_pool_pages_total = 8191
END
BEGIN mysql_local.innodb_buffer_pool_bytes 0
SET Innodb_buffer_pool_bytes_data = 133660672
SET Innodb_buffer_pool_bytes_dirty = 0
END
BEGIN mysql_local.innodb_buffer_pool_read_ahead 0
SET Innodb_buffer_pool_read_ahead = 21083127
SET Innodb_buffer_pool_read_ahead_evicted = 126
SET Innodb_buffer_pool_read_ahead_rnd = 0
END
BEGIN mysql_local.innodb_buffer_pool_reqs 0
SET Innodb_buffer_pool_read_requests = 359648295
SET Innodb_buffer_pool_write_requests = 69952
END
BEGIN mysql_local.innodb_buffer_pool_ops 0
SET Innodb_buffer_pool_reads = 11506086
SET Innodb_buffer_pool_wait_free = 0
END
BEGIN mysql_local.qcache_ops 0
SET Qcache_hits = 0
SET Qcache_lowmem_prunes = 0
SET Qcache_inserts = 0
SET Qcache_not_cached = 21167
END
BEGIN mysql_local.qcache 0
SET Qcache_queries_in_cache = 0
END
BEGIN mysql_local.qcache_freemem 0
SET Qcache_free_memory = 1031832
END
BEGIN mysql_local.qcache_memblocks 0
SET Qcache_free_blocks = 1
SET Qcache_total_blocks = 1
END
BEGIN mysql_local.key_blocks 0
SET Key_blocks_unused = 6695
SET Key_blocks_used = 3
SET Key_blocks_not_flushed = 0
END
BEGIN mysql_local.key_requests 0
SET Key_read_requests = 6
SET Key_write_requests = 0
END
BEGIN mysql_local.key_disk_ops 0
SET Key_reads = 3
SET Key_writes = 0
END
BEGIN mysql_local.files 0
SET Open_files = 16
END
BEGIN mysql_local.files_rate 0
SET Opened_files = 3304
END
BEGIN netdata.plugin_pythond_mysql_local 0
SET run_time = 19
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment