"agent": "lua": attributes: "mem_size": int instances: "0432d601-4fa2-4e8b-8a39-3eb55d88bafd": parent: ns: "mysql" class: "agent" inst: "0432d601-4fa2-4e8b-8a39-3eb55d88bafd" values: "mem_size": 17484 "proc": attributes: "egid": int "euid": int "gid": int "mem_major_faults": int "mem_minor_faults": int "mem_page_faults": int "mem_resident": int "mem_share": int "mem_size": int "name": string "nice": int "ppid": int "priority": int "processor": int "state": int "threads": int "time_start_time": int "time_sys": int "time_total": int "time_user": int "tty": int "uid": int instances: "0432d601-4fa2-4e8b-8a39-3eb55d88bafd": parent: ns: "mysql" class: "agent" inst: "0432d601-4fa2-4e8b-8a39-3eb55d88bafd" values: "egid": 20 "euid": 501 "gid": 20 "mem_major_faults": undefined "mem_minor_faults": undefined "mem_page_faults": 684414 "mem_resident": 2703360 "mem_share": undefined "mem_size": 91168768 "name": "mysql-monitor-ag" "nice": 0 "ppid": 28775 "priority": 24 "processor": undefined "state": 82 "threads": 10 "time_start_time": 1302616595525 "time_sys": 85107 "time_total": 162724 "time_user": 77617 "tty": undefined "uid": 501 "mysql": "account_old_password": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": undefined "all_db_table_count": attributes: "all_db_table_count": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "all_db_table_count": 47 "anonymous_user": attributes: "user_count": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user_count": 0 "auto_increment_limit": attributes: "table_list": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "table_list": undefined "binary_log_io": attributes: "bytes_read": int "bytes_written": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "bytes_read": 0 "bytes_written": 0 "broad_host_specifier": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": "\\ * 'msandbox'" "cluster_data_node_data_memory": attributes: "data_mem_total": int "data_mem_used": int instances: "cluster_data_node_index_memory": attributes: "index_mem_total": int "index_mem_used": int instances: "cluster_data_node_redo_buffer": attributes: "redo_buffer_total": int "redo_buffer_used": int instances: "cluster_data_node_redo_logspace": attributes: "redo_logspace_total": int "redo_logspace_used": int instances: "cluster_data_node_undo_buffer": attributes: "undo_buffer_total": int "undo_buffer_used": int instances: "cluster_data_node_undo_logspace": attributes: "undo_logspace_total": int "undo_logspace_used": int instances: "cluster_data_nodes_not_started": attributes: "node_list": string instances: "database": attributes: "Database": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5.information_schema": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Database": "information_schema" "5a41ac04-115d-448f-a0ca-144eeb5ac8b5.mysql": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Database": "mysql" "5a41ac04-115d-448f-a0ca-144eeb5ac8b5.performance_schema": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Database": "performance_schema" "5a41ac04-115d-448f-a0ca-144eeb5ac8b5.test": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Database": "test" "global_privileges": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": "\\ * 'msandbox'@'%'" "grant_privileges": attributes: "user_spec": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user_spec": undefined "inappropriate_slave_privileges": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": "\\ * 'msandbox'@'%'" "innodb_compression_time": attributes: "compress_seconds": int "uncompress_seconds": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "compress_seconds": 0 "uncompress_seconds": 0 "innodb_current_trxs": attributes: "lock_memory_bytes_total": int "rows_locked_total": int "rows_modified_total": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "lock_memory_bytes_total": 0 "rows_locked_total": 0 "rows_modified_total": 0 "innodb_datafile_io": attributes: "bytes_read": int "bytes_written": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "bytes_read": 14434304 "bytes_written": 3080192 "innodb_log_io": attributes: "bytes_read": int "bytes_written": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "bytes_read": 139264 "bytes_written": 52224 "innodb_plugins": attributes: "innodb_plugin_list": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "innodb_plugin_list": "InnoDB!INNODB_CMP!INNODB_CMPMEM!INNODB_LOCKS!INNODB_LOCK_WAITS!INNODB_TRX" "innodb_transactions": attributes: "committing_count": int "lock_wait_count": int "rolling_back_count": int "running_count": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "committing_count": 0 "lock_wait_count": 0 "rolling_back_count": 0 "running_count": 0 "innodbstatus": attributes: "innodb_bp_add_alloc": int "innodb_bp_created_per_sec": float "innodb_bp_db_pages": int "innodb_bp_dictionary_alloc": int "innodb_bp_free_buffers": int "innodb_bp_hit_rate": int "innodb_bp_io_cur_pages": int "innodb_bp_io_sum_pages": int "innodb_bp_io_unzip_cur_pages": int "innodb_bp_io_unzip_sum_pages": int "innodb_bp_lru_len": int "innodb_bp_modified_pages": int "innodb_bp_not_young_hit_rate": int "innodb_bp_old_db_pages": int "innodb_bp_pages_created": int "innodb_bp_pages_evicted_no_access_per_sec": float "innodb_bp_pages_not_young": int "innodb_bp_pages_not_young_per_sec": float "innodb_bp_pages_read": int "innodb_bp_pages_read_ahead_per_sec": float "innodb_bp_pages_written": int "innodb_bp_pages_young": int "innodb_bp_pages_young_per_sec": float "innodb_bp_pending_pages": int "innodb_bp_pending_writes_flush_list": int "innodb_bp_pending_writes_lru": int "innodb_bp_pending_writes_single_page": int "innodb_bp_reads_per_sec": float "innodb_bp_size": int "innodb_bp_total_alloc": int "innodb_bp_unzip_lru_len": int "innodb_bp_written_per_sec": float "innodb_bp_young_hit_rate": int "innodb_bytes_per_read": int "innodb_cbuf_delete_discarded": int "innodb_cbuf_delete_mark_discarded": int "innodb_cbuf_delete_mark_merges": int "innodb_cbuf_delete_merges": int "innodb_cbuf_insert_discarded": int "innodb_cbuf_insert_merges": int "innodb_datetime": string "innodb_hash_node_heap": int "innodb_hash_searches_per_sec": float "innodb_hash_table_size": int "innodb_ibuf_free_list_len": int "innodb_ibuf_seg_size": int "innodb_ibuf_size": int "innodb_io_ibuf_logs": int "innodb_io_ibuf_reads": int "innodb_io_ibuf_syncs": int "innodb_io_os_file_fsyncs": int "innodb_io_os_file_reads": int "innodb_io_os_file_writes": int "innodb_io_pending_flush_bp": int "innodb_io_pending_flush_log": int "innodb_io_pending_reads": int "innodb_io_pending_writes": int "innodb_io_syncs_per_sec": float "innodb_log_checkpoint_lsn": int "innodb_log_flushed_lsn": int "innodb_log_io_per_sec": float "innodb_log_io_total": int "innodb_log_pending_checkpoint_writes": int "innodb_log_pending_log_writes": int "innodb_log_sequence_lsn": int "innodb_main_thd_log_flush_writes": int "innodb_main_thd_loops_background": int "innodb_main_thd_loops_flush": int "innodb_main_thd_loops_one_sec": int "innodb_main_thd_loops_sleeps": int "innodb_main_thd_loops_ten_sec": int "innodb_non_hash_searches_per_sec": float "innodb_per_sec_avg": int "innodb_reads_per_sec": float "innodb_row_queries_inside": int "innodb_row_queries_queue": int "innodb_row_state": string "innodb_rows_deleted": int "innodb_rows_deleted_per_sec": float "innodb_rows_inserted": int "innodb_rows_inserted_per_sec": float "innodb_rows_read": int "innodb_rows_read_per_sec": float "innodb_rows_updated": int "innodb_rows_updated_per_sec": float "innodb_sem_mutex_os_waits": int "innodb_sem_mutex_rounds": int "innodb_sem_mutex_spin_waits": int "innodb_sem_os_reservation_count": int "innodb_sem_os_signal_count": int "innodb_sem_spins_per_wait_mutex": float "innodb_sem_spins_per_wait_rw_excl": float "innodb_sem_spins_per_wait_rw_shared": float "innodb_trx_history_list_length": int "innodb_trx_id_counter_str": string "innodb_writes_per_sec": float instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "innodb_bp_add_alloc": 0 "innodb_bp_created_per_sec": 0.000000 "innodb_bp_db_pages": 191 "innodb_bp_dictionary_alloc": 63928 "innodb_bp_free_buffers": 8000 "innodb_bp_hit_rate": 1000 "innodb_bp_io_cur_pages": 0 "innodb_bp_io_sum_pages": 0 "innodb_bp_io_unzip_cur_pages": 0 "innodb_bp_io_unzip_sum_pages": 0 "innodb_bp_lru_len": 191 "innodb_bp_modified_pages": 0 "innodb_bp_not_young_hit_rate": 0 "innodb_bp_old_db_pages": 0 "innodb_bp_pages_created": 9 "innodb_bp_pages_evicted_no_access_per_sec": 0.000000 "innodb_bp_pages_not_young": 0 "innodb_bp_pages_not_young_per_sec": 0.000000 "innodb_bp_pages_read": 182 "innodb_bp_pages_read_ahead_per_sec": 0.000000 "innodb_bp_pages_written": 47 "innodb_bp_pages_young": 0 "innodb_bp_pages_young_per_sec": 0.000000 "innodb_bp_pending_pages": 0 "innodb_bp_pending_writes_flush_list": 0 "innodb_bp_pending_writes_lru": 0 "innodb_bp_pending_writes_single_page": 0 "innodb_bp_reads_per_sec": 0.000000 "innodb_bp_size": 8192 "innodb_bp_total_alloc": 137363456 "innodb_bp_unzip_lru_len": 0 "innodb_bp_written_per_sec": 0.000000 "innodb_bp_young_hit_rate": 0 "innodb_bytes_per_read": 0 "innodb_cbuf_delete_discarded": 0 "innodb_cbuf_delete_mark_discarded": 0 "innodb_cbuf_delete_mark_merges": 0 "innodb_cbuf_delete_merges": 0 "innodb_cbuf_insert_discarded": 0 "innodb_cbuf_insert_merges": 0 "innodb_datetime": "110414 13:07:01" "innodb_hash_node_heap": 1 "innodb_hash_searches_per_sec": 0.000000 "innodb_hash_table_size": 276707 "innodb_ibuf_free_list_len": 0 "innodb_ibuf_seg_size": 2 "innodb_ibuf_size": 1 "innodb_io_ibuf_logs": 0 "innodb_io_ibuf_reads": 0 "innodb_io_ibuf_syncs": 0 "innodb_io_os_file_fsyncs": 33 "innodb_io_os_file_reads": 321 "innodb_io_os_file_writes": 50 "innodb_io_pending_flush_bp": 0 "innodb_io_pending_flush_log": 0 "innodb_io_pending_reads": 0 "innodb_io_pending_writes": 0 "innodb_io_syncs_per_sec": 0.000000 "innodb_log_checkpoint_lsn": 1673931 "innodb_log_flushed_lsn": 1673931 "innodb_log_io_per_sec": 0.000000 "innodb_log_io_total": 34 "innodb_log_pending_checkpoint_writes": 0 "innodb_log_pending_log_writes": 0 "innodb_log_sequence_lsn": 1673931 "innodb_main_thd_log_flush_writes": 22 "innodb_main_thd_loops_background": 2 "innodb_main_thd_loops_flush": 2 "innodb_main_thd_loops_one_sec": 22 "innodb_main_thd_loops_sleeps": 22 "innodb_main_thd_loops_ten_sec": 2 "innodb_non_hash_searches_per_sec": 0.000000 "innodb_per_sec_avg": 60 "innodb_reads_per_sec": 0.000000 "innodb_row_queries_inside": 0 "innodb_row_queries_queue": 0 "innodb_row_state": "waiting for server activity Number of rows inserted 23" "innodb_rows_deleted": 0 "innodb_rows_deleted_per_sec": 0.000000 "innodb_rows_inserted": 23 "innodb_rows_inserted_per_sec": 0.000000 "innodb_rows_read": 0 "innodb_rows_read_per_sec": 0.000000 "innodb_rows_updated": 0 "innodb_rows_updated_per_sec": 0.000000 "innodb_sem_mutex_os_waits": 3 "innodb_sem_mutex_rounds": 90 "innodb_sem_mutex_spin_waits": 3 "innodb_sem_os_reservation_count": 7 "innodb_sem_os_signal_count": 7 "innodb_sem_spins_per_wait_mutex": 30.000000 "innodb_sem_spins_per_wait_rw_excl": 0.000000 "innodb_sem_spins_per_wait_rw_shared": 30.000000 "innodb_trx_history_list_length": 10 "innodb_trx_id_counter": 2840 "innodb_trx_id_counter_str": "B18" "innodb_writes_per_sec": 0.000000 "locked_processes": attributes: "num_locked": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "num_locked": 0 "long_locked_processes": attributes: "long_running_time": float "num_long_running": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "long_running_time": 10.000000 "num_long_running": 0 "long_running_processes": attributes: "long_running_time": float "num_long_running": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "long_running_time": 10.000000 "num_long_running": 0 "masterlog": attributes: instances: "masterlogs": attributes: instances: "masterstatus": attributes: "Binlog_Do_DB": string "Binlog_Ignore_DB": string "File": string "Position": int instances: "meb_backup_history": attributes: "backup_destination": string "collected_ts": int "collected_ts_counter": int "end_time_raw": string "end_time_ts": int "exit_state": string "last_error": string "last_error_code": int "lock_time": float "mysql_data_dir": string "progress_log": string "start_time_raw": string "start_time_ts": int "total_time": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "backup_destination": "/Users/mark/sandboxes/msb_5_5_10/backup/2011-04-05_17-24-59" "collected_ts": 1302746347 "collected_ts_counter": 1302746347 "end_time_raw": "2011-04-05 17:25:03" "end_time_ts": 1302020703 "exit_state": "SUCCESS" "last_error": "NO_ERROR" "last_error_code": 0 "lock_time": 0.911000 "mysql_data_dir": "/Users/mark/sandboxes/msb_5_5_10/data" "progress_log": "\\ * 2011-04-05 17:24:59: Started mysqlbackup.,\\ * 2011-04-05 17:24:59: mysqlbackup starting ibbackup.,\\ * 2011-04-05 17:24:59: mysqlbackup pausing ibbackup.,\\ * 2011-04-05 17:25:01: mysqlbackup locking tables and copying .frm + other engines data.,\\ * 2011-04-05 17:25:02: mysqlbackup unlocked the tables.,\\ * 2011-04-05 17:25:04: mysqlbackup returns success." "start_time_raw": "2011-04-05 17:24:59" "start_time_ts": 1302020699 "total_time": 4 "meb_backup_success_history": attributes: "last_full_backup": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "last_full_backup": "2011-04-05 17:24:59" "meb_incremental": attributes: "total_increments": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "total_increments": 0 "meb_timing": attributes: "lock_time": float "total_time": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "lock_time": 0.000000 "total_time": 0 "myisam_data_file_io": attributes: "bytes_read": int "bytes_written": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "bytes_read": 42817160 "bytes_written": 42770408 "myisam_index_file_io": attributes: "bytes_read": int "bytes_written": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "bytes_read": 170558 "bytes_written": 152495 "no_password": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": undefined "no_root_password": attributes: "no_password": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "no_password": 0 "privileges_on_all_dbs": attributes: "user_spec": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user_spec": "\\ * 'msandbox'@'%'" "processlist": attributes: "Command": string "Host": string "Id": int "Info": string "State": undefined "Time": int "User": string "db": undefined instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5.4": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Command": "Query" "Host": "localhost:51682" "Id": 4 "Info": "SHOW /*!40000 FULL */ PROCESSLIST" "State": undefined "Time": 0 "User": "msandbox" "db": undefined "quanconfig": attributes: "auto_explain_min_exec_time_ms": int "capture_examples": string "capture_explain": string "enabled": string "frequency": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "repl_slave_privileges": attributes: "repl_slaves": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "repl_slaves": 1 "root_account_exists": attributes: "root_account": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "root_account": 1 "root_remote_login": attributes: "remote_login": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "remote_login": 0 "server": attributes: "displayname": string "server.connected": int "server.last_errno": int "server.last_error": string "server.reachable": int "server.version_numeric": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "displayname": undefined "server.connected": 1 "server.last_errno": 0 "server.last_error": undefined "server.reachable": 1 "server.version_numeric": 50510 "server_admin_privileges": attributes: "user_spec": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user_spec": "\\ * 'msandbox'@'%'" "slavestatus": attributes: "Connect_Retry": int "Exec_Master_Log_Pos": int "Last_Errno": int "Last_Error": string "Last_IO_Errno": int "Last_IO_Error": string "Last_SQL_Errno": int "Last_SQL_Error": string "Master_Host": string "Master_Log_File": string "Master_Port": int "Master_SSL_Allowed": string "Master_SSL_CA_File": string "Master_SSL_CA_Path": string "Master_SSL_Cert": string "Master_SSL_Cipher": string "Master_SSL_Key": string "Master_SSL_Verify_Server_Cert": string "Master_Server_Id": int "Master_User": string "Read_Master_Log_Pos": int "Relay_Log_File": string "Relay_Log_Pos": int "Relay_Log_Space": int "Relay_Master_Log_File": string "Replicate_Do_DB": string "Replicate_Do_Table": string "Replicate_Ignore_DB": string "Replicate_Ignore_Server_Ids": string "Replicate_Ignore_Table": string "Replicate_Wild_Do_Table": string "Replicate_Wild_Ignore_Table": string "Seconds_Behind_Master": int "Skip_Counter": int "Slave_IO_Running": string "Slave_IO_State": string "Slave_SQL_Running": string "Until_Condition": string "Until_Log_File": string "Until_Log_Pos": int instances: "sp_with_select_star": attributes: "routine": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "routine": undefined "status": attributes: "Aborted_clients": int "Aborted_connects": int "Binlog_cache_disk_use": int "Binlog_cache_use": int "Binlog_stmt_cache_disk_use": int "Binlog_stmt_cache_use": int "Bytes_received": int "Bytes_sent": int "Com_admin_commands": int "Com_alter_db": int "Com_alter_db_upgrade": int "Com_alter_event": int "Com_alter_function": int "Com_alter_procedure": int "Com_alter_server": int "Com_alter_table": int "Com_alter_tablespace": int "Com_analyze": int "Com_assign_to_keycache": int "Com_begin": int "Com_binlog": int "Com_call_procedure": int "Com_change_db": int "Com_change_master": int "Com_check": int "Com_checksum": int "Com_commit": int "Com_create_db": int "Com_create_event": int "Com_create_function": int "Com_create_index": int "Com_create_procedure": int "Com_create_server": int "Com_create_table": int "Com_create_trigger": int "Com_create_udf": int "Com_create_user": int "Com_create_view": int "Com_dealloc_sql": int "Com_delete": int "Com_delete_multi": int "Com_do": int "Com_drop_db": int "Com_drop_event": int "Com_drop_function": int "Com_drop_index": int "Com_drop_procedure": int "Com_drop_server": int "Com_drop_table": int "Com_drop_trigger": int "Com_drop_user": int "Com_drop_view": int "Com_empty_query": int "Com_execute_sql": int "Com_flush": int "Com_grant": int "Com_ha_close": int "Com_ha_open": int "Com_ha_read": int "Com_help": int "Com_insert": int "Com_insert_select": int "Com_install_plugin": int "Com_kill": int "Com_load": int "Com_lock_tables": int "Com_optimize": int "Com_preload_keys": int "Com_prepare_sql": int "Com_purge": int "Com_purge_before_date": int "Com_release_savepoint": int "Com_rename_table": int "Com_rename_user": int "Com_repair": int "Com_replace": int "Com_replace_select": int "Com_reset": int "Com_resignal": int "Com_revoke": int "Com_revoke_all": int "Com_rollback": int "Com_rollback_to_savepoint": int "Com_savepoint": int "Com_select": int "Com_set_option": int "Com_show_authors": int "Com_show_binlog_events": int "Com_show_binlogs": int "Com_show_charsets": int "Com_show_collations": int "Com_show_contributors": int "Com_show_create_db": int "Com_show_create_event": int "Com_show_create_func": int "Com_show_create_proc": int "Com_show_create_table": int "Com_show_create_trigger": int "Com_show_databases": int "Com_show_engine_logs": int "Com_show_engine_mutex": int "Com_show_engine_status": int "Com_show_errors": int "Com_show_events": int "Com_show_fields": int "Com_show_function_status": int "Com_show_grants": int "Com_show_keys": int "Com_show_master_status": int "Com_show_new_master": int "Com_show_open_tables": int "Com_show_plugins": int "Com_show_privileges": int "Com_show_procedure_status": int "Com_show_processlist": int "Com_show_profile": int "Com_show_profiles": int "Com_show_relaylog_events": int "Com_show_slave_hosts": int "Com_show_slave_status": int "Com_show_status": int "Com_show_storage_engines": int "Com_show_table_status": int "Com_show_tables": int "Com_show_triggers": int "Com_show_variables": int "Com_show_warnings": int "Com_signal": int "Com_slave_start": int "Com_slave_stop": int "Com_stmt_close": int "Com_stmt_execute": int "Com_stmt_fetch": int "Com_stmt_prepare": int "Com_stmt_reprepare": int "Com_stmt_reset": int "Com_stmt_send_long_data": int "Com_truncate": int "Com_uninstall_plugin": int "Com_unlock_tables": int "Com_update": int "Com_update_multi": int "Com_xa_commit": int "Com_xa_end": int "Com_xa_prepare": int "Com_xa_recover": int "Com_xa_rollback": int "Com_xa_start": int "Compression": string "Connections": int "Created_tmp_disk_tables": int "Created_tmp_files": int "Created_tmp_tables": int "Delayed_errors": int "Delayed_insert_threads": int "Delayed_writes": int "Flush_commands": int "Handler_commit": int "Handler_delete": int "Handler_discover": int "Handler_prepare": int "Handler_read_first": int "Handler_read_key": int "Handler_read_last": int "Handler_read_next": int "Handler_read_prev": int "Handler_read_rnd": int "Handler_read_rnd_next": int "Handler_rollback": int "Handler_savepoint": int "Handler_savepoint_rollback": int "Handler_update": int "Handler_write": int "Innodb_buffer_pool_pages_data": int "Innodb_buffer_pool_pages_dirty": int "Innodb_buffer_pool_pages_flushed": int "Innodb_buffer_pool_pages_free": int "Innodb_buffer_pool_pages_misc": int "Innodb_buffer_pool_pages_total": int "Innodb_buffer_pool_read_ahead": int "Innodb_buffer_pool_read_ahead_evicted": int "Innodb_buffer_pool_read_requests": int "Innodb_buffer_pool_reads": int "Innodb_buffer_pool_wait_free": int "Innodb_buffer_pool_write_requests": int "Innodb_data_fsyncs": int "Innodb_data_pending_fsyncs": int "Innodb_data_pending_reads": int "Innodb_data_pending_writes": int "Innodb_data_read": int "Innodb_data_reads": int "Innodb_data_writes": int "Innodb_data_written": int "Innodb_dblwr_pages_written": int "Innodb_dblwr_writes": int "Innodb_have_atomic_builtins": string "Innodb_log_waits": int "Innodb_log_write_requests": int "Innodb_log_writes": int "Innodb_os_log_fsyncs": int "Innodb_os_log_pending_fsyncs": int "Innodb_os_log_pending_writes": int "Innodb_os_log_written": int "Innodb_page_size": int "Innodb_pages_created": int "Innodb_pages_read": int "Innodb_pages_written": int "Innodb_row_lock_current_waits": int "Innodb_row_lock_time": int "Innodb_row_lock_time_avg": int "Innodb_row_lock_time_max": int "Innodb_row_lock_waits": int "Innodb_rows_deleted": int "Innodb_rows_inserted": int "Innodb_rows_read": int "Innodb_rows_updated": int "Innodb_truncated_status_writes": int "Key_blocks_not_flushed": int "Key_blocks_unused": int "Key_blocks_used": int "Key_read_requests": int "Key_reads": int "Key_write_requests": int "Key_writes": int "Last_query_cost": float "Max_used_connections": int "Not_flushed_delayed_rows": int "Open_files": int "Open_streams": int "Open_table_definitions": int "Open_tables": int "Opened_files": int "Opened_table_definitions": int "Opened_tables": int "Performance_schema_cond_classes_lost": int "Performance_schema_cond_instances_lost": int "Performance_schema_file_classes_lost": int "Performance_schema_file_handles_lost": int "Performance_schema_file_instances_lost": int "Performance_schema_locker_lost": int "Performance_schema_mutex_classes_lost": int "Performance_schema_mutex_instances_lost": int "Performance_schema_rwlock_classes_lost": int "Performance_schema_rwlock_instances_lost": int "Performance_schema_table_handles_lost": int "Performance_schema_table_instances_lost": int "Performance_schema_thread_classes_lost": int "Performance_schema_thread_instances_lost": int "Prepared_stmt_count": int "Qcache_free_blocks": int "Qcache_free_memory": int "Qcache_hits": int "Qcache_inserts": int "Qcache_lowmem_prunes": int "Qcache_not_cached": int "Qcache_queries_in_cache": int "Qcache_total_blocks": int "Queries": int "Questions": int "Rpl_status": string "Select_full_join": int "Select_full_range_join": int "Select_range": int "Select_range_check": int "Select_scan": int "Slave_heartbeat_period": float "Slave_open_temp_tables": int "Slave_received_heartbeats": int "Slave_retried_transactions": int "Slave_running": string "Slow_launch_threads": int "Slow_queries": int "Sort_merge_passes": int "Sort_range": int "Sort_rows": int "Sort_scan": int "Ssl_accept_renegotiates": int "Ssl_accepts": int "Ssl_callback_cache_hits": int "Ssl_cipher": string "Ssl_cipher_list": string "Ssl_client_connects": int "Ssl_connect_renegotiates": int "Ssl_ctx_verify_depth": int "Ssl_ctx_verify_mode": int "Ssl_default_timeout": int "Ssl_finished_accepts": int "Ssl_finished_connects": int "Ssl_session_cache_hits": int "Ssl_session_cache_misses": int "Ssl_session_cache_mode": string "Ssl_session_cache_overflows": int "Ssl_session_cache_size": int "Ssl_session_cache_timeouts": int "Ssl_sessions_reused": int "Ssl_used_session_cache_entries": int "Ssl_verify_depth": int "Ssl_verify_mode": int "Ssl_version": string "Table_locks_immediate": int "Table_locks_waited": int "Tc_log_max_pages_used": int "Tc_log_page_size": int "Tc_log_page_waits": int "Threads_cached": int "Threads_connected": int "Threads_created": int "Threads_running": int "Uptime": int "Uptime_since_flush_status": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Aborted_clients": 0 "Aborted_connects": 0 "Binlog_cache_disk_use": 0 "Binlog_cache_use": 0 "Binlog_stmt_cache_disk_use": 0 "Binlog_stmt_cache_use": 0 "Bytes_received": 6073208 "Bytes_sent": 70190554 "Com_admin_commands": 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": 0 "Com_alter_tablespace": 0 "Com_analyze": 0 "Com_assign_to_keycache": 0 "Com_begin": 0 "Com_binlog": 0 "Com_call_procedure": 0 "Com_change_db": 3 "Com_change_master": 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": 1 "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_flush": 0 "Com_grant": 0 "Com_ha_close": 0 "Com_ha_open": 0 "Com_ha_read": 0 "Com_help": 0 "Com_insert": 23 "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": 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": 0 "Com_revoke_all": 0 "Com_rollback": 0 "Com_rollback_to_savepoint": 0 "Com_savepoint": 0 "Com_select": 25317 "Com_set_option": 4 "Com_show_authors": 0 "Com_show_binlog_events": 0 "Com_show_binlogs": 10 "Com_show_charsets": 0 "Com_show_collations": 0 "Com_show_contributors": 0 "Com_show_create_db": 0 "Com_show_create_event": 0 "Com_show_create_func": 0 "Com_show_create_proc": 0 "Com_show_create_table": 0 "Com_show_create_trigger": 0 "Com_show_databases": 17 "Com_show_engine_logs": 0 "Com_show_engine_mutex": 0 "Com_show_engine_status": 2775 "Com_show_errors": 0 "Com_show_events": 0 "Com_show_fields": 37 "Com_show_function_status": 0 "Com_show_grants": 0 "Com_show_keys": 0 "Com_show_master_status": 9 "Com_show_new_master": 0 "Com_show_open_tables": 0 "Com_show_plugins": 0 "Com_show_privileges": 0 "Com_show_procedure_status": 0 "Com_show_processlist": 7 "Com_show_profile": 0 "Com_show_profiles": 0 "Com_show_relaylog_events": 0 "Com_show_slave_hosts": 0 "Com_show_slave_status": 2777 "Com_show_status": 2778 "Com_show_storage_engines": 0 "Com_show_table_status": 0 "Com_show_tables": 4 "Com_show_triggers": 0 "Com_show_variables": 2784 "Com_show_warnings": 0 "Com_signal": 0 "Com_slave_start": 0 "Com_slave_stop": 0 "Com_stmt_close": 0 "Com_stmt_execute": 0 "Com_stmt_fetch": 0 "Com_stmt_prepare": 0 "Com_stmt_reprepare": 0 "Com_stmt_reset": 0 "Com_stmt_send_long_data": 0 "Com_truncate": 0 "Com_uninstall_plugin": 0 "Com_unlock_tables": 0 "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 "Compression": "OFF" "Connections": 6 "Created_tmp_disk_tables": 364 "Created_tmp_files": 5 "Created_tmp_tables": 23838 "Delayed_errors": 0 "Delayed_insert_threads": 0 "Delayed_writes": 0 "Flush_commands": 1 "Handler_commit": 23 "Handler_delete": 0 "Handler_discover": 0 "Handler_prepare": 0 "Handler_read_first": 50 "Handler_read_key": 27 "Handler_read_last": 0 "Handler_read_next": 57 "Handler_read_prev": 0 "Handler_read_rnd": 63 "Handler_read_rnd_next": 1824885 "Handler_rollback": 0 "Handler_savepoint": 0 "Handler_savepoint_rollback": 0 "Handler_update": 0 "Handler_write": 1743114 "Innodb_buffer_pool_pages_data": 191 "Innodb_buffer_pool_pages_dirty": 0 "Innodb_buffer_pool_pages_flushed": 94 "Innodb_buffer_pool_pages_free": 8000 "Innodb_buffer_pool_pages_misc": 1 "Innodb_buffer_pool_pages_total": 8192 "Innodb_buffer_pool_read_ahead": 0 "Innodb_buffer_pool_read_ahead_evicted": 0 "Innodb_buffer_pool_read_requests": 4394 "Innodb_buffer_pool_reads": 183 "Innodb_buffer_pool_wait_free": 0 "Innodb_buffer_pool_write_requests": 222 "Innodb_data_fsyncs": 33 "Innodb_data_pending_fsyncs": 0 "Innodb_data_pending_reads": 0 "Innodb_data_pending_writes": 0 "Innodb_data_read": 7278592 "Innodb_data_reads": 321 "Innodb_data_writes": 50 "Innodb_data_written": 1566208 "Innodb_dblwr_pages_written": 47 "Innodb_dblwr_writes": 2 "Innodb_have_atomic_builtins": "ON" "Innodb_log_waits": 0 "Innodb_log_write_requests": 26 "Innodb_log_writes": 25 "Innodb_os_log_fsyncs": 29 "Innodb_os_log_pending_fsyncs": 0 "Innodb_os_log_pending_writes": 0 "Innodb_os_log_written": 24064 "Innodb_page_size": 16384 "Innodb_pages_created": 9 "Innodb_pages_read": 182 "Innodb_pages_written": 47 "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": 23 "Innodb_rows_read": 0 "Innodb_rows_updated": 0 "Innodb_truncated_status_writes": 0 "Key_blocks_not_flushed": 0 "Key_blocks_unused": 6696 "Key_blocks_used": 2 "Key_read_requests": 133 "Key_reads": 2 "Key_write_requests": 0 "Key_writes": 0 "Last_query_cost": 0.000000 "Max_used_connections": 2 "Not_flushed_delayed_rows": 0 "Open_files": 54 "Open_streams": 0 "Open_table_definitions": 47 "Open_tables": 47 "Opened_files": 1647 "Opened_table_definitions": 52 "Opened_tables": 930 "Performance_schema_cond_classes_lost": 0 "Performance_schema_cond_instances_lost": 0 "Performance_schema_file_classes_lost": 0 "Performance_schema_file_handles_lost": 0 "Performance_schema_file_instances_lost": 63 "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_table_handles_lost": 0 "Performance_schema_table_instances_lost": 0 "Performance_schema_thread_classes_lost": 0 "Performance_schema_thread_instances_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": 36550 "Questions": 36550 "Rpl_status": "AUTH_MASTER" "Select_full_join": 27 "Select_full_range_join": 0 "Select_range": 0 "Select_range_check": 0 "Select_scan": 39149 "Slave_heartbeat_period": 0.000000 "Slave_open_temp_tables": 0 "Slave_received_heartbeats": 0 "Slave_retried_transactions": 0 "Slave_running": "OFF" "Slow_launch_threads": 0 "Slow_queries": 1 "Sort_merge_passes": 0 "Sort_range": 0 "Sort_rows": 3117 "Sort_scan": 2798 "Ssl_accept_renegotiates": 0 "Ssl_accepts": 0 "Ssl_callback_cache_hits": 0 "Ssl_cipher": "" "Ssl_cipher_list": "" "Ssl_client_connects": 0 "Ssl_connect_renegotiates": 0 "Ssl_ctx_verify_depth": 0 "Ssl_ctx_verify_mode": 0 "Ssl_default_timeout": 0 "Ssl_finished_accepts": 0 "Ssl_finished_connects": 0 "Ssl_session_cache_hits": 0 "Ssl_session_cache_misses": 0 "Ssl_session_cache_mode": "NONE" "Ssl_session_cache_overflows": 0 "Ssl_session_cache_size": 0 "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": 16898 "Table_locks_waited": 0 "Tc_log_max_pages_used": 0 "Tc_log_page_size": 0 "Tc_log_page_waits": 0 "Threads_cached": 0 "Threads_connected": 1 "Threads_created": 5 "Threads_running": 1 "Uptime": 171237 "Uptime_since_flush_status": 171237 "strong_privileges": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": "\\ * 'msandbox'@'%'" "tables_no_myisam_index_stats": attributes: "table_list": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "table_list": undefined "tables_no_unique_keys": attributes: "table_list": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "table_list": undefined "test_database": attributes: "Database (test)": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "Database (test)": "test" "user_on_missing_db": attributes: "db_name": string "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "db_name": undefined "user": undefined "user_on_missing_table": attributes: "user": string instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "user": undefined "variables": attributes: "auto_increment_increment": int "auto_increment_offset": int "autocommit": string "automatic_sp_privileges": string "back_log": int "basedir": string "big_tables": string "binlog_cache_size": int "binlog_direct_non_transactional_updates": string "binlog_format": string "binlog_stmt_cache_size": int "bulk_insert_buffer_size": int "character_set_client": string "character_set_connection": string "character_set_database": string "character_set_filesystem": string "character_set_results": string "character_set_server": string "character_set_system": string "character_sets_dir": string "collation_connection": string "collation_database": string "collation_server": string "completion_type": string "concurrent_insert": string "connect_timeout": int "datadir": string "date_format": string "datetime_format": string "default_storage_engine": string "default_week_format": int "delay_key_write": string "delayed_insert_limit": int "delayed_insert_timeout": int "delayed_queue_size": int "div_precision_increment": int "engine_condition_pushdown": string "event_scheduler": string "expire_logs_days": int "flush": string "flush_time": int "foreign_key_checks": string "ft_boolean_syntax": string "ft_max_word_len": int "ft_min_word_len": int "ft_query_expansion_limit": int "ft_stopword_file": string "general_log": string "general_log_file": string "group_concat_max_len": int "have_compress": string "have_crypt": string "have_csv": string "have_dynamic_loading": string "have_geometry": string "have_innodb": string "have_ndbcluster": string "have_openssl": string "have_partitioning": string "have_profiling": string "have_query_cache": string "have_rtree_keys": string "have_ssl": string "have_symlink": string "hostname": string "ignore_builtin_innodb": string "init_connect": string "init_file": string "init_slave": string "innodb_adaptive_flushing": string "innodb_adaptive_hash_index": string "innodb_additional_mem_pool_size": int "innodb_autoextend_increment": int "innodb_autoinc_lock_mode": int "innodb_buffer_pool_instances": int "innodb_buffer_pool_size": int "innodb_change_buffering": string "innodb_checksums": string "innodb_commit_concurrency": int "innodb_concurrency_tickets": int "innodb_data_file_path": string "innodb_data_home_dir": string "innodb_doublewrite": string "innodb_fast_shutdown": int "innodb_file_format": string "innodb_file_format_check": string "innodb_file_format_max": string "innodb_file_per_table": string "innodb_flush_log_at_trx_commit": int "innodb_flush_method": string "innodb_force_recovery": int "innodb_io_capacity": int "innodb_lock_wait_timeout": int "innodb_locks_unsafe_for_binlog": string "innodb_log_buffer_size": int "innodb_log_file_size": int "innodb_log_files_in_group": int "innodb_log_group_home_dir": string "innodb_max_dirty_pages_pct": int "innodb_max_purge_lag": int "innodb_mirrored_log_groups": int "innodb_old_blocks_pct": int "innodb_old_blocks_time": int "innodb_open_files": int "innodb_purge_batch_size": int "innodb_purge_threads": int "innodb_read_ahead_threshold": int "innodb_read_io_threads": int "innodb_replication_delay": int "innodb_rollback_on_timeout": string "innodb_spin_wait_delay": int "innodb_stats_method": string "innodb_stats_on_metadata": string "innodb_stats_sample_pages": int "innodb_strict_mode": string "innodb_support_xa": string "innodb_sync_spin_loops": int "innodb_table_locks": string "innodb_thread_concurrency": int "innodb_thread_sleep_delay": int "innodb_use_native_aio": string "innodb_use_sys_malloc": string "innodb_version": string "innodb_write_io_threads": int "interactive_timeout": int "join_buffer_size": int "keep_files_on_create": string "key_buffer_size": int "key_cache_age_threshold": int "key_cache_block_size": int "key_cache_division_limit": int "large_files_support": string "large_page_size": int "large_pages": string "lc_messages": string "lc_messages_dir": string "lc_time_names": string "license": string "local_infile": string "lock_wait_timeout": int "locked_in_memory": string "log": string "log_bin": string "log_bin_trust_function_creators": string "log_error": string "log_output": string "log_queries_not_using_indexes": string "log_slave_updates": string "log_slow_queries": string "log_warnings": int "long_query_time": float "low_priority_updates": string "lower_case_file_system": string "lower_case_table_names": int "max_allowed_packet": int "max_binlog_cache_size": int "max_binlog_size": int "max_binlog_stmt_cache_size": int "max_connect_errors": int "max_connections": int "max_delayed_threads": int "max_error_count": int "max_heap_table_size": int "max_insert_delayed_threads": int "max_join_size": int "max_length_for_sort_data": int "max_prepared_stmt_count": int "max_relay_log_size": int "max_seeks_for_key": int "max_sort_length": int "max_sp_recursion_depth": int "max_tmp_tables": int "max_user_connections": int "max_write_lock_count": int "min_examined_row_limit": int "multi_range_count": int "myisam_data_pointer_size": int "myisam_max_sort_file_size": int "myisam_mmap_size": int "myisam_recover_options": string "myisam_repair_threads": int "myisam_sort_buffer_size": int "myisam_stats_method": string "myisam_use_mmap": string "net_buffer_length": int "net_read_timeout": int "net_retry_count": int "net_write_timeout": int "new": string "old": string "old_alter_table": string "old_passwords": string "open_files_limit": int "optimizer_prune_level": int "optimizer_search_depth": int "optimizer_switch": string "performance_schema": string "performance_schema_events_waits_history_long_size": int "performance_schema_events_waits_history_size": int "performance_schema_max_cond_classes": int "performance_schema_max_cond_instances": int "performance_schema_max_file_classes": int "performance_schema_max_file_handles": int "performance_schema_max_file_instances": int "performance_schema_max_mutex_classes": int "performance_schema_max_mutex_instances": int "performance_schema_max_rwlock_classes": int "performance_schema_max_rwlock_instances": int "performance_schema_max_table_handles": int "performance_schema_max_table_instances": int "performance_schema_max_thread_classes": int "performance_schema_max_thread_instances": int "pid_file": string "plugin_dir": string "port": int "preload_buffer_size": int "profiling": string "profiling_history_size": int "protocol_version": int "query_alloc_block_size": int "query_cache_limit": int "query_cache_min_res_unit": int "query_cache_size": int "query_cache_type": string "query_cache_wlock_invalidate": string "query_prealloc_size": int "range_alloc_block_size": int "read_buffer_size": int "read_only": string "read_rnd_buffer_size": int "relay_log": string "relay_log_index": string "relay_log_info_file": string "relay_log_purge": string "relay_log_recovery": string "relay_log_space_limit": int "report_host": string "report_password": string "report_port": int "report_user": string "rpl_recovery_rank": int "secure_auth": string "secure_file_priv": string "server_id": int "skip_external_locking": string "skip_name_resolve": string "skip_networking": string "skip_show_database": string "slave_compressed_protocol": string "slave_exec_mode": string "slave_load_tmpdir": string "slave_net_timeout": int "slave_skip_errors": string "slave_transaction_retries": int "slave_type_conversions": string "slow_launch_time": int "slow_query_log": string "slow_query_log_file": string "socket": string "sort_buffer_size": int "sql_auto_is_null": string "sql_big_selects": string "sql_big_tables": string "sql_buffer_result": string "sql_log_bin": string "sql_log_off": string "sql_low_priority_updates": string "sql_max_join_size": int "sql_mode": string "sql_notes": string "sql_quote_show_create": string "sql_safe_updates": string "sql_select_limit": int "sql_slave_skip_counter": int "sql_warnings": string "ssl_ca": string "ssl_capath": string "ssl_cert": string "ssl_cipher": string "ssl_key": string "storage_engine": string "sync_binlog": int "sync_frm": string "sync_master_info": int "sync_relay_log": int "sync_relay_log_info": int "system_time_zone": string "table_definition_cache": int "table_open_cache": int "thread_cache_size": int "thread_concurrency": int "thread_handling": string "thread_stack": int "time_format": string "time_zone": string "timed_mutexes": string "tmp_table_size": int "tmpdir": string "transaction_alloc_block_size": int "transaction_prealloc_size": int "tx_isolation": string "unique_checks": string "updatable_views_with_limit": string "version": string "version_comment": string "version_compile_machine": string "version_compile_os": string "wait_timeout": int instances: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5": parent: ns: "mysql" class: "server" inst: "5a41ac04-115d-448f-a0ca-144eeb5ac8b5" values: "auto_increment_increment": 1 "auto_increment_offset": 1 "autocommit": "ON" "automatic_sp_privileges": "ON" "back_log": 50 "basedir": "/opt/mysql/5.5.10" "big_tables": "OFF" "binlog_cache_size": 32768 "binlog_direct_non_transactional_updates": "OFF" "binlog_format": "STATEMENT" "binlog_stmt_cache_size": 32768 "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": "/opt/mysql/5.5.10/share/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 "datadir": "/Users/mark/sandboxes/msb_5_5_10/data/" "date_format": "%Y-%m-%d" "datetime_format": "%Y-%m-%d %H:%i:%s" "default_storage_engine": "InnoDB" "default_week_format": 0 "delay_key_write": "ON" "delayed_insert_limit": 100 "delayed_insert_timeout": 300 "delayed_queue_size": 1000 "div_precision_increment": 4 "engine_condition_pushdown": "ON" "event_scheduler": "OFF" "expire_logs_days": 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": "/Users/mark/sandboxes/msb_5_5_10/data/Cerberus.log" "group_concat_max_len": 1024 "have_compress": "YES" "have_crypt": "YES" "have_csv": "YES" "have_dynamic_loading": "YES" "have_geometry": "YES" "have_innodb": "YES" "have_ndbcluster": "NO" "have_openssl": "DISABLED" "have_partitioning": "YES" "have_profiling": "YES" "have_query_cache": "YES" "have_rtree_keys": "YES" "have_ssl": "DISABLED" "have_symlink": "YES" "hostname": "Cerberus.local" "ignore_builtin_innodb": "OFF" "init_connect": "" "init_file": "" "init_slave": "" "innodb_adaptive_flushing": "ON" "innodb_adaptive_hash_index": "ON" "innodb_additional_mem_pool_size": 8388608 "innodb_autoextend_increment": 8 "innodb_autoinc_lock_mode": 1 "innodb_buffer_pool_instances": 1 "innodb_buffer_pool_size": 134217728 "innodb_change_buffering": "all" "innodb_checksums": "ON" "innodb_commit_concurrency": 0 "innodb_concurrency_tickets": 500 "innodb_data_file_path": "ibdata1:10M:autoextend" "innodb_data_home_dir": "/Users/mark/sandboxes/msb_5_5_10/data" "innodb_doublewrite": "ON" "innodb_fast_shutdown": 1 "innodb_file_format": "Antelope" "innodb_file_format_check": "ON" "innodb_file_format_max": "Antelope" "innodb_file_per_table": "OFF" "innodb_flush_log_at_trx_commit": 1 "innodb_flush_method": "" "innodb_force_recovery": 0 "innodb_io_capacity": 200 "innodb_lock_wait_timeout": 50 "innodb_locks_unsafe_for_binlog": "OFF" "innodb_log_buffer_size": 8388608 "innodb_log_file_size": 5242880 "innodb_log_files_in_group": 2 "innodb_log_group_home_dir": "/Users/mark/sandboxes/msb_5_5_10/data" "innodb_max_dirty_pages_pct": 75 "innodb_max_purge_lag": 0 "innodb_mirrored_log_groups": 1 "innodb_old_blocks_pct": 37 "innodb_old_blocks_time": 0 "innodb_open_files": 300 "innodb_purge_batch_size": 20 "innodb_purge_threads": 0 "innodb_read_ahead_threshold": 56 "innodb_read_io_threads": 4 "innodb_replication_delay": 0 "innodb_rollback_on_timeout": "OFF" "innodb_spin_wait_delay": 6 "innodb_stats_method": "nulls_equal" "innodb_stats_on_metadata": "ON" "innodb_stats_sample_pages": 8 "innodb_strict_mode": "OFF" "innodb_support_xa": "ON" "innodb_sync_spin_loops": 30 "innodb_table_locks": "ON" "innodb_thread_concurrency": 0 "innodb_thread_sleep_delay": 10000 "innodb_use_native_aio": "OFF" "innodb_use_sys_malloc": "ON" "innodb_version": "1.1.5" "innodb_write_io_threads": 4 "interactive_timeout": 28800 "join_buffer_size": 131072 "keep_files_on_create": "OFF" "key_buffer_size": 8388608 "key_cache_age_threshold": 300 "key_cache_block_size": 1024 "key_cache_division_limit": 100 "large_files_support": "ON" "large_page_size": 0 "large_pages": "OFF" "lc_messages": "en_US" "lc_messages_dir": "/opt/mysql/5.5.10/share/" "lc_time_names": "en_US" "license": "GPL" "local_infile": "ON" "lock_wait_timeout": 31536000 "locked_in_memory": "OFF" "log": "OFF" "log_bin": "OFF" "log_bin_trust_function_creators": "OFF" "log_error": "/Users/mark/sandboxes/msb_5_5_10/data/msandbox.err" "log_output": "FILE" "log_queries_not_using_indexes": "OFF" "log_slave_updates": "OFF" "log_slow_queries": "OFF" "log_warnings": 1 "long_query_time": 10.000000 "low_priority_updates": "OFF" "lower_case_file_system": "ON" "lower_case_table_names": 2 "max_allowed_packet": 1048576 "max_binlog_cache_size": 9223372036854775807 "max_binlog_size": 1073741824 "max_binlog_stmt_cache_size": 9223372036854775807 "max_connect_errors": 10 "max_connections": 151 "max_delayed_threads": 20 "max_error_count": 64 "max_heap_table_size": 16777216 "max_insert_delayed_threads": 20 "max_join_size": 9223372036854775807 "max_length_for_sort_data": 1024 "max_prepared_stmt_count": 16382 "max_relay_log_size": 0 "max_seeks_for_key": 9223372036854775807 "max_sort_length": 1024 "max_sp_recursion_depth": 0 "max_tmp_tables": 32 "max_user_connections": 0 "max_write_lock_count": 9223372036854775807 "min_examined_row_limit": 0 "multi_range_count": 256 "myisam_data_pointer_size": 6 "myisam_max_sort_file_size": 9223372036853727232 "myisam_mmap_size": 9223372036854775807 "myisam_recover_options": "OFF" "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": "OFF" "open_files_limit": 961 "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" "performance_schema": "ON" "performance_schema_events_waits_history_long_size": 10000 "performance_schema_events_waits_history_size": 10 "performance_schema_max_cond_classes": 80 "performance_schema_max_cond_instances": 1000 "performance_schema_max_file_classes": 50 "performance_schema_max_file_handles": 32768 "performance_schema_max_file_instances": 10000 "performance_schema_max_mutex_classes": 200 "performance_schema_max_mutex_instances": 1000000 "performance_schema_max_rwlock_classes": 30 "performance_schema_max_rwlock_instances": 1000000 "performance_schema_max_table_handles": 100000 "performance_schema_max_table_instances": 50000 "performance_schema_max_thread_classes": 50 "performance_schema_max_thread_instances": 1000 "pid_file": "/Users/mark/sandboxes/msb_5_5_10/data/mysql_sandbox5510.pid" "plugin_dir": "/opt/mysql/5.5.10/lib/plugin" "port": 5510 "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": 0 "query_cache_type": "ON" "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_index": "" "relay_log_info_file": "relay-log.info" "relay_log_purge": "ON" "relay_log_recovery": "OFF" "relay_log_space_limit": 0 "report_host": "" "report_password": "" "report_port": 3306 "report_user": "" "rpl_recovery_rank": 0 "secure_auth": "OFF" "secure_file_priv": "" "server_id": 0 "skip_external_locking": "ON" "skip_name_resolve": "OFF" "skip_networking": "OFF" "skip_show_database": "OFF" "slave_compressed_protocol": "OFF" "slave_exec_mode": "STRICT" "slave_load_tmpdir": "/Users/mark/sandboxes/msb_5_5_10/tmp" "slave_net_timeout": 3600 "slave_skip_errors": "OFF" "slave_transaction_retries": 10 "slave_type_conversions": "" "slow_launch_time": 2 "slow_query_log": "OFF" "slow_query_log_file": "/Users/mark/sandboxes/msb_5_5_10/data/Cerberus-slow.log" "socket": "/tmp/mysql_sandbox5510.sock" "sort_buffer_size": 2097152 "sql_auto_is_null": "OFF" "sql_big_selects": "ON" "sql_big_tables": "OFF" "sql_buffer_result": "OFF" "sql_log_bin": "ON" "sql_log_off": "OFF" "sql_low_priority_updates": "OFF" "sql_max_join_size": 9223372036854775807 "sql_mode": "" "sql_notes": "ON" "sql_quote_show_create": "ON" "sql_safe_updates": "OFF" "sql_select_limit": 9223372036854775807 "sql_slave_skip_counter": 0 "sql_warnings": "OFF" "ssl_ca": "" "ssl_capath": "" "ssl_cert": "" "ssl_cipher": "" "ssl_key": "" "storage_engine": "InnoDB" "sync_binlog": 0 "sync_frm": "ON" "sync_master_info": 0 "sync_relay_log": 0 "sync_relay_log_info": 0 "system_time_zone": "BST" "table_definition_cache": 400 "table_open_cache": 400 "thread_cache_size": 0 "thread_concurrency": 10 "thread_handling": "one-thread-per-connection" "thread_stack": 262144 "time_format": "%H:%i:%s" "time_zone": "SYSTEM" "timed_mutexes": "OFF" "tmp_table_size": 16777216 "tmpdir": "/Users/mark/sandboxes/msb_5_5_10/tmp" "transaction_alloc_block_size": 8192 "transaction_prealloc_size": 4096 "tx_isolation": "REPEATABLE-READ" "unique_checks": "ON" "updatable_views_with_limit": "YES" "version": "5.5.10" "version_comment": "MySQL Community Server (GPL)" "version_compile_machine": "i386" "version_compile_os": "osx10.5" "wait_timeout": 28800 "os": "cpu": attributes: "cpu_cache_size": int "cpu_idle": int "cpu_mhz": int "cpu_name": string "cpu_sys": int "cpu_user": int "cpu_vendor": string "cpu_wait": int instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "cpu_cache_size": 6144 "cpu_idle": 445505030 "cpu_mhz": 2660 "cpu_name": "MacBookPro5,1" "cpu_sys": 16662800 "cpu_user": 61729260 "cpu_vendor": "Intel" "cpu_wait": 0 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.1": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "cpu_cache_size": 6144 "cpu_idle": 442250880 "cpu_mhz": 2660 "cpu_name": "MacBookPro5,1" "cpu_sys": 16666100 "cpu_user": 64979620 "cpu_vendor": "Intel" "cpu_wait": 0 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "cpu_idle": 887755910 "cpu_sys": 33328900 "cpu_user": 126708880 "cpu_wait": 0 "disk": attributes: "disk_bytes_read": int "disk_bytes_written": int "disk_queue": float "disk_reads": int "disk_rtime": int "disk_servicetime": float "disk_snaptime": int "disk_time": int "disk_writes": int "disk_wtime": int instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./dev/disk0s2": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "disk_bytes_read": 43988611584 "disk_bytes_written": 101020259328 "disk_queue": undefined "disk_reads": 2345769 "disk_rtime": 30277904928886 "disk_servicetime": undefined "disk_snaptime": 0 "disk_time": 82791144798746 "disk_writes": 4273152 "disk_wtime": 52513239869860 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./dev/disk2s3": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "disk_bytes_read": 12241350656 "disk_bytes_written": 18404140032 "disk_queue": undefined "disk_reads": 866788 "disk_rtime": 1246544574065554 "disk_servicetime": undefined "disk_snaptime": 0 "disk_time": 1253115897960992 "disk_writes": 807016 "disk_wtime": 6571323895438 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "disk_bytes_read": 43988611584 "disk_bytes_written": 101020259328 "disk_queue": -3.000000 "disk_reads": 2345769 "disk_rtime": 30277904928886 "disk_servicetime": -3.000000 "disk_snaptime": 0 "disk_time": 82791144798746 "disk_writes": 4273152 "disk_wtime": 52513239869860 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.devfs": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.fdesc": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "fs": attributes: "fs_avail": int "fs_dev_name": string "fs_dir_name": string "fs_files": int "fs_flags": int "fs_free_files": int "fs_options": string "fs_sys_type_name": string "fs_total": int "fs_type_name": string "fs_unused": int "fs_used": int instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./": parent: ns: "os" class: "disk" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./dev/disk0s2" values: "fs_avail": 61485215744 "fs_dev_name": "/dev/disk0s2" "fs_dir_name": "/" "fs_files": 78058826 "fs_free_files": 15011039 "fs_options": "rw,local,rootfs" "fs_sys_type_name": "hfs" "fs_total": 319728959488 "fs_type_name": "local" "fs_unused": 61747359744 "fs_used": 257981599744 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./Volumes/My Book": parent: ns: "os" class: "disk" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./dev/disk2s3" values: "fs_avail": 717448986624 "fs_dev_name": "/dev/disk2s3" "fs_dir_name": "/Volumes/My Book" "fs_files": 243986164 "fs_free_files": 175158444 "fs_options": "rw,nosuid,nodev,local" "fs_sys_type_name": "hfs" "fs_total": 999367335936 "fs_type_name": "local" "fs_unused": 717448986624 "fs_used": 281918349312 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}./dev": parent: ns: "os" class: "disk" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.fdesc" values: "fs_avail": 0 "fs_dev_name": "fdesc" "fs_dir_name": "/dev" "fs_files": 8193 "fs_free_files": 7827 "fs_options": "rw,union" "fs_sys_type_name": "fdesc" "fs_total": 1024 "fs_type_name": "none" "fs_unused": 0 "fs_used": 1024 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all": parent: ns: "os" class: "disk" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all" values: "fs_avail": 61485215744 "fs_files": 78075212 "fs_free_files": 15026693 "fs_total": 319728961536 "fs_unused": 61747359744 "fs_used": 257981601792 "host": attributes: "host_id": string instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}": values: "loadavg": attributes: "0": float "1": float "2": float instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "0": 0.124023 "1": 0.356445 "2": 0.396484 "mem": attributes: "ram_total": int "ram_unused": int "swap_page_in": int "swap_page_out": int "swap_total": int "swap_unused": int instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "ram_total": 4294967296 "ram_unused": 655470592 "swap_page_in": 2031331 "swap_page_out": 1263303 "swap_total": 8589934592 "swap_unused": 1196916736 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "ram_total": 4294967296 "ram_unused": 655470592 "swap_page_in": 2031331 "swap_page_out": 1263303 "swap_total": 8589934592 "swap_unused": 1196916736 "net": attributes: "address": string "broadcast": string "description": string "destination": string "flags": int "hwaddr": string "metric": int "mtu": int "name": string "netmask": string "rx_bytes": int "rx_dropped": int "rx_errors": int "rx_frame": int "rx_overruns": int "rx_packets": int "speed": int "tx_bytes": int "tx_carrier": int "tx_collisions": int "tx_dropped": int "tx_errors": int "tx_overruns": int "tx_packets": int "type": string instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.all": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "rx_bytes": 4174709782 "rx_dropped": 0 "rx_errors": 0 "rx_frame": -4 "rx_overruns": -4 "rx_packets": 25383372 "speed": 20000000 "tx_bytes": 4038127879 "tx_carrier": -4 "tx_collisions": 0 "tx_dropped": -4 "tx_errors": 0 "tx_overruns": -4 "tx_packets": 28208781 "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.en0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "address": undefined "description": "en0" "destination": undefined "flags": 34915 "hwaddr": "00:25:00:A2:62:D6" "metric": 0 "mtu": 1500 "name": "en0" "netmask": undefined "rx_bytes": 0 "rx_dropped": 0 "rx_errors": 0 "rx_frame": undefined "rx_overruns": undefined "rx_packets": 0 "speed": 10000000 "tx_bytes": 342 "tx_carrier": undefined "tx_collisions": 0 "tx_dropped": undefined "tx_errors": 0 "tx_overruns": undefined "tx_packets": 0 "type": "Ethernet" "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.en1": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "address": "192.168.1.87" "description": "en1" "destination": undefined "flags": 34915 "hwaddr": "00:25:00:3D:17:37" "metric": 0 "mtu": 1356 "name": "en1" "netmask": "255.255.255.0" "rx_bytes": 1178610570 "rx_dropped": 0 "rx_errors": 0 "rx_frame": undefined "rx_overruns": undefined "rx_packets": 3108613 "speed": 10000000 "tx_bytes": 1042014336 "tx_carrier": undefined "tx_collisions": 0 "tx_dropped": undefined "tx_errors": 0 "tx_overruns": undefined "tx_packets": 5934137 "type": "Ethernet" "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.lo0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "address": "127.0.0.1" "description": "lo0" "destination": "127.0.0.1" "flags": 32841 "hwaddr": "00:00:00:00:00:00" "metric": 0 "mtu": 16384 "name": "lo0" "netmask": "255.0.0.0" "rx_bytes": 2996099212 "rx_dropped": 0 "rx_errors": 0 "rx_frame": undefined "rx_overruns": undefined "rx_packets": 22274759 "speed": 0 "tx_bytes": 2996113201 "tx_carrier": undefined "tx_collisions": 0 "tx_dropped": undefined "tx_errors": 0 "tx_overruns": undefined "tx_packets": 22274644 "type": "Local Loopback" "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.vboxnet0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "address": undefined "description": "vboxnet0" "destination": undefined "flags": 34882 "hwaddr": "0A:00:27:00:00:00" "metric": 0 "mtu": 1500 "name": "vboxnet0" "netmask": undefined "rx_bytes": 0 "rx_dropped": 0 "rx_errors": 0 "rx_frame": undefined "rx_overruns": undefined "rx_packets": 0 "speed": 0 "tx_bytes": 0 "tx_carrier": undefined "tx_collisions": 0 "tx_dropped": undefined "tx_errors": 0 "tx_overruns": undefined "tx_packets": 0 "type": "Ethernet" "os": attributes: "os_arch": string "os_description": string "os_machine": string "os_name": string "os_patchlevel": string "os_vendor": string "os_vendor_code_name": string "os_vendor_name": string "os_vendor_version": string "os_version": string instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.0": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "os_arch": "i386" "os_description": "Mac OS X Leopard" "os_machine": "i386" "os_name": "MacOSX" "os_patchlevel": "unknown" "os_vendor": "Apple" "os_vendor_code_name": "Leopard" "os_vendor_name": "Mac OS X" "os_vendor_version": "10.5" "os_version": "10.5.8" "proc": attributes: "egid": int "euid": int "gid": int "mem_major_faults": int "mem_minor_faults": int "mem_page_faults": int "mem_resident": int "mem_share": int "mem_size": int "name": string "nice": int "ppid": int "priority": int "processor": int "state": int "threads": int "time_start_time": int "time_sys": int "time_total": int "time_user": int "tty": int "uid": int instances: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}.28776": parent: ns: "os" class: "host" inst: "ssh:{86:17:98:e8:aa:c5:55:11:f8:a4:76:07:78:fb:5a:1e}" values: "egid": 20 "euid": 501 "gid": 20 "mem_major_faults": undefined "mem_minor_faults": undefined "mem_page_faults": 538756 "mem_resident": 2875392 "mem_share": undefined "mem_size": 91267072 "name": "mysql-monitor-ag" "nice": 0 "ppid": 28775 "priority": 24 "processor": undefined "state": 82 "threads": 10 "time_start_time": 1302616595525 "time_sys": 69711 "time_total": 130080 "time_user": 60369 "tty": undefined "uid": 501