Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?

This is a sample of report gathered by MariaDB.

Public stats, Feedback plugin

$ mysql -e 'select * from information_schema.feedback' > report.txt
$ curl -F data=@report.txt https://mariadb.org/feedback_plugin/post
VARIABLE_NAME	VARIABLE_VALUE
FEEDBACK_SERVER_UID	PdGrxCJZ2Ioh+6ogE29xWpjZwzI=
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE	-1
INNODB_FAST_SHUTDOWN	1
INNODB_FLUSH_LOG_AT_TIMEOUT	1
VERSION_SSL_LIBRARY	OpenSSL 1.0.2j  26 Sep 2016
VERSION	10.1.20-MariaDB
MAX_SP_RECURSION_DEPTH	0
THREAD_POOL_SIZE	4
SLOW_LAUNCH_TIME	2
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE	-1
BINLOG_FORMAT	STATEMENT
HAVE_SSL	DISABLED
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE	-1
MAX_RELAY_LOG_SIZE	1073741824
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE	-1
INNODB_FT_NUM_WORD_OPTIMIZE	2000
MAX_LENGTH_FOR_SORT_DATA	1024
NET_BUFFER_LENGTH	2048
INNODB_SORT_BUFFER_SIZE	1048576
PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE	100
EVENT_SCHEDULER	OFF
LARGE_FILES_SUPPORT	ON
FT_MAX_WORD_LEN	84
LARGE_PAGE_SIZE	0
CHARACTER_SET_RESULTS	utf8
RANGE_ALLOC_BLOCK_SIZE	4096
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE	-1
PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH	1024
CHARACTER_SET_CONNECTION	utf8
INTERACTIVE_TIMEOUT	28800
BINLOG_STMT_CACHE_SIZE	32768
CHARACTER_SET_DATABASE	utf8
SQL_BIG_SELECTS	ON
PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE	100
TRANSACTION_ALLOC_BLOCK_SIZE	8192
CONNECT_TIMEOUT	10
INNODB_FLUSHING_AVG_LOOPS	30
KEY_CACHE_FILE_HASH_SIZE	512
LOWER_CASE_FILE_SYSTEM	ON
SQL_AUTO_IS_NULL	OFF
INNODB_FORCE_PRIMARY_KEY	OFF
MYISAM_DATA_POINTER_SIZE	6
PERFORMANCE_SCHEMA_DIGESTS_SIZE	-1
HAVE_RTREE_KEYS	YES
MAX_DIGEST_LENGTH	1024
MAX_SORT_LENGTH	1024
MAX_BINLOG_SIZE	1073741824
QUERY_CACHE_MIN_RES_UNIT	4096
SORT_BUFFER_SIZE	65536
JOIN_BUFFER_SIZE	262144
INNODB_ROLLBACK_ON_TIMEOUT	OFF
AUTO_INCREMENT_OFFSET	1
INNODB_ADDITIONAL_MEM_POOL_SIZE	8388608
LOCK_WAIT_TIMEOUT	31536000
PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE	-1
INNODB_FILE_FORMAT	Antelope
DELAYED_QUEUE_SIZE	1000
ARIA_LOG_FILE_SIZE	1073741824
CHARACTER_SET_CLIENT	utf8
QUERY_CACHE_SIZE	1048576
QUERY_ALLOC_BLOCK_SIZE	16384
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE	-1
COLLATION_SERVER	utf8_general_ci
SQL_LOG_BIN	ON
MAX_HEAP_TABLE_SIZE	16777216
PERFORMANCE_SCHEMA_USERS_SIZE	-1
NET_RETRY_COUNT	10
THREAD_POOL_IDLE_TIMEOUT	60
LOG_OUTPUT	FILE
CHARACTER_SET_SYSTEM	utf8
CHARACTER_SET_SERVER	utf8
LOWER_CASE_TABLE_NAMES	2
NET_WRITE_TIMEOUT	60
MAX_CONNECTIONS	151
MAX_BINLOG_CACHE_SIZE	18446744073709547520
QUERY_PREALLOC_SIZE	24576
QUERY_CACHE_TYPE	OFF
SQL_SLAVE_SKIP_COUNTER	0
HAVE_DYNAMIC_LOADING	YES
OLD_PASSWORDS	OFF
OPTIMIZER_PRUNE_LEVEL	1
LARGE_PAGES	OFF
HAVE_QUERY_CACHE	YES
OLD	OFF
READ_BUFFER_SIZE	262144
KEY_BUFFER_SIZE	16384
QUERY_CACHE_WLOCK_INVALIDATE	OFF
VERSION_COMMENT	Homebrew
OPTIMIZER_USE_CONDITION_SELECTIVITY	1
SLAVE_NET_TIMEOUT	3600
OPTIMIZER_SWITCH	index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
TIMED_MUTEXES	OFF
SQL_WARNINGS	OFF
INNODB_SYNC_ARRAY_SIZE	1
INNODB_FOREGROUND_PREFLUSH	EXPONENTIAL_BACKOFF
VERSION_COMPILE_MACHINE	x86_64
TABLE_DEFINITION_CACHE	400
OPTIMIZER_SEARCH_DEPTH	62
LOG_BIN	OFF
THREAD_HANDLING	one-thread-per-connection
METADATA_LOCKS_CACHE_SIZE	1024
MYISAM_BLOCK_SIZE	1024
MAX_BINLOG_STMT_CACHE_SIZE	18446744073709547520
INNODB_PURGE_BATCH_SIZE	300
TMP_TABLE_SIZE	16777216
MAX_USER_CONNECTIONS	0
BINLOG_CACHE_SIZE	32768
INNODB_LOCK_WAIT_TIMEOUT	50
LC_TIME_NAMES	en_US
PERFORMANCE_SCHEMA_HOSTS_SIZE	-1
FEEDBACK_SEND_RETRY_WAIT	60
HAVE_PROFILING	YES
AUTO_INCREMENT_INCREMENT	1
PRELOAD_BUFFER_SIZE	32768
COLLATION_DATABASE	utf8_general_ci
HAVE_GEOMETRY	YES
INNODB_LOG_BUFFER_SIZE	16777216
HOST_CACHE_SIZE	279
MYISAM_MAX_SORT_FILE_SIZE	9223372036853727232
COLLATION_CONNECTION	utf8_general_ci
OLD_MODE	
BULK_INSERT_BUFFER_SIZE	8388608
WSREP_MAX_WS_SIZE	2147483647
HAVE_COMPRESS	YES
MYISAM_REPAIR_THREADS	1
THREAD_CACHE_SIZE	0
OLD_ALTER_TABLE	OFF
FEEDBACK_SEND_TIMEOUT	60
HAVE_CRYPT	YES
HAVE_OPENSSL	YES
INNODB_CHANGE_BUFFER_MAX_SIZE	25
SYNC_BINLOG	0
INNODB_FT_MIN_TOKEN_SIZE	3
INNODB_FT_USER_STOPWORD_TABLE	
ARIA_MAX_SORT_FILE_SIZE	9223372036853727232
NET_READ_TIMEOUT	30
MAX_JOIN_SIZE	18446744073709551615
INNODB_FT_ENABLE_STOPWORD	ON
PROFILING_HISTORY_SIZE	15
SQL_NOTES	ON
READ_RND_BUFFER_SIZE	262144
PROFILING	OFF
WAIT_TIMEOUT	28800
ARIA_PAGECACHE_BUFFER_SIZE	134217728
SECURE_AUTH	ON
MRR_BUFFER_SIZE	262144
LOG_TC_SIZE	24576
QUERY_CACHE_STRIP_COMMENTS	OFF
SQL_BUFFER_RESULT	OFF
INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD	600
ARIA_SORT_BUFFER_SIZE	268434432
MYISAM_RECOVER_OPTIONS	DEFAULT
INNODB_FILE_PER_TABLE	ON
MYISAM_MMAP_SIZE	18446744073709551615
ARIA_BLOCK_SIZE	8192
ROWID_MERGE_BUFF_SIZE	8388608
INNODB_MAX_BITMAP_FILE_SIZE	104857600
TIME_ZONE	SYSTEM
KEY_CACHE_BLOCK_SIZE	1024
INNODB_FT_RESULT_CACHE_LIMIT	2000000000
MAX_WRITE_LOCK_COUNT	4294967295
SQL_LOG_OFF	OFF
MYISAM_STATS_METHOD	NULLS_UNEQUAL
INNODB_FILE_FORMAT_CHECK	ON
FEEDBACK_URL	https://mariadb.org/feedback_plugin/post
VERSION_MALLOC_LIBRARY	system
FT_MIN_WORD_LEN	4
INNODB_FLUSH_METHOD	
FEEDBACK_HTTP_PROXY	
INNODB_PAGE_SIZE	16384
STORAGE_ENGINE	InnoDB
INNODB_FORCE_RECOVERY	0
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE	-1
MYISAM_USE_MMAP	OFF
INNODB_FT_CACHE_SIZE	8000000
INNODB_FLUSH_LOG_AT_TRX_COMMIT	1
SQL_SAFE_UPDATES	OFF
MAX_PREPARED_STMT_COUNT	16382
DELAYED_INSERT_TIMEOUT	300
INNODB_FT_MAX_TOKEN_SIZE	84
INNODB_FT_SERVER_STOPWORD_TABLE	
INNODB_FILE_FORMAT_MAX	Antelope
INNODB_ONLINE_ALTER_LOG_MAX_SIZE	134217728
INNODB_FT_SORT_PLL_DEGREE	2
INNODB_LOG_BLOCK_SIZE	512
SQL_QUOTE_SHOW_CREATE	ON
TABLE_OPEN_CACHE	4
INNODB_FT_AUX_TABLE	
FEEDBACK_USER_INFO	
MYISAM_SORT_BUFFER_SIZE	134216704
INNODB_FORCE_LOAD_CORRUPTED	OFF
MAX_LONG_DATA_SIZE	1048576
CHARACTER_SET_FILESYSTEM	binary
INNODB_FT_TOTAL_CACHE_SIZE	640000000
TRANSACTION_PREALLOC_SIZE	4096
VERSION_COMPILE_OS	osx10.11
MAX_ALLOWED_PACKET	1048576
INNODB_BUFFER_POOL_SIZE	134217728
INNODB_LOG_FILE_SIZE	50331648
INNODB_FAKE_CHANGES	OFF
HISTOGRAM_SIZE	0
QUERY_CACHE_LIMIT	1048576
SQL_SELECT_LIMIT	18446744073709551615
INNODB_FT_ENABLE_DIAG_PRINT	OFF
OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT	100
HAVE_SYMLINK	YES
INNODB_FLUSH_NEIGHBORS	1
SQL_MODE	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ARIA_PAGECACHE_FILE_HASH_SIZE	512
ABORTED_CLIENTS	0
ABORTED_CONNECTS	0
ACCESS_DENIED_ERRORS	0
ACL_COLUMN_GRANTS	0
ACL_DATABASE_GRANTS	2
ACL_FUNCTION_GRANTS	0
ACL_PROCEDURE_GRANTS	0
ACL_PROXY_USERS	2
ACL_ROLE_GRANTS	0
ACL_ROLES	0
ACL_TABLE_GRANTS	0
ACL_USERS	6
ARIA_PAGECACHE_BLOCKS_NOT_FLUSHED	0
ARIA_PAGECACHE_BLOCKS_UNUSED	15706
ARIA_PAGECACHE_BLOCKS_USED	3
ARIA_PAGECACHE_READ_REQUESTS	57
ARIA_PAGECACHE_READS	1
ARIA_PAGECACHE_WRITE_REQUESTS	3
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	0
BINLOG_STMT_CACHE_DISK_USE	0
BINLOG_STMT_CACHE_USE	0
BUSY_TIME	0.000000
BYTES_RECEIVED	814
BYTES_SENT	26725
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	0
COM_CHANGE_MASTER	0
COM_CHECK	0
COM_CHECKSUM	0
COM_COMMIT	0
COM_COMPOUND_SQL	0
COM_CREATE_DB	0
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	0
COM_CREATE_TEMPORARY_TABLE	0
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_ROLE	0
COM_DROP_SERVER	0
COM_DROP_TABLE	0
COM_DROP_TEMPORARY_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_GET_DIAGNOSTICS	0
COM_GRANT	0
COM_GRANT_ROLE	0
COM_HA_CLOSE	0
COM_HA_OPEN	0
COM_HA_READ	0
COM_HELP	0
COM_INSERT	0
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	6
COM_SET_OPTION	0
COM_SHOW_AUTHORS	0
COM_SHOW_BINLOG_EVENTS	0
COM_SHOW_BINLOGS	0
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	0
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	0
COM_SHOW_FUNCTION_STATUS	0
COM_SHOW_GENERIC	0
COM_SHOW_GRANTS	0
COM_SHOW_KEYS	0
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	0
COM_SHOW_STORAGE_ENGINES	0
COM_SHOW_TABLE_STATUS	0
COM_SHOW_TABLES	0
COM_SHOW_TRIGGERS	0
COM_SHOW_VARIABLES	0
COM_SHOW_WARNINGS	0
COM_SHUTDOWN	0
COM_SIGNAL	0
COM_START_ALL_SLAVES	0
COM_START_SLAVE	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_STOP_ALL_SLAVES	0
COM_STOP_SLAVE	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
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	6
CPU_TIME	0.000000
CREATED_TMP_DISK_TABLES	1
CREATED_TMP_FILES	5
CREATED_TMP_TABLES	3
DELAYED_ERRORS	0
DELAYED_INSERT_THREADS	0
DELAYED_WRITES	0
DELETE_SCAN	0
EMPTY_QUERIES	0
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	0
HANDLER_DELETE	0
HANDLER_DISCOVER	0
HANDLER_EXTERNAL_LOCK	0
HANDLER_ICP_ATTEMPTS	0
HANDLER_ICP_MATCH	0
HANDLER_MRR_INIT	0
HANDLER_MRR_KEY_REFILLS	0
HANDLER_MRR_ROWID_REFILLS	0
HANDLER_PREPARE	0
HANDLER_READ_FIRST	3
HANDLER_READ_KEY	0
HANDLER_READ_LAST	0
HANDLER_READ_NEXT	0
HANDLER_READ_PREV	0
HANDLER_READ_RETRY	0
HANDLER_READ_RND	0
HANDLER_READ_RND_DELETED	0
HANDLER_READ_RND_NEXT	925
HANDLER_ROLLBACK	0
HANDLER_SAVEPOINT	0
HANDLER_SAVEPOINT_ROLLBACK	0
HANDLER_TMP_UPDATE	0
HANDLER_TMP_WRITE	1113
HANDLER_UPDATE	0
HANDLER_WRITE	0
INNODB_AVAILABLE_UNDO_LOGS	128
INNODB_BACKGROUND_LOG_SYNC	93
INNODB_BUFFER_POOL_BYTES_DATA	2539520
INNODB_BUFFER_POOL_BYTES_DIRTY	0
INNODB_BUFFER_POOL_DUMP_STATUS	Dumping buffer pool(s) not yet started
INNODB_BUFFER_POOL_LOAD_STATUS	Loading buffer pool(s) not yet started
INNODB_BUFFER_POOL_PAGES_DATA	155
INNODB_BUFFER_POOL_PAGES_DIRTY	0
INNODB_BUFFER_POOL_PAGES_FLUSHED	1
INNODB_BUFFER_POOL_PAGES_FREE	8036
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	0
INNODB_BUFFER_POOL_PAGES_OLD	0
INNODB_BUFFER_POOL_PAGES_TOTAL	8191
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	451
INNODB_BUFFER_POOL_READS	156
INNODB_BUFFER_POOL_WAIT_FREE	0
INNODB_BUFFER_POOL_WRITE_REQUESTS	1
INNODB_CHECKPOINT_AGE	0
INNODB_CHECKPOINT_MAX_AGE	80826164
INNODB_DATA_FSYNCS	5
INNODB_DATA_PENDING_FSYNCS	0
INNODB_DATA_PENDING_READS	0
INNODB_DATA_PENDING_WRITES	0
INNODB_DATA_READ	2675200
INNODB_DATA_READS	173
INNODB_DATA_WRITES	5
INNODB_DATA_WRITTEN	34304
INNODB_DBLWR_PAGES_WRITTEN	1
INNODB_DBLWR_WRITES	1
INNODB_DEADLOCKS	0
INNODB_HAVE_ATOMIC_BUILTINS	ON
INNODB_HISTORY_LIST_LENGTH	0
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	0
INNODB_LOG_WRITES	1
INNODB_LSN_CURRENT	1622908
INNODB_LSN_FLUSHED	1622908
INNODB_LSN_LAST_CHECKPOINT	1622908
INNODB_MASTER_THREAD_ACTIVE_LOOPS	1
INNODB_MASTER_THREAD_IDLE_LOOPS	92
INNODB_MAX_TRX_ID	5380
INNODB_MEM_ADAPTIVE_HASH	2217568
INNODB_MEM_DICTIONARY	648542
INNODB_MEM_TOTAL	141361152
INNODB_MUTEX_OS_WAITS	1
INNODB_MUTEX_SPIN_ROUNDS	60
INNODB_MUTEX_SPIN_WAITS	27
INNODB_OLDEST_VIEW_LOW_LIMIT_TRX_ID	0
INNODB_OS_LOG_FSYNCS	3
INNODB_OS_LOG_PENDING_FSYNCS	0
INNODB_OS_LOG_PENDING_WRITES	0
INNODB_OS_LOG_WRITTEN	512
INNODB_PAGE_SIZE	16384
INNODB_PAGES_CREATED	0
INNODB_PAGES_READ	155
INNODB_PAGES0_READ	4
INNODB_PAGES_WRITTEN	1
INNODB_PURGE_TRX_ID	0
INNODB_PURGE_UNDO_NO	0
INNODB_READ_VIEWS_MEMORY	88
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	0
INNODB_ROWS_READ	0
INNODB_ROWS_UPDATED	0
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	2
INNODB_S_LOCK_SPIN_ROUNDS	60
INNODB_S_LOCK_SPIN_WAITS	2
INNODB_TRUNCATED_STATUS_WRITES	0
INNODB_X_LOCK_OS_WAITS	0
INNODB_X_LOCK_SPIN_ROUNDS	0
INNODB_X_LOCK_SPIN_WAITS	0
INNODB_PAGE_COMPRESSION_SAVED	0
INNODB_PAGE_COMPRESSION_TRIM_SECT512	0
INNODB_PAGE_COMPRESSION_TRIM_SECT1024	0
INNODB_PAGE_COMPRESSION_TRIM_SECT2048	0
INNODB_PAGE_COMPRESSION_TRIM_SECT4096	0
INNODB_PAGE_COMPRESSION_TRIM_SECT8192	0
INNODB_PAGE_COMPRESSION_TRIM_SECT16384	0
INNODB_PAGE_COMPRESSION_TRIM_SECT32768	0
INNODB_NUM_INDEX_PAGES_WRITTEN	0
INNODB_NUM_NON_INDEX_PAGES_WRITTEN	5
INNODB_NUM_PAGES_PAGE_COMPRESSED	0
INNODB_NUM_PAGE_COMPRESSED_TRIM_OP	0
INNODB_NUM_PAGE_COMPRESSED_TRIM_OP_SAVED	0
INNODB_NUM_PAGES_PAGE_DECOMPRESSED	0
INNODB_NUM_PAGES_PAGE_COMPRESSION_ERROR	0
INNODB_NUM_PAGES_ENCRYPTED	0
INNODB_NUM_PAGES_DECRYPTED	0
INNODB_HAVE_LZ4	OFF
INNODB_HAVE_LZO	OFF
INNODB_HAVE_LZMA	ON
INNODB_HAVE_BZIP2	ON
INNODB_HAVE_SNAPPY	OFF
INNODB_DEFRAGMENT_COMPRESSION_FAILURES	0
INNODB_DEFRAGMENT_FAILURES	0
INNODB_DEFRAGMENT_COUNT	0
INNODB_ONLINEDDL_ROWLOG_ROWS	0
INNODB_ONLINEDDL_ROWLOG_PCT_USED	0
INNODB_ONLINEDDL_PCT_PROGRESS	0
INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS	0
INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS_AVOIDED	0
INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_CACHE	0
INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_DISK	0
INNODB_ENCRYPTION_ROTATION_PAGES_MODIFIED	0
INNODB_ENCRYPTION_ROTATION_PAGES_FLUSHED	0
INNODB_ENCRYPTION_ROTATION_ESTIMATED_IOPS	0
INNODB_SCRUB_BACKGROUND_PAGE_REORGANIZATIONS	0
INNODB_SCRUB_BACKGROUND_PAGE_SPLITS	0
INNODB_SCRUB_BACKGROUND_PAGE_SPLIT_FAILURES_UNDERFLOW	0
INNODB_SCRUB_BACKGROUND_PAGE_SPLIT_FAILURES_OUT_OF_FILESPACE	0
INNODB_SCRUB_BACKGROUND_PAGE_SPLIT_FAILURES_MISSING_INDEX	0
INNODB_SCRUB_BACKGROUND_PAGE_SPLIT_FAILURES_UNKNOWN	0
INNODB_ENCRYPTION_NUM_KEY_REQUESTS	0
KEY_BLOCKS_NOT_FLUSHED	0
KEY_BLOCKS_UNUSED	8
KEY_BLOCKS_USED	0
KEY_BLOCKS_WARM	0
KEY_READ_REQUESTS	0
KEY_READS	0
KEY_WRITE_REQUESTS	0
KEY_WRITES	0
LAST_QUERY_COST	0.000000
MASTER_GTID_WAIT_COUNT	0
MASTER_GTID_WAIT_TIME	0
MASTER_GTID_WAIT_TIMEOUTS	0
MAX_STATEMENT_TIME_EXCEEDED	0
MAX_USED_CONNECTIONS	1
MEMORY_USED	140305952
NOT_FLUSHED_DELAYED_ROWS	0
OPEN_FILES	11
OPEN_STREAMS	0
OPEN_TABLE_DEFINITIONS	18
OPEN_TABLES	4
OPENED_FILES	81
OPENED_PLUGIN_LIBRARIES	0
OPENED_TABLE_DEFINITIONS	17
OPENED_TABLES	19
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	1
QCACHE_FREE_MEMORY	1031312
QCACHE_HITS	0
QCACHE_INSERTS	0
QCACHE_LOWMEM_PRUNES	0
QCACHE_NOT_CACHED	0
QCACHE_QUERIES_IN_CACHE	0
QCACHE_TOTAL_BLOCKS	1
QUERIES	8
QUESTIONS	8
ROWS_READ	10
ROWS_SENT	853
ROWS_TMP_READ	904
RPL_STATUS	AUTH_MASTER
SELECT_FULL_JOIN	0
SELECT_FULL_RANGE_JOIN	0
SELECT_RANGE	0
SELECT_RANGE_CHECK	0
SELECT_SCAN	3
SLAVE_CONNECTIONS	0
SLAVE_HEARTBEAT_PERIOD	0.000
SLAVE_OPEN_TEMP_TABLES	0
SLAVE_RECEIVED_HEARTBEATS	0
SLAVE_RETRIED_TRANSACTIONS	0
SLAVE_RUNNING	OFF
SLAVE_SKIPPED_ERRORS	0
SLAVES_CONNECTED	0
SLAVES_RUNNING	0
SLOW_LAUNCH_THREADS	0
SLOW_QUERIES	0
SORT_MERGE_PASSES	0
SORT_PRIORITY_QUEUE_SORTS	0
SORT_RANGE	0
SORT_ROWS	0
SORT_SCAN	0
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	2
TABLE_LOCKS_IMMEDIATE	21
TABLE_LOCKS_WAITED	0
TC_LOG_MAX_PAGES_USED	0
TC_LOG_PAGE_SIZE	4096
TC_LOG_PAGE_WAITS	0
THREADPOOL_IDLE_THREADS	0
THREADPOOL_THREADS	0
THREADS_CACHED	0
THREADS_CONNECTED	1
THREADS_CREATED	3
THREADS_RUNNING	1
UPDATE_SCAN	0
UPTIME	94
UPTIME_SINCE_FLUSH_STATUS	94
WSREP_CLUSTER_CONF_ID	18446744073709551615
WSREP_CLUSTER_SIZE	0
WSREP_CLUSTER_STATE_UUID	
WSREP_CLUSTER_STATUS	Disconnected
WSREP_CONNECTED	OFF
WSREP_LOCAL_BF_ABORTS	0
WSREP_LOCAL_INDEX	18446744073709551615
WSREP_PROVIDER_NAME	
WSREP_PROVIDER_VENDOR	
WSREP_PROVIDER_VERSION	
WSREP_READY	OFF
WSREP_THREAD_COUNT	0
binlog version	1.0
binlog used	0
mysql_native_password version	1.0
mysql_native_password used	0
mysql_old_password version	1.0
mysql_old_password used	0
wsrep version	1.0
wsrep used	0
CSV version	1.0
CSV used	0
MEMORY version	1.0
MEMORY used	2
MyISAM version	1.0
MyISAM used	38
MRG_MyISAM version	1.0
MRG_MyISAM used	0
CLIENT_STATISTICS version	2.0
CLIENT_STATISTICS used	0
INDEX_STATISTICS version	2.0
INDEX_STATISTICS used	0
TABLE_STATISTICS version	2.0
TABLE_STATISTICS used	0
USER_STATISTICS version	2.0
USER_STATISTICS used	0
Aria version	1.5
Aria used	1
PERFORMANCE_SCHEMA version	0.1
PERFORMANCE_SCHEMA used	0
SEQUENCE version	1.0
SEQUENCE used	0
InnoDB version	5.6
InnoDB used	3
XTRADB_READ_VIEW version	5.6
XTRADB_READ_VIEW used	0
XTRADB_INTERNAL_HASH_TABLES version	5.6
XTRADB_INTERNAL_HASH_TABLES used	0
XTRADB_RSEG version	5.6
XTRADB_RSEG used	0
INNODB_TRX version	5.6
INNODB_TRX used	0
INNODB_LOCKS version	5.6
INNODB_LOCKS used	0
INNODB_LOCK_WAITS version	5.6
INNODB_LOCK_WAITS used	0
INNODB_CMP version	5.6
INNODB_CMP used	0
INNODB_CMP_RESET version	5.6
INNODB_CMP_RESET used	0
INNODB_CMPMEM version	5.6
INNODB_CMPMEM used	0
INNODB_CMPMEM_RESET version	5.6
INNODB_CMPMEM_RESET used	0
INNODB_CMP_PER_INDEX version	5.6
INNODB_CMP_PER_INDEX used	0
INNODB_CMP_PER_INDEX_RESET version	5.6
INNODB_CMP_PER_INDEX_RESET used	0
INNODB_BUFFER_PAGE version	5.6
INNODB_BUFFER_PAGE used	0
INNODB_BUFFER_PAGE_LRU version	5.6
INNODB_BUFFER_PAGE_LRU used	0
INNODB_BUFFER_POOL_STATS version	5.6
INNODB_BUFFER_POOL_STATS used	0
INNODB_METRICS version	5.6
INNODB_METRICS used	0
INNODB_FT_DEFAULT_STOPWORD version	5.6
INNODB_FT_DEFAULT_STOPWORD used	0
INNODB_FT_DELETED version	5.6
INNODB_FT_DELETED used	0
INNODB_FT_BEING_DELETED version	5.6
INNODB_FT_BEING_DELETED used	0
INNODB_FT_CONFIG version	5.6
INNODB_FT_CONFIG used	0
INNODB_FT_INDEX_CACHE version	5.6
INNODB_FT_INDEX_CACHE used	0
INNODB_FT_INDEX_TABLE version	5.6
INNODB_FT_INDEX_TABLE used	0
INNODB_SYS_TABLES version	5.6
INNODB_SYS_TABLES used	0
INNODB_SYS_TABLESTATS version	5.6
INNODB_SYS_TABLESTATS used	0
INNODB_SYS_INDEXES version	5.6
INNODB_SYS_INDEXES used	0
INNODB_SYS_COLUMNS version	5.6
INNODB_SYS_COLUMNS used	0
INNODB_SYS_FIELDS version	5.6
INNODB_SYS_FIELDS used	0
INNODB_SYS_FOREIGN version	5.6
INNODB_SYS_FOREIGN used	0
INNODB_SYS_FOREIGN_COLS version	5.6
INNODB_SYS_FOREIGN_COLS used	0
INNODB_SYS_TABLESPACES version	5.6
INNODB_SYS_TABLESPACES used	0
INNODB_SYS_DATAFILES version	5.6
INNODB_SYS_DATAFILES used	0
INNODB_CHANGED_PAGES version	1.0
INNODB_CHANGED_PAGES used	0
INNODB_MUTEXES version	5.6
INNODB_MUTEXES used	0
INNODB_SYS_SEMAPHORE_WAITS version	5.6
INNODB_SYS_SEMAPHORE_WAITS used	0
INNODB_TABLESPACES_ENCRYPTION version	5.6
INNODB_TABLESPACES_ENCRYPTION used	0
INNODB_TABLESPACES_SCRUBBING version	5.6
INNODB_TABLESPACES_SCRUBBING used	0
CHANGED_PAGE_BITMAPS version	5.6
CHANGED_PAGE_BITMAPS used	0
FEEDBACK version	1.1
FEEDBACK used	2
partition version	1.0
partition used	0
Cpu_count	4
Mem_total	8589934592
Now	1482011427
Uname_sysname	Darwin
Uname_release	15.6.0
Uname_version	Darwin Kernel Version 15.6.0: Mon Aug 29 20:21:34 PDT 2016; root:xnu-3248.60.11~1/RELEASE_X86_64
Uname_machine	x86_64
Collation used latin1_swedish_ci	7
Collation used utf8_general_ci	2
Collation used latin1_bin	1
Collation used binary	6
Collation used utf8_bin	110
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment