Monitoring interface for MySQL with PCF
Foreword
This document details a strategy for ensuring a MySQL cluster in cloud foundry is running properly.
- To use the RESTful interface for monitoring a PCF MySQL installation, you must download and install the PCF MySQL Admin API Proxy.
- One instance of the Admin API will monitor one MySQL Cluster.
Overview
This recipe covers two steps for monitoring and discovering the state of your PCF MySQL installation. The first step is a simple "is it running" API which simply PINGs the MySQL Cluster to verify it is responding. The second section details more complex monitoring which can be used for performance analysis, scaling and statistical analysis.
Deploy the admin API
Download the application jar file and the manifest.
- Using the cf CLI, perform the following:
- cf push mysql-api -f manifest.yml -p target/mysql-monitor-api-0.0.2-SNAPSHOT.jar
- cf bind-service mysql-api mySqlServiceName
Your API will be reachable at https://mysql-api.your.cfinstallation.com The admin jar was built from the following source repo: https://github.com/swiftbird/mysql-monitor-api
Is my MySQL Cluster Running
The simplest approach to verifying a PCF MySQL cluster is happy is to execute the ping API
HTTP Method | API Path | Description |
---|---|---|
GET | /admin/ping | Intended for use by monitoring tools. If everything is working correctly, will return HTTP status 200 with a JSON response similar to: {"resultCode": "200","resultMessage": "Connection Successful","resultData": {"Ping": "PONG"}} |
Detailed Performance Monitoring
The MySQL Admin APIs expose many useful features for performance tuning and application monitoring. The sections available to monitor are:
- DatabaseMetaData -- Information about the Server including version and URL.
- Performance -- Performance event data showing DB exception event summaries
- GlobalStatus -- Detailed Client, Performance and configuration stats
HTTP Method | API Path | Description |
---|---|---|
GET | /admin/ping | Sends a PING request to the MySQL Cluster. {"resultCode":"200","resultMessage":"Connection Successful","resultData":{"Ping":"PONG"}} |
GET | /admin/info | A complete list of all sections above |
GET | /admin/info/{section} | The details about the section of data. The section name is case sensitive, use the details above. |
API Output
##. API Result from /admin/ping
{
"resultCode": "200",
"resultMessage": "Connection Successful",
"resultData": {
"Ping": "PONG"
}
}
API Result from /admin/info
{
"resultCode": "200",
"resultMessage": "Connection Successful",
"resultData": {
"DatabaseMetaData": {
"URL": "jdbc:mysql://192.168.8.210:3306/cf_cfc7c0ff_8150_446f_90bc_25366fb07078?user=OTW2aChteFmE4UJq&password=mz1c0DxQTq1lLHk9",
"Product": "MySQL",
"Version": "5.5.5-10.0.22-MariaDB-wsrep"
},
"Performance": {
"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_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_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_thread_classes_lost": "0",
"Performance_schema_thread_instances_lost": "0",
"Performance_schema_users_lost": "0"
},
"GlobalStatus": {
"ABORTED_CLIENTS": "80",
"ABORTED_CONNECTS": "226",
"ACCESS_DENIED_ERRORS": "233",
"ARIA_PAGECACHE_BLOCKS_NOT_FLUSHED": "0",
"ARIA_PAGECACHE_BLOCKS_UNUSED": "15736",
"ARIA_PAGECACHE_BLOCKS_USED": "2",
"ARIA_PAGECACHE_READ_REQUESTS": "979",
"ARIA_PAGECACHE_READS": "75",
"ARIA_PAGECACHE_WRITE_REQUESTS": "150",
"ARIA_PAGECACHE_WRITES": "0",
"ARIA_TRANSACTION_LOG_SYNCS": "0",
"BINLOG_COMMITS": "0",
"BINLOG_GROUP_COMMITS": "0",
"BINLOG_GROUP_COMMIT_TRIGGER_COUNT": "0",
"BINLOG_GROUP_COMMIT_TRIGGER_LOCK_WAIT": "0",
"BINLOG_GROUP_COMMIT_TRIGGER_TIMEOUT": "0",
"BINLOG_SNAPSHOT_FILE": "",
"BINLOG_SNAPSHOT_POSITION": "0",
"BINLOG_BYTES_WRITTEN": "0",
"BINLOG_CACHE_DISK_USE": "0",
"BINLOG_CACHE_USE": "7397",
"BINLOG_STMT_CACHE_DISK_USE": "0",
"BINLOG_STMT_CACHE_USE": "0",
"BUSY_TIME": "0.000000",
"BYTES_RECEIVED": "144941222",
"BYTES_SENT": "104980584",
"COM_ADMIN_COMMANDS": "19917",
"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": "4",
"COM_ALTER_TABLESPACE": "0",
"COM_ANALYZE": "0",
"COM_ASSIGN_TO_KEYCACHE": "0",
"COM_BEGIN": "7",
"COM_BINLOG": "0",
"COM_CALL_PROCEDURE": "0",
"COM_CHANGE_DB": "17638",
"COM_CHANGE_MASTER": "0",
"COM_CHECK": "0",
"COM_CHECKSUM": "0",
"COM_COMMIT": "1264",
"COM_CREATE_DB": "5",
"COM_CREATE_EVENT": "0",
"COM_CREATE_FUNCTION": "0",
"COM_CREATE_INDEX": "0",
"COM_CREATE_PROCEDURE": "0",
"COM_CREATE_ROLE": "0",
"COM_CREATE_SERVER": "0",
"COM_CREATE_TABLE": "75",
"COM_CREATE_TRIGGER": "0",
"COM_CREATE_UDF": "0",
"COM_CREATE_USER": "6",
"COM_CREATE_VIEW": "0",
"COM_DEALLOC_SQL": "0",
"COM_DELETE": "93",
"COM_DELETE_MULTI": "0",
"COM_DO": "0",
"COM_DROP_DB": "2",
"COM_DROP_EVENT": "0",
"COM_DROP_FUNCTION": "0",
"COM_DROP_INDEX": "0",
"COM_DROP_PROCEDURE": "0",
"COM_DROP_ROLE": "0",
"COM_DROP_SERVER": "0",
"COM_DROP_TABLE": "62",
"COM_DROP_TRIGGER": "0",
"COM_DROP_USER": "4",
"COM_DROP_VIEW": "0",
"COM_EMPTY_QUERY": "0",
"COM_EXECUTE_SQL": "0",
"COM_FLUSH": "12",
"COM_GET_DIAGNOSTICS": "0",
"COM_GRANT": "360",
"COM_GRANT_ROLE": "0",
"COM_HA_CLOSE": "0",
"COM_HA_OPEN": "0",
"COM_HA_READ": "0",
"COM_HELP": "0",
"COM_INSERT": "7382",
"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_REVOKE_ROLE": "0",
"COM_ROLLBACK": "0",
"COM_ROLLBACK_TO_SAVEPOINT": "0",
"COM_SAVEPOINT": "0",
"COM_SELECT": "245218",
"COM_SET_OPTION": "7182",
"COM_SHOW_AUTHORS": "0",
"COM_SHOW_BINLOG_EVENTS": "0",
"COM_SHOW_BINLOGS": "0",
"COM_SHOW_CHARSETS": "0",
"COM_SHOW_CLIENT_STATISTICS": "0",
"COM_SHOW_COLLATIONS": "1177",
"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": "38",
"COM_SHOW_CREATE_TRIGGER": "0",
"COM_SHOW_DATABASES": "6",
"COM_SHOW_ENGINE_LOGS": "0",
"COM_SHOW_ENGINE_MUTEX": "0",
"COM_SHOW_ENGINE_STATUS": "0",
"COM_SHOW_ERRORS": "0",
"COM_SHOW_EVENTS": "0",
"COM_SHOW_EXPLAIN": "0",
"COM_SHOW_FIELDS": "72",
"COM_SHOW_FUNCTION_STATUS": "0",
"COM_SHOW_GRANTS": "4",
"COM_SHOW_INDEX_STATISTICS": "0",
"COM_SHOW_KEYS": "26",
"COM_SHOW_MASTER_STATUS": "0",
"COM_SHOW_OPEN_TABLES": "0",
"COM_SHOW_PLUGINS": "0",
"COM_SHOW_PRIVILEGES": "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": "0",
"COM_SHOW_STATUS": "136769",
"COM_SHOW_STORAGE_ENGINES": "0",
"COM_SHOW_TABLE_STATISTICS": "0",
"COM_SHOW_TABLE_STATUS": "0",
"COM_SHOW_TABLES": "67",
"COM_SHOW_TRIGGERS": "0",
"COM_SHOW_USER_STATISTICS": "0",
"COM_SHOW_VARIABLES": "138009",
"COM_SHOW_WARNINGS": "21",
"COM_SHUTDOWN": "0",
"COM_SIGNAL": "0",
"COM_START_ALL_SLAVES": "0",
"COM_START_SLAVE": "0",
"COM_STMT_CLOSE": "13",
"COM_STMT_EXECUTE": "13",
"COM_STMT_FETCH": "0",
"COM_STMT_PREPARE": "13",
"COM_STMT_REPREPARE": "0",
"COM_STMT_RESET": "0",
"COM_STMT_SEND_LONG_DATA": "0",
"COM_STOP_ALL_SLAVES": "0",
"COM_STOP_SLAVE": "0",
"COM_TRUNCATE": "0",
"COM_UNINSTALL_PLUGIN": "0",
"COM_UNLOCK_TABLES": "0",
"COM_UPDATE": "1150",
"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",
"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": "5645",
"CPU_TIME": "0.000000",
"CREATED_TMP_DISK_TABLES": "2238395",
"CREATED_TMP_FILES": "5",
"CREATED_TMP_TABLES": "16951708",
"DELAYED_ERRORS": "0",
"DELAYED_INSERT_THREADS": "0",
"DELAYED_WRITES": "0",
"EMPTY_QUERIES": "241448",
"EXECUTED_EVENTS": "0",
"EXECUTED_TRIGGERS": "0",
"FEATURE_DELAY_KEY_WRITE": "0",
"FEATURE_DYNAMIC_COLUMNS": "0",
"FEATURE_FULLTEXT": "0",
"FEATURE_GIS": "0",
"FEATURE_LOCALE": "0",
"FEATURE_SUBQUERY": "0",
"FEATURE_TIMEZONE": "0",
"FEATURE_TRIGGER": "0",
"FEATURE_XML": "0",
"FLUSH_COMMANDS": "1",
"HANDLER_COMMIT": "510456",
"HANDLER_DELETE": "25",
"HANDLER_DISCOVER": "0",
"HANDLER_EXTERNAL_LOCK": "0",
"HANDLER_ICP_ATTEMPTS": "8",
"HANDLER_ICP_MATCH": "8",
"HANDLER_MRR_INIT": "0",
"HANDLER_MRR_KEY_REFILLS": "0",
"HANDLER_MRR_ROWID_REFILLS": "0",
"HANDLER_PREPARE": "22282",
"HANDLER_READ_FIRST": "59",
"HANDLER_READ_KEY": "114604029",
"HANDLER_READ_LAST": "0",
"HANDLER_READ_NEXT": "42866999",
"HANDLER_READ_PREV": "0",
"HANDLER_READ_RND": "75",
"HANDLER_READ_RND_DELETED": "576409",
"HANDLER_READ_RND_NEXT": "170338801",
"HANDLER_ROLLBACK": "0",
"HANDLER_SAVEPOINT": "0",
"HANDLER_SAVEPOINT_ROLLBACK": "0",
"HANDLER_TMP_UPDATE": "31448398",
"HANDLER_TMP_WRITE": "192295715",
"HANDLER_UPDATE": "506",
"HANDLER_WRITE": "7394",
"INNODB_AVAILABLE_UNDO_LOGS": "128",
"INNODB_BACKGROUND_LOG_SYNC": "68570",
"INNODB_BUFFER_POOL_BYTES_DATA": "79396864",
"INNODB_BUFFER_POOL_BYTES_DIRTY": "1245184",
"INNODB_BUFFER_POOL_DUMP_STATUS": "not started",
"INNODB_BUFFER_POOL_LOAD_STATUS": "not started",
"INNODB_BUFFER_POOL_PAGES_DATA": "4831",
"INNODB_BUFFER_POOL_PAGES_DIRTY": "76",
"INNODB_BUFFER_POOL_PAGES_FLUSHED": "4226",
"INNODB_BUFFER_POOL_PAGES_FREE": "126212",
"INNODB_BUFFER_POOL_PAGES_LRU_FLUSHED": "0",
"INNODB_BUFFER_POOL_PAGES_MADE_NOT_YOUNG": "0",
"INNODB_BUFFER_POOL_PAGES_MADE_YOUNG": "0",
"INNODB_BUFFER_POOL_PAGES_MISC": "21",
"INNODB_BUFFER_POOL_PAGES_OLD": "1846",
"INNODB_BUFFER_POOL_PAGES_TOTAL": "131064",
"INNODB_BUFFER_POOL_READ_AHEAD": "0",
"INNODB_BUFFER_POOL_READ_AHEAD_EVICTED": "0",
"INNODB_BUFFER_POOL_READ_AHEAD_RND": "0",
"INNODB_BUFFER_POOL_READ_REQUESTS": "2227792653",
"INNODB_BUFFER_POOL_READS": "4528",
"INNODB_BUFFER_POOL_WAIT_FREE": "0",
"INNODB_BUFFER_POOL_WRITE_REQUESTS": "59634",
"INNODB_CHECKPOINT_AGE": "30100",
"INNODB_CHECKPOINT_MAX_AGE": "1738750649",
"INNODB_DATA_FSYNCS": "16664",
"INNODB_DATA_PENDING_FSYNCS": "0",
"INNODB_DATA_PENDING_READS": "0",
"INNODB_DATA_PENDING_WRITES": "0",
"INNODB_DATA_READ": "74010624",
"INNODB_DATA_READS": "5027",
"INNODB_DATA_WRITES": "19370",
"INNODB_DATA_WRITTEN": "151029248",
"INNODB_DBLWR_PAGES_WRITTEN": "4226",
"INNODB_DBLWR_WRITES": "124",
"INNODB_DEADLOCKS": "0",
"INNODB_HAVE_ATOMIC_BUILTINS": "ON",
"INNODB_HISTORY_LIST_LENGTH": "434",
"INNODB_IBUF_DISCARDED_DELETE_MARKS": "0",
"INNODB_IBUF_DISCARDED_DELETES": "0",
"INNODB_IBUF_DISCARDED_INSERTS": "0",
"INNODB_IBUF_FREE_LIST": "0",
"INNODB_IBUF_MERGED_DELETE_MARKS": "0",
"INNODB_IBUF_MERGED_DELETES": "0",
"INNODB_IBUF_MERGED_INSERTS": "0",
"INNODB_IBUF_MERGES": "0",
"INNODB_IBUF_SEGMENT_SIZE": "2",
"INNODB_IBUF_SIZE": "1",
"INNODB_LOG_WAITS": "0",
"INNODB_LOG_WRITE_REQUESTS": "8548",
"INNODB_LOG_WRITES": "16006",
"INNODB_LSN_CURRENT": "40368866383",
"INNODB_LSN_FLUSHED": "40368866383",
"INNODB_LSN_LAST_CHECKPOINT": "40368836283",
"INNODB_MASTER_THREAD_ACTIVE_LOOPS": "68125",
"INNODB_MASTER_THREAD_IDLE_LOOPS": "462",
"INNODB_MAX_TRX_ID": "179114987",
"INNODB_MEM_ADAPTIVE_HASH": "37931296",
"INNODB_MEM_DICTIONARY": "11735974",
"INNODB_MEM_TOTAL": "2197815296",
"INNODB_MUTEX_OS_WAITS": "17820",
"INNODB_MUTEX_SPIN_ROUNDS": "4766713",
"INNODB_MUTEX_SPIN_WAITS": "4586689",
"INNODB_OLDEST_VIEW_LOW_LIMIT_TRX_ID": "0",
"INNODB_OS_LOG_FSYNCS": "16119",
"INNODB_OS_LOG_PENDING_FSYNCS": "0",
"INNODB_OS_LOG_PENDING_WRITES": "0",
"INNODB_OS_LOG_WRITTEN": "12493824",
"INNODB_OS_MERGE_BUFFERS_WRITTEN": "0",
"INNODB_OS_MERGE_BUFFERS_READ": "0",
"INNODB_OS_MERGE_BUFFERS_MERGED": "0",
"INNODB_PAGE_SIZE": "16384",
"INNODB_PAGES_CREATED": "304",
"INNODB_PAGES_READ": "4527",
"INNODB_PAGES_WRITTEN": "4226",
"INNODB_PURGE_TRX_ID": "179114113",
"INNODB_PURGE_UNDO_NO": "0",
"INNODB_READ_VIEWS_MEMORY": "4792",
"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": "17",
"INNODB_ROWS_INSERTED": "7382",
"INNODB_ROWS_READ": "28170413",
"INNODB_ROWS_UPDATED": "500",
"INNODB_SYSTEM_ROWS_DELETED": "0",
"INNODB_SYSTEM_ROWS_INSERTED": "0",
"INNODB_SYSTEM_ROWS_READ": "0",
"INNODB_SYSTEM_ROWS_UPDATED": "0",
"INNODB_S_LOCK_OS_WAITS": "33778",
"INNODB_S_LOCK_SPIN_ROUNDS": "17650839",
"INNODB_S_LOCK_SPIN_WAITS": "979520",
"INNODB_TRUNCATED_STATUS_WRITES": "0",
"INNODB_X_LOCK_OS_WAITS": "2482219",
"INNODB_X_LOCK_SPIN_ROUNDS": "229142395",
"INNODB_X_LOCK_SPIN_WAITS": "19292386",
"KEY_BLOCKS_NOT_FLUSHED": "0",
"KEY_BLOCKS_UNUSED": "107146",
"KEY_BLOCKS_USED": "27",
"KEY_BLOCKS_WARM": "0",
"KEY_READ_REQUESTS": "3310",
"KEY_READS": "107",
"KEY_WRITE_REQUESTS": "70",
"KEY_WRITES": "70",
"LAST_QUERY_COST": "0.000000",
"MAX_USED_CONNECTIONS": "70",
"MEMORY_USED": "285645472",
"NOT_FLUSHED_DELAYED_ROWS": "0",
"OPEN_FILES": "65",
"OPEN_STREAMS": "0",
"OPEN_TABLE_DEFINITIONS": "400",
"OPEN_TABLES": "400",
"OPENED_FILES": "87346192",
"OPENED_PLUGIN_LIBRARIES": "0",
"OPENED_TABLE_DEFINITIONS": "68726846",
"OPENED_TABLES": "113218736",
"OPENED_VIEWS": "0",
"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_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_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_THREAD_CLASSES_LOST": "0",
"PERFORMANCE_SCHEMA_THREAD_INSTANCES_LOST": "0",
"PERFORMANCE_SCHEMA_USERS_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": "562127",
"QUESTIONS": "562094",
"ROWS_READ": "68563143",
"ROWS_SENT": "602736",
"ROWS_TMP_READ": "174677311",
"RPL_STATUS": "AUTH_MASTER",
"SELECT_FULL_JOIN": "335754",
"SELECT_FULL_RANGE_JOIN": "0",
"SELECT_RANGE": "0",
"SELECT_RANGE_CHECK": "0",
"SELECT_SCAN": "853413",
"SLAVE_HEARTBEAT_PERIOD": "0.000",
"SLAVE_OPEN_TEMP_TABLES": "0",
"SLAVE_RECEIVED_HEARTBEATS": "0",
"SLAVE_RETRIED_TRANSACTIONS": "0",
"SLAVE_RUNNING": "OFF",
"SLOW_LAUNCH_THREADS": "0",
"SLOW_QUERIES": "0",
"SORT_MERGE_PASSES": "0",
"SORT_PRIORITY_QUEUE_SORTS": "6",
"SORT_RANGE": "0",
"SORT_ROWS": "75",
"SORT_SCAN": "223856",
"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_SERVER_NOT_AFTER": "",
"SSL_SERVER_NOT_BEFORE": "",
"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": "",
"SUBQUERY_CACHE_HIT": "0",
"SUBQUERY_CACHE_MISS": "0",
"SYNCS": "483585",
"TABLE_LOCKS_IMMEDIATE": "472895",
"TABLE_LOCKS_WAITED": "14",
"TC_LOG_MAX_PAGES_USED": "0",
"TC_LOG_PAGE_SIZE": "0",
"TC_LOG_PAGE_WAITS": "0",
"THREADPOOL_IDLE_THREADS": "0",
"THREADPOOL_THREADS": "0",
"THREADS_CACHED": "0",
"THREADS_CONNECTED": "68",
"THREADS_CREATED": "5642",
"THREADS_RUNNING": "1",
"UPTIME": "68668",
"UPTIME_SINCE_FLUSH_STATUS": "68668",
"WSREP_LOCAL_STATE_UUID": "ca05cda8-f508-11e4-9d52-eaad26fdb94f",
"WSREP_PROTOCOL_VERSION": "7",
"WSREP_LAST_COMMITTED": "75606131",
"WSREP_REPLICATED": "7925",
"WSREP_REPLICATED_BYTES": "2563056",
"WSREP_REPL_KEYS": "40199",
"WSREP_REPL_KEYS_BYTES": "503867",
"WSREP_REPL_DATA_BYTES": "1551989",
"WSREP_REPL_OTHER_BYTES": "0",
"WSREP_RECEIVED": "73",
"WSREP_RECEIVED_BYTES": "3043",
"WSREP_LOCAL_COMMITS": "7397",
"WSREP_LOCAL_CERT_FAILURES": "0",
"WSREP_LOCAL_REPLAYS": "0",
"WSREP_LOCAL_SEND_QUEUE": "0",
"WSREP_LOCAL_SEND_QUEUE_MAX": "2",
"WSREP_LOCAL_SEND_QUEUE_MIN": "0",
"WSREP_LOCAL_SEND_QUEUE_AVG": "0.000125",
"WSREP_LOCAL_RECV_QUEUE": "0",
"WSREP_LOCAL_RECV_QUEUE_MAX": "1",
"WSREP_LOCAL_RECV_QUEUE_MIN": "0",
"WSREP_LOCAL_RECV_QUEUE_AVG": "0.000000",
"WSREP_LOCAL_CACHED_DOWNTO": "75598206",
"WSREP_FLOW_CONTROL_PAUSED_NS": "6154374781",
"WSREP_FLOW_CONTROL_PAUSED": "0.000090",
"WSREP_FLOW_CONTROL_SENT": "0",
"WSREP_FLOW_CONTROL_RECV": "56",
"WSREP_CERT_DEPS_DISTANCE": "22.116578",
"WSREP_APPLY_OOOE": "0.000000",
"WSREP_APPLY_OOOL": "0.000000",
"WSREP_APPLY_WINDOW": "1.000000",
"WSREP_COMMIT_OOOE": "0.000000",
"WSREP_COMMIT_OOOL": "0.000000",
"WSREP_COMMIT_WINDOW": "1.000000",
"WSREP_LOCAL_STATE": "4",
"WSREP_LOCAL_STATE_COMMENT": "Synced",
"WSREP_CERT_INDEX_SIZE": "101",
"WSREP_CAUSAL_READS": "0",
"WSREP_CERT_INTERVAL": "0.000000",
"WSREP_INCOMING_ADDRESSES": "192.168.8.203:3306,192.168.8.202:3306,192.168.8.206:3306",
"WSREP_EVS_DELAYED": "",
"WSREP_EVS_EVICT_LIST": "",
"WSREP_EVS_REPL_LATENCY": "0/0/0/0/0",
"WSREP_EVS_STATE": "OPERATIONAL",
"WSREP_GCOMM_UUID": "c950b613-0cc2-11e6-b783-b39bac3952dd",
"WSREP_CLUSTER_CONF_ID": "76",
"WSREP_CLUSTER_SIZE": "3",
"WSREP_CLUSTER_STATE_UUID": "ca05cda8-f508-11e4-9d52-eaad26fdb94f",
"WSREP_CLUSTER_STATUS": "Primary",
"WSREP_CONNECTED": "ON",
"WSREP_LOCAL_BF_ABORTS": "0",
"WSREP_LOCAL_INDEX": "1",
"WSREP_PROVIDER_NAME": "Galera",
"WSREP_PROVIDER_VENDOR": "Codership Oy <info@codership.com>",
"WSREP_PROVIDER_VERSION": "3.9(rXXXX)",
"WSREP_READY": "ON",
"WSREP_THREAD_COUNT": "2"
}
}
}