/opt/site24x7/monagent/plugins/mysql_monitoring$ sudo python3 mysql_monitoring.py --host="[REMOVED]" --port="3306" --username="[REMOVED]" --password="[REMOVED]" { "aborted_clients": 14.0, "aborted_connects": 1.0, "application_queries": 129676064.0, "applog": { "logs_enabled": false }, "blocks_not_flushed": 0.0, "buffer_pool_pages_data": 1179487.0, "buffer_pool_pages_dirty": 3123.0, "buffer_pool_pages_flushed": 56208114.0, "buffer_pool_pages_free": 11260342.0, "buffer_pool_pages_total": 12451840.0, "buffer_pool_read_ahead": 60.0, "buffer_pool_read_ahead_evicted": 0.0, "buffer_pool_read_ahead_rnd": 0.0, "buffer_pool_read_requests": 5475168636.0, "buffer_pool_reads": 852877.0, "buffer_pool_wait_free": 0.0, "buffer_pool_write_requests": 1987964976.0, "cached": 80.0, "client_queries": 63149465.0, "com_delete": 500936.0, "com_insert": 12767528.0, "com_rollback": 0.0, "com_update": 16717559.0, "commit": 34817724.0, "connected": 14.0, "connection_errors_max_connections": 0.0, "connection_usage": 0, "created": 81.0, "data_fsyncs": 112386770.0, "data_length": 0, "data_pending_fsyncs": 4437.0, "data_pending_reads": 0.0, "data_pending_writes": 0.0, "data_reads": 887077.0, "data_writes": 248834907.0, "delete_multi": 0.0, "disk_tables": 639582.0, "free_blocks": 0, "free_memory": 0, "full_join": 3633967.0, "full_range_join": 0.0, "handler_delete": 115017857.0, "handler_rollback": 1.0, "handler_update": 27933358.0, "handler_write": 202016561.0, "heartbeat_required": "true", "hits": 0, "in_cache": 0, "index_length": 0, "insert_select": 0.0, "inserts": 0, "key_reads": 0.0, "key_writes": 0.0, "log_waits": 3554.0, "log_write_requests": 1543666110.0, "log_writes": 191577284.0, "lowmem_prunes": 0, "max_connections": 20480.0, "max_data_length": 0, "max_execution_time_exceeded": 0.0, "max_used_connections": 92.0, "merge_passes": 0.0, "mysql_node_type": "Master", "not_cached": 0, "open_cache_hits": 188421033.0, "open_cache_misses": 8449.0, "open_cache_overflows": 577.0, "open_files": 29.0, "open_files_usage": 0.002765655517578125, "open_tables": 5540.0, "os_log_fsyncs": 78829175.0, "os_log_pending_fsyncs": 0.0, "os_log_pending_writes": 0.0, "os_log_written": 147394366464.0, "pages_created": 2214675.0, "pages_read": 883584.0, "pages_written": 56208183.0, "plugin_version": "3", "prepared_stmt_count": 0.0, "range": 0.0, "range_check": 0.0, "read_first": 32154867.0, "read_key": 424438264.0, "read_requests": 0.0, "read_rnd": 151185510.0, "read_rnd_next": 2078278831.0, "reads": 0, "received": 10688158582.0, "replace_select": 0.0, "row_length": 0, "row_lock_time_avg": 0.0, "row_lock_waits": 0.0, "rows": 8358329.0, "rows_count": 0, "rows_deleted": 114993245.0, "rows_inserted": 155160181.0, "rows_read": 2974054059.0, "rows_updated": 27834300.0, "running": 0, "scan": 1194012.0, "select": 36428446.0, "select_range": 0.0, "select_scan": 41981069.0, "sent": 18779841585.0, "slave_running": 0, "slow_queries": 0.0, "table_locks_waited": 0.0, "tmp_files": 96.0, "tmp_tables": 24280388.0, "total_blocks": 0, "transactions": 34817724.0, "units": { "connection_usage": "%", "data_length": "bytes", "free_memory": "bytes", "index_length": "bytes", "max_data_length": "bytes", "open_files_usage": "%", "os_log_written": "bytes", "received": "bytes", "relay_log_space": "bytes", "row_count": "units", "row_length": "bytes", "row_lock_time_avg": "ms", "seconds_behind_master": "seconds", "sent": "bytes", "uptime": "seconds" }, "update_multi": 0.0, "uptime": 1809579.0, "version": "8.0.31", "write_requests": 0.0, "writes": 29986023.0 }