netdata-mysql

gistfile1.txt

2017-08-08 08:48:15:  INFO: Using python v2
2017-08-08 08:48:15:  INFO: YAML output is ordered
2017-08-08 08:48:15: python.d INFO: reading configuration file: /usr/libexec/netdata/plugins.d/../../../../etc/netdata/python.d.conf
2017-08-08 08:48:15: python.d INFO: MODULES_DIR='/usr/libexec/netdata/python.d/', CONFIG_DIR='/usr/libexec/netdata/plugins.d/../../../../etc/netdata/', UPDATE_EVERY=1, ONLY_MODULES=['mysql']
2017-08-08 08:48:15: python.d DEBUG: mysql: loading module configuration: '/usr/libexec/netdata/plugins.d/../../../../etc/netdata/python.d/mysql.conf'
2017-08-08 08:48:15: python.d DEBUG: mysql: reading configuration
2017-08-08 08:48:15: python.d DEBUG: mysql/local: job added
2017-08-08 08:48:15: python.d DEBUG: all job objects [<Service(local, initial daemon)>]
2017-08-08 08:48:15: python.d INFO: CHECKED OK: mysql_local
2017-08-08 08:48:15: python.d INFO: RENAMED: mysql_db-2 , from mysql_local
2017-08-08 08:48:15: python.d DEBUG: overridden job names: ['mysql_db-2']
2017-08-08 08:48:15: python.d DEBUG: all remaining job objects: [<Service(db-2, initial daemon)>]
CHART mysql_db-2.net '' 'mysql Bandwidth' kilobits/s bandwidth mysql.net area 10 10
DIMENSION Bytes_received in incremental 8 1024
DIMENSION Bytes_sent out incremental -8 1024
CHART mysql_db-2.queries '' 'mysql Queries' queries/s queries mysql.queries line 11 10
DIMENSION Queries queries incremental 1 1
DIMENSION Questions questions incremental 1 1
DIMENSION Slow_queries slow_queries incremental 1 1
CHART mysql_db-2.handlers '' 'mysql Handlers' handlers/s handlers mysql.handlers line 12 10
DIMENSION Handler_commit commit incremental 1 1
DIMENSION Handler_delete delete incremental 1 1
DIMENSION Handler_prepare prepare incremental 1 1
DIMENSION Handler_read_first read_first incremental 1 1
DIMENSION Handler_read_key read_key incremental 1 1
DIMENSION Handler_read_next read_next incremental 1 1
DIMENSION Handler_read_prev read_prev incremental 1 1
DIMENSION Handler_read_rnd read_rnd incremental 1 1
DIMENSION Handler_read_rnd_next read_rnd_next incremental 1 1
DIMENSION Handler_rollback rollback incremental 1 1
DIMENSION Handler_savepoint savepoint incremental 1 1
DIMENSION Handler_savepoint_rollback savepoint_rollback incremental 1 1
DIMENSION Handler_update update incremental 1 1
DIMENSION Handler_write write incremental 1 1
CHART mysql_db-2.table_locks '' 'mysql Tables Locks' locks/s locks mysql.table_locks line 13 10
DIMENSION Table_locks_immediate immediate incremental 1 1
DIMENSION Table_locks_waited waited incremental -1 1
CHART mysql_db-2.join_issues '' 'mysql Select Join Issues' joins/s issues mysql.join_issues line 14 10
DIMENSION Select_full_join full_join incremental 1 1
DIMENSION Select_full_range_join full_range_join incremental 1 1
DIMENSION Select_range range incremental 1 1
DIMENSION Select_range_check range_check incremental 1 1
DIMENSION Select_scan scan incremental 1 1
CHART mysql_db-2.sort_issues '' 'mysql Sort Issues' issues/s issues mysql.sort_issues line 15 10
DIMENSION Sort_merge_passes merge_passes incremental 1 1
DIMENSION Sort_range range incremental 1 1
DIMENSION Sort_scan scan incremental 1 1
CHART mysql_db-2.tmp '' 'mysql Tmp Operations' counter temporaries mysql.tmp line 16 10
DIMENSION Created_tmp_disk_tables disk_tables incremental 1 1
DIMENSION Created_tmp_files files incremental 1 1
DIMENSION Created_tmp_tables tables incremental 1 1
CHART mysql_db-2.connections '' 'mysql Connections' connections/s connections mysql.connections line 17 10
DIMENSION Connections all incremental 1 1
DIMENSION Aborted_connects aborted incremental 1 1
CHART mysql_db-2.connection_errors '' 'mysql Connection Errors' connections/s connections mysql.connection_errors line 18 10
DIMENSION Connection_errors_accept accept incremental 1 1
DIMENSION Connection_errors_internal internal incremental 1 1
DIMENSION Connection_errors_max_connections max incremental 1 1
DIMENSION Connection_errors_peer_address peer_addr incremental 1 1
DIMENSION Connection_errors_select select incremental 1 1
DIMENSION Connection_errors_tcpwrap tcpwrap incremental 1 1
CHART mysql_db-2.binlog_cache '' 'mysql Binlog Cache' transactions/s binlog mysql.binlog_cache line 19 10
DIMENSION Binlog_cache_disk_use disk incremental 1 1
DIMENSION Binlog_cache_use all incremental 1 1
CHART mysql_db-2.binlog_stmt_cache '' 'mysql Binlog Statement Cache' statements/s binlog mysql.binlog_stmt_cache line 20 10
DIMENSION Binlog_stmt_cache_disk_use disk incremental 1 1
DIMENSION Binlog_stmt_cache_use all incremental 1 1
CHART mysql_db-2.threads '' 'mysql Threads' threads threads mysql.threads line 21 10
DIMENSION Threads_connected connected absolute 1 1
DIMENSION Threads_created created incremental 1 1
DIMENSION Threads_cached cached absolute -1 1
DIMENSION Threads_running running absolute 1 1
CHART mysql_db-2.thread_cache_misses '' 'mysql Threads Cache Misses' misses threads mysql.thread_cache_misses area 22 10
DIMENSION Thread_cache_misses misses absolute 1 100
CHART mysql_db-2.innodb_io '' 'mysql InnoDB I/O Bandwidth' kilobytes/s innodb mysql.innodb_io area 23 10
DIMENSION Innodb_data_read read incremental 1 1024
DIMENSION Innodb_data_written write incremental -1 1024
CHART mysql_db-2.innodb_io_ops '' 'mysql InnoDB I/O Operations' operations/s innodb mysql.innodb_io_ops line 24 10
DIMENSION Innodb_data_reads reads incremental 1 1
DIMENSION Innodb_data_writes writes incremental -1 1
DIMENSION Innodb_data_fsyncs fsyncs incremental 1 1
CHART mysql_db-2.innodb_io_pending_ops '' 'mysql InnoDB Pending I/O Operations' operations innodb mysql.innodb_io_pending_ops line 25 10
DIMENSION Innodb_data_pending_reads reads absolute 1 1
DIMENSION Innodb_data_pending_writes writes absolute -1 1
DIMENSION Innodb_data_pending_fsyncs fsyncs absolute 1 1
CHART mysql_db-2.innodb_log '' 'mysql InnoDB Log Operations' operations/s innodb mysql.innodb_log line 26 10
DIMENSION Innodb_log_waits waits incremental 1 1
DIMENSION Innodb_log_write_requests write_requests incremental -1 1
DIMENSION Innodb_log_writes writes incremental -1 1
CHART mysql_db-2.innodb_os_log '' 'mysql InnoDB OS Log Operations' operations innodb mysql.innodb_os_log line 27 10
DIMENSION Innodb_os_log_fsyncs fsyncs incremental 1 1
DIMENSION Innodb_os_log_pending_fsyncs pending_fsyncs absolute 1 1
DIMENSION Innodb_os_log_pending_writes pending_writes absolute -1 1
CHART mysql_db-2.innodb_os_log_io '' 'mysql InnoDB OS Log Bandwidth' kilobytes/s innodb mysql.innodb_os_log_io area 28 10
DIMENSION Innodb_os_log_written write incremental -1 1024
CHART mysql_db-2.innodb_cur_row_lock '' 'mysql InnoDB Current Row Locks' operations innodb mysql.innodb_cur_row_lock area 29 10
DIMENSION Innodb_row_lock_current_waits current_waits absolute 1 1
CHART mysql_db-2.innodb_rows '' 'mysql InnoDB Row Operations' operations/s innodb mysql.innodb_rows area 30 10
DIMENSION Innodb_rows_inserted inserted incremental 1 1
DIMENSION Innodb_rows_read read incremental 1 1
DIMENSION Innodb_rows_updated updated incremental 1 1
DIMENSION Innodb_rows_deleted deleted incremental -1 1
CHART mysql_db-2.innodb_buffer_pool_pages '' 'mysql InnoDB Buffer Pool Pages' pages innodb mysql.innodb_buffer_pool_pages line 31 10
DIMENSION Innodb_buffer_pool_pages_data data absolute 1 1
DIMENSION Innodb_buffer_pool_pages_dirty dirty absolute -1 1
DIMENSION Innodb_buffer_pool_pages_free free absolute 1 1
DIMENSION Innodb_buffer_pool_pages_flushed flushed incremental -1 1
DIMENSION Innodb_buffer_pool_pages_misc misc absolute -1 1
DIMENSION Innodb_buffer_pool_pages_total total absolute 1 1
CHART mysql_db-2.innodb_buffer_pool_bytes '' 'mysql InnoDB Buffer Pool Bytes' MB innodb mysql.innodb_buffer_pool_bytes area 32 10
DIMENSION Innodb_buffer_pool_bytes_data data absolute 1 1048576
DIMENSION Innodb_buffer_pool_bytes_dirty dirty absolute -1 1048576
CHART mysql_db-2.innodb_buffer_pool_read_ahead '' 'mysql InnoDB Buffer Pool Read Ahead' operations/s innodb mysql.innodb_buffer_pool_read_ahead area 33 10
DIMENSION Innodb_buffer_pool_read_ahead all incremental 1 1
DIMENSION Innodb_buffer_pool_read_ahead_evicted evicted incremental -1 1
DIMENSION Innodb_buffer_pool_read_ahead_rnd random incremental 1 1
CHART mysql_db-2.innodb_buffer_pool_reqs '' 'mysql InnoDB Buffer Pool Requests' requests/s innodb mysql.innodb_buffer_pool_reqs area 34 10
DIMENSION Innodb_buffer_pool_read_requests reads incremental 1 1
DIMENSION Innodb_buffer_pool_write_requests writes incremental -1 1
CHART mysql_db-2.innodb_buffer_pool_ops '' 'mysql InnoDB Buffer Pool Operations' operations/s innodb mysql.innodb_buffer_pool_ops area 35 10
DIMENSION Innodb_buffer_pool_reads 'disk reads' incremental 1 1
DIMENSION Innodb_buffer_pool_wait_free 'wait free' incremental -1 1
CHART mysql_db-2.qcache_ops '' 'mysql QCache Operations' queries/s qcache mysql.qcache_ops line 36 10
DIMENSION Qcache_hits hits incremental 1 1
DIMENSION Qcache_lowmem_prunes 'lowmem prunes' incremental -1 1
DIMENSION Qcache_inserts inserts incremental 1 1
DIMENSION Qcache_not_cached 'not cached' incremental -1 1
CHART mysql_db-2.qcache '' 'mysql QCache Queries in Cache' queries qcache mysql.qcache line 37 10
DIMENSION Qcache_queries_in_cache queries absolute 1 1
CHART mysql_db-2.qcache_freemem '' 'mysql QCache Free Memory' MB qcache mysql.qcache_freemem area 38 10
DIMENSION Qcache_free_memory free absolute 1 1048576
CHART mysql_db-2.qcache_memblocks '' 'mysql QCache Memory Blocks' blocks qcache mysql.qcache_memblocks line 39 10
DIMENSION Qcache_free_blocks free absolute 1 1
DIMENSION Qcache_total_blocks total absolute 1 1
CHART mysql_db-2.key_blocks '' 'mysql MyISAM Key Cache Blocks' blocks myisam mysql.key_blocks line 40 10
DIMENSION Key_blocks_unused unused absolute 1 1
DIMENSION Key_blocks_used used absolute -1 1
DIMENSION Key_blocks_not_flushed 'not flushed' absolute 1 1
CHART mysql_db-2.key_requests '' 'mysql MyISAM Key Cache Requests' requests/s myisam mysql.key_requests area 41 10
DIMENSION Key_read_requests reads incremental 1 1
DIMENSION Key_write_requests writes incremental -1 1
CHART mysql_db-2.key_disk_ops '' 'mysql MyISAM Key Cache Disk Operations' operations/s myisam mysql.key_disk_ops area 42 10
DIMENSION Key_reads reads incremental 1 1
DIMENSION Key_writes writes incremental -1 1
CHART mysql_db-2.files '' 'mysql Open Files' files files mysql.files line 43 10
DIMENSION Open_files files absolute 1 1
CHART mysql_db-2.files_rate '' 'mysql Opened Files Rate' files/s files mysql.files_rate line 44 10
DIMENSION Opened_files files incremental 1 1
CHART mysql_db-2.slave_behind '' 'Slave Behind Seconds' seconds slave mysql.slave_behind line 45 10
DIMENSION Seconds_Behind_Master seconds absolute 1 1
CHART mysql_db-2.slave_status '' 'Slave Status' status slave mysql.slave_status line 46 10
DIMENSION Slave_SQL_Running sql_running absolute 1 1
DIMENSION Slave_IO_Running io_running absolute 1 1
2017-08-08 08:48:15: python.d DEBUG: created charts for mysql_db-2
2017-08-08 08:48:15: python.d DEBUG: mysql_db-2 starting data collection - update frequency: 1.0  retries allowed: 5
2017-08-08 08:48:15: python.d DEBUG: mysql_db-2 sleeping for 0.744993925095 secs to reach frequency of 1.0 secs, now: 1502182095.26  next: 1502182096.0  penalty: 0

CHART netdata.plugin_pythond_mysql_db-2 '' 'Execution time for mysql_db-2 plugin' 'milliseconds / run' python.d netdata.plugin_python area 145000 1
DIMENSION run_time 'run time' absolute 1 1

BEGIN mysql_db-2.net 0
SET Bytes_received = 14520866145
SET Bytes_sent = 20216839747
END 
BEGIN mysql_db-2.queries 0
SET Queries = 50853581
SET Questions = 15265466
SET Slow_queries = 0
END 
BEGIN mysql_db-2.handlers 0
SET Handler_commit = 44796148
SET Handler_delete = 17787499
SET Handler_prepare = 0
SET Handler_read_first = 41
SET Handler_read_key = 2239511536
SET Handler_read_next = 2530549609
SET Handler_read_prev = 5679
SET Handler_read_rnd = 1402
SET Handler_read_rnd_next = 101871852
SET Handler_rollback = 260
SET Handler_savepoint = 0
SET Handler_savepoint_rollback = 0
SET Handler_update = 56105758
SET Handler_write = 22710400
END 
BEGIN mysql_db-2.table_locks 0
SET Table_locks_immediate = 28264185
SET Table_locks_waited = 0
END 
BEGIN mysql_db-2.join_issues 0
SET Select_full_join = 0
SET Select_full_range_join = 0
SET Select_range = 880421
SET Select_range_check = 0
SET Select_scan = 5318
END 
BEGIN mysql_db-2.sort_issues 0
SET Sort_merge_passes = 0
SET Sort_range = 34
SET Sort_scan = 0
END 
BEGIN mysql_db-2.tmp 0
SET Created_tmp_disk_tables = 0
SET Created_tmp_files = 6
SET Created_tmp_tables = 5277
END 
BEGIN mysql_db-2.connections 0
SET Connections = 5820078
SET Aborted_connects = 0
END 
BEGIN mysql_db-2.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_db-2.binlog_cache 0
SET Binlog_cache_disk_use = 0
SET Binlog_cache_use = 0
END 
BEGIN mysql_db-2.binlog_stmt_cache 0
SET Binlog_stmt_cache_disk_use = 0
SET Binlog_stmt_cache_use = 0
END 
BEGIN mysql_db-2.threads 0
SET Threads_connected = 40
SET Threads_created = 10709
SET Threads_cached = 99
SET Threads_running = 3
END 
BEGIN mysql_db-2.thread_cache_misses 0
SET Thread_cache_misses = 18
END 
BEGIN mysql_db-2.innodb_io 0
SET Innodb_data_read = 5485646336
SET Innodb_data_written = 49676281344
END 
BEGIN mysql_db-2.innodb_io_ops 0
SET Innodb_data_reads = 334876
SET Innodb_data_writes = 18655302
SET Innodb_data_fsyncs = 17867817
END 
BEGIN mysql_db-2.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_db-2.innodb_log 0
SET Innodb_log_waits = 0
SET Innodb_log_write_requests = 25986187
SET Innodb_log_writes = 17796362
END 
BEGIN mysql_db-2.innodb_os_log 0
SET Innodb_os_log_fsyncs = 17799227
SET Innodb_os_log_pending_fsyncs = 0
SET Innodb_os_log_pending_writes = 0
END 
BEGIN mysql_db-2.innodb_os_log_io 0
SET Innodb_os_log_written = 22325522944
END 
BEGIN mysql_db-2.innodb_cur_row_lock 0
SET Innodb_row_lock_current_waits = 0
END 
BEGIN mysql_db-2.innodb_rows 0
SET Innodb_rows_inserted = 323662
SET Innodb_rows_read = 3662821130
SET Innodb_rows_updated = 56105757
SET Innodb_rows_deleted = 26
END 
BEGIN mysql_db-2.innodb_buffer_pool_pages 0
SET Innodb_buffer_pool_pages_data = 368975
SET Innodb_buffer_pool_pages_dirty = 2602
SET Innodb_buffer_pool_pages_free = 12081735
SET Innodb_buffer_pool_pages_flushed = 834659
SET Innodb_buffer_pool_pages_misc = 1122
SET Innodb_buffer_pool_pages_total = 12451832
END 
BEGIN mysql_db-2.innodb_buffer_pool_bytes 0
SET Innodb_buffer_pool_bytes_data = 6045286400
SET Innodb_buffer_pool_bytes_dirty = 42631168
END 
BEGIN mysql_db-2.innodb_buffer_pool_read_ahead 0
SET Innodb_buffer_pool_read_ahead = 37822
SET Innodb_buffer_pool_read_ahead_evicted = 0
SET Innodb_buffer_pool_read_ahead_rnd = 0
END 
BEGIN mysql_db-2.innodb_buffer_pool_reqs 0
SET Innodb_buffer_pool_read_requests = 14332695874
SET Innodb_buffer_pool_write_requests = 339060486
END 
BEGIN mysql_db-2.innodb_buffer_pool_ops 0
SET Innodb_buffer_pool_reads = 279735
SET Innodb_buffer_pool_wait_free = 0
END 
BEGIN mysql_db-2.qcache_ops 0
SET Qcache_hits = 0
SET Qcache_lowmem_prunes = 0
SET Qcache_inserts = 0
SET Qcache_not_cached = 0
END 
BEGIN mysql_db-2.qcache 0
SET Qcache_queries_in_cache = 0
END 
BEGIN mysql_db-2.qcache_freemem 0
SET Qcache_free_memory = 0
END 
BEGIN mysql_db-2.qcache_memblocks 0
SET Qcache_free_blocks = 0
SET Qcache_total_blocks = 0
END 
BEGIN mysql_db-2.key_blocks 0
SET Key_blocks_unused = 107153
SET Key_blocks_used = 10
SET Key_blocks_not_flushed = 0
END 
BEGIN mysql_db-2.key_requests 0
SET Key_read_requests = 18
SET Key_write_requests = 0
END 
BEGIN mysql_db-2.key_disk_ops 0
SET Key_reads = 10
SET Key_writes = 0
END 
BEGIN mysql_db-2.files 0
SET Open_files = 28
END 
BEGIN mysql_db-2.files_rate 0
SET Opened_files = 407
END 
BEGIN mysql_db-2.slave_behind 0
SET Seconds_Behind_Master = 0
END 
BEGIN mysql_db-2.slave_status 0
SET Slave_SQL_Running = 1
SET Slave_IO_Running = 1
END 
2017-08-08 08:48:16: python.d DEBUG: mysql_db-2 mysql_db-2 updated in 6 ms
2017-08-08 08:48:16: python.d DEBUG: mysql_db-2 sleeping for 0.992980003357 secs to reach frequency of 1.0 secs, now: 1502182096.01  next: 1502182097.0  penalty: 0

BEGIN netdata.plugin_pythond_mysql_db-2 0
SET run_time = 6
END