系统表介绍
GLOBAL_VARIABLES 表描述了全局系统变量
列名 | 含义 |
---|---|
VARIABLE_NAME | 变量名 |
VARIABLE_VALUE | 变量值 |
实例
mysql> select * from global_variables ;
+----------------------------------------------------------+---------------------------------------------------------------------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+----------------------------------------------------------+---------------------------------------------------------------------------------+
| PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE | -1 |
| SQL_MODE | NO_ENGINE_SUBSTITUTION |
| TABLE_OPEN_CACHE_INSTANCES | 16 |
| SLAVE_CHECKPOINT_PERIOD | 300 |
| PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK | 10 |
| SKIP_NAME_RESOLVE | OFF |
| INNODB_FLUSH_LOG_AT_TIMEOUT | 1 |
| PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES | -1 |
| RPL_STOP_SLAVE_TIMEOUT | 31536000 |
| MIN_EXAMINED_ROW_LIMIT | 0 |
| VERSION_COMPILE_OS | el7 |
| UNIQUE_CHECKS | ON |
| LOG_SLOW_ADMIN_STATEMENTS | OFF |
| INNODB_API_BK_COMMIT_INTERVAL | 5 |
| INNODB_STATS_TRANSIENT_SAMPLE_PAGES | 8 |
| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 |
| SLOW_LAUNCH_TIME | 2 |
| PERFORMANCE_SCHEMA_MAX_COND_CLASSES | 80 |
| BINLOG_TRANSACTION_DEPENDENCY_TRACKING | COMMIT_ORDER |
| PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | -1 |
| INNODB_ADAPTIVE_HASH_INDEX_PARTS | 8 |
| PERFORMANCE_SCHEMA | ON |
| GTID_EXECUTED_COMPRESSION_PERIOD | 1000 |
| AUTO_INCREMENT_INCREMENT | 1 |
| MAX_TMP_TABLES | 32 |
| BINLOG_FORMAT | ROW |
| INNODB_FT_NUM_WORD_OPTIMIZE | 2000 |
| PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | -1 |
| SLAVE_ROWS_SEARCH_ALGORITHMS | TABLE_SCAN,INDEX_SCAN |
| READ_ONLY | OFF |
| TMP_TABLE_SIZE | 16777216 |
| KEY_CACHE_BLOCK_SIZE | 1024 |
| REPORT_HOST | |
| PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES | 210 |
| MYISAM_SORT_BUFFER_SIZE | 8388608 |
| JOIN_BUFFER_SIZE | 262144 |
| INNODB_ROLLBACK_SEGMENTS | 128 |
| PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES | 50 |
| LARGE_FILES_SUPPORT | ON |
| PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | -1 |
| ENFORCE_GTID_CONSISTENCY | OFF |
| NET_RETRY_COUNT | 10 |
| NET_BUFFER_LENGTH | 16384 |
| FT_STOPWORD_FILE | (built-in) |
| SKIP_SHOW_DATABASE | OFF |
| PERFORMANCE_SCHEMA_DIGESTS_SIZE | 10000 |
| GROUP_CONCAT_MAX_LEN | 1024 |
| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 |
| RANGE_ALLOC_BLOCK_SIZE | 4096 |
| PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE | 10 |
| SUPER_READ_ONLY | OFF |
| LOG_SLAVE_UPDATES | OFF |
| INNODB_TMPDIR | |
| PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE | -1 |
| TRANSACTION_PREALLOC_SIZE | 4096 |
| PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES | 150 |
| MYISAM_RECOVER_OPTIONS | OFF |
| CHARACTER_SET_CONNECTION | utf8mb4 |
| SHA256_PASSWORD_PROXY_USERS | OFF |
| PERFORMANCE_SCHEMA_MAX_INDEX_STAT | -1 |
| LOW_PRIORITY_UPDATES | OFF |
| MAX_JOIN_SIZE | 18446744073709551615 |
| REPORT_PASSWORD | |
| PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | -1 |
| MAX_INSERT_DELAYED_THREADS | 20 |
| DEFAULT_PASSWORD_LIFETIME | 0 |
| SQL_BIG_SELECTS | ON |
| LOCAL_INFILE | ON |
| TRANSACTION_ALLOC_BLOCK_SIZE | 8192 |
| PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH | 1024 |
| INNODB_FLUSHING_AVG_LOOPS | 30 |
| BIND_ADDRESS | * |
| SYNC_FRM | ON |
| MAX_POINTS_IN_GEOMETRY | 65536 |
| THREAD_STACK | 262144 |
| SLAVE_EXEC_MODE | STRICT |
| PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE | 10 |
| INNODB_IO_CAPACITY_MAX | 2000 |
| CHARACTER_SETS_DIR | /usr/local/mysql57/share/charsets/ |
| INNODB_IO_CAPACITY | 200 |
| PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH | 1024 |
| INNODB_FT_ENABLE_DIAG_PRINT | OFF |
| AUTOMATIC_SP_PRIVILEGES | ON |
| HAVE_SYMLINK | DISABLED |
| CHARACTER_SET_RESULTS | utf8mb4 |
| MAX_BINLOG_CACHE_SIZE | 18446744073709547520 |
| BACK_LOG | 250 |
| INNODB_TABLE_LOCKS | ON |
| VERSION_COMPILE_MACHINE | x86_64 |
| INNODB_AUTOEXTEND_INCREMENT | 64 |
| EXPLICIT_DEFAULTS_FOR_TIMESTAMP | ON |
| MYISAM_DATA_POINTER_SIZE | 6 |
| COMPLETION_TYPE | NO_CHAIN |
| INNODB_THREAD_SLEEP_DELAY | 10000 |
| PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE | 10000 |
| SQL_AUTO_IS_NULL | OFF |
| INIT_FILE | |
| SLAVE_TRANSACTION_RETRIES | 10 |
| OPEN_FILES_LIMIT | 65536 |
| INNODB_LOG_GROUP_HOME_DIR | ./ |
| GENERAL_LOG | OFF |
| OPTIMIZER_PRUNE_LEVEL | 1 |
| INNODB_STATUS_OUTPUT_LOCKS | OFF |
| LOG_SYSLOG_FACILITY | daemon |
| QUERY_CACHE_MIN_RES_UNIT | 4096 |
| MAX_LENGTH_FOR_SORT_DATA | 1024 |
| NGRAM_TOKEN_SIZE | 2 |
| INNODB_NUMA_INTERLEAVE | OFF |
| INNODB_ROLLBACK_ON_TIMEOUT | OFF |
| PRELOAD_BUFFER_SIZE | 32768 |
| PROFILING | OFF |
| FT_QUERY_EXPANSION_LIMIT | 20 |
| LARGE_PAGE_SIZE | 0 |
| CONCURRENT_INSERT | AUTO |
| READ_RND_BUFFER_SIZE | 262144 |
| INNODB_LARGE_PREFIX | ON |
| INNODB_FILE_FORMAT | Barracuda |
| PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES | -1 |
| BIG_TABLES | OFF |
| BINLOG_ROWS_QUERY_LOG_EVENTS | OFF |
| OPTIMIZER_SEARCH_DEPTH | 62 |
| LC_MESSAGES_DIR | /usr/local/mysql57/share/ |
| RELAY_LOG_BASENAME | /data/mysql/etlbi-relay-bin |
| BLOCK_ENCRYPTION_MODE | aes-128-ecb |
| LARGE_PAGES | OFF |
| PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES | 10 |
| INNODB_ADAPTIVE_MAX_SLEEP_DELAY | 150000 |
| MASTER_INFO_REPOSITORY | FILE |
| REPORT_PORT | 3306 |
| LOG_QUERIES_NOT_USING_INDEXES | OFF |
| BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES | OFF |
| INIT_SLAVE | |
| INNODB_STRICT_MODE | ON |
| PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES | 193 |
| THREAD_HANDLING | one-thread-per-connection |
| SHOW_COMPATIBILITY_56 | ON |
| SQL_LOG_BIN | ON |
| PERFORMANCE_SCHEMA_MAX_FILE_CLASSES | 80 |
| PERFORMANCE_SCHEMA_USERS_SIZE | -1 |
| RELAY_LOG_RECOVERY | OFF |
| SHOW_OLD_TEMPORALS | OFF |
| CONNECT_TIMEOUT | 10 |
| TMPDIR | /tmp |
| MYSQL_NATIVE_PASSWORD_PROXY_USERS | OFF |
| SLAVE_PENDING_JOBS_SIZE_MAX | 16777216 |
| EQ_RANGE_INDEX_DIVE_LIMIT | 200 |
| PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT | -1 |
| AUTO_INCREMENT_OFFSET | 1 |
| DISCONNECT_ON_EXPIRED_PASSWORD | ON |
| PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES | 50 |
| BINLOG_GTID_SIMPLE_RECOVERY | ON |
| QUERY_CACHE_TYPE | OFF |
| INNODB_AUTOINC_LOCK_MODE | 1 |
| MAX_BINLOG_SIZE | 1073741824 |
| MAX_ERROR_COUNT | 64 |
| LOWER_CASE_TABLE_NAMES | 1 |
| BINLOG_GROUP_COMMIT_SYNC_NO_DELAY_COUNT | 0 |
| INNODB_BUFFER_POOL_FILENAME | ib_buffer_pool |
| RBR_EXEC_MODE | STRICT |
| INNODB_MAX_PURGE_LAG_DELAY | 0 |
| OFFLINE_MODE | OFF |
| INNODB_BUFFER_POOL_DUMP_NOW | OFF |
| PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES | 320 |
| INNODB_SYNC_SPIN_LOOPS | 30 |
| BINLOG_ERROR_ACTION | ABORT_SERVER |
| INNODB_STATUS_OUTPUT | OFF |
| LOWER_CASE_FILE_SYSTEM | OFF |
| INNODB_UNDO_LOG_TRUNCATE | OFF |
| LOG_BIN | ON |
| INNODB_ADAPTIVE_HASH_INDEX | ON |
| MAX_DIGEST_LENGTH | 1024 |
| SESSION_TRACK_SCHEMA | ON |
| LOG_SYSLOG | OFF |
| SLAVE_LOAD_TMPDIR | /tmp |
| KEY_CACHE_AGE_THRESHOLD | 300 |
| INNODB_API_ENABLE_BINLOG | OFF |
| BINLOG_ORDER_COMMITS | ON |
| SSL_CRL | |
| LOG_ERROR | stderr |
| INNODB_FLUSH_METHOD | |
| SQL_LOG_OFF | OFF |
| SHOW_CREATE_TABLE_VERBOSITY | OFF |
| MAX_USER_CONNECTIONS | 0 |
| GTID_EXECUTED | |
| LONG_QUERY_TIME | 10.000000 |
| INNODB_LOG_COMPRESSED_PAGES | ON |
| LOG_ERROR_VERBOSITY | 3 |
| INNODB_DISABLE_SORT_FILE_CACHE | OFF |
| MAX_SEEKS_FOR_KEY | 18446744073709551615 |
| OLD_PASSWORDS | 0 |
| BINLOG_GROUP_COMMIT_SYNC_DELAY | 0 |
| HAVE_DYNAMIC_LOADING | YES |
| BULK_INSERT_BUFFER_SIZE | 8388608 |
| SYNC_BINLOG | 1 |
| QUERY_ALLOC_BLOCK_SIZE | 8192 |
| INNODB_PRINT_ALL_DEADLOCKS | OFF |
| WAIT_TIMEOUT | 28800 |
| INNODB_FT_SERVER_STOPWORD_TABLE | |
| END_MARKERS_IN_JSON | OFF |
| OLD | OFF |
| CHARACTER_SET_SERVER | utf8mb4 |
| INNODB_MAX_DIRTY_PAGES_PCT | 75.000000 |
| FLUSH | OFF |
| MAX_HEAP_TABLE_SIZE | 16777216 |
| CHARACTER_SET_FILESYSTEM | binary |
| KEY_BUFFER_SIZE | 8388608 |
| PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | 10 |
| SYNC_MASTER_INFO | 10000 |
| QUERY_PREALLOC_SIZE | 8192 |
| SYNC_RELAY_LOG | 10000 |
| LOG_WARNINGS | 2 |
| INNODB_FAST_SHUTDOWN | 1 |
| OPTIMIZER_TRACE_FEATURES | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
| INNODB_MAX_UNDO_LOG_SIZE | 1073741824 |
| OPTIMIZER_TRACE_OFFSET | -1 |
| SKIP_EXTERNAL_LOCKING | ON |
| HAVE_SSL | YES |
| SLAVE_NET_TIMEOUT | 60 |
| NET_WRITE_TIMEOUT | 60 |
| INNODB_STATS_SAMPLE_PAGES | 8 |
| PERFORMANCE_SCHEMA_ACCOUNTS_SIZE | -1 |
| INNODB_FLUSH_NEIGHBORS | 1 |
| QUERY_CACHE_SIZE | 1048576 |
| INNODB_DATA_FILE_PATH | ibdata1:12M:autoextend |
| QUERY_CACHE_LIMIT | 1048576 |
| INNODB_ADAPTIVE_FLUSHING_LWM | 10 |
| MAX_CONNECT_ERRORS | 100 |
| OLD_ALTER_TABLE | OFF |
| LOG_BIN_USE_V1_ROW_EVENTS | OFF |
| SQL_WARNINGS | OFF |
| MULTI_RANGE_COUNT | 256 |
| LOG_OUTPUT | FILE |
| INNODB_SYNC_ARRAY_SIZE | 1 |
| CHARACTER_SET_CLIENT | utf8mb4 |
| INNODB_API_TRX_LEVEL | 0 |
| EVENT_SCHEDULER | OFF |
| TLS_VERSION | TLSv1,TLSv1.1,TLSv1.2 |
| PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES | -1 |
| DELAY_KEY_WRITE | ON |
| TX_READ_ONLY | OFF |
| FT_MAX_WORD_LEN | 84 |
| INNODB_RANDOM_READ_AHEAD | OFF |
| READ_BUFFER_SIZE | 131072 |
| INNODB_UNDO_LOGS | 128 |
| METADATA_LOCKS_HASH_INSTANCES | 8 |
| AUTO_GENERATE_CERTS | ON |
| PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | -1 |
| SLAVE_PARALLEL_WORKERS | 0 |
| PORT | 3306 |
| LOG_BIN_TRUST_FUNCTION_CREATORS | OFF |
| SLAVE_MAX_ALLOWED_PACKET | 1073741824 |
| INNODB_MONITOR_DISABLE | |
| BINLOG_STMT_CACHE_SIZE | 32768 |
| HAVE_OPENSSL | YES |
| CHARACTER_SET_SYSTEM | utf8 |
| MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520 |
| SLAVE_PARALLEL_TYPE | DATABASE |
| PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | -1 |
| SERVER_ID_BITS | 32 |
| INNODB_SPIN_WAIT_DELAY | 6 |
| INNODB_FORCE_LOAD_CORRUPTED | OFF |
| INNODB_FILE_FORMAT_MAX | Barracuda |
| MAX_CONNECTIONS | 1000 |
| DEFAULT_STORAGE_ENGINE | InnoDB |
| MAX_SP_RECURSION_DEPTH | 0 |
| INNODB_LOCK_WAIT_TIMEOUT | 50 |
| VERSION_COMMENT | MySQL Community Server (GPL) |
| INNODB_OLD_BLOCKS_TIME | 1000 |
| SECURE_FILE_PRIV | NULL |
| CHECK_PROXY_USERS | OFF |
| QUERY_CACHE_WLOCK_INVALIDATE | OFF |
| SERVER_UUID | 089a60e4-7972-11eb-9439-000c2904afbb |
| BINLOG_CACHE_SIZE | 32768 |
| INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT | 5 |
| LOG_SLOW_SLAVE_STATEMENTS | OFF |
| LOCKED_IN_MEMORY | OFF |
| FLUSH_TIME | 0 |
| SLAVE_PRESERVE_COMMIT_ORDER | OFF |
| SSL_KEY | server-key.pem |
| SKIP_NETWORKING | OFF |
| LOG_BIN_BASENAME | /data/mysql/binlog |
| TRANSACTION_ISOLATION | REPEATABLE-READ |
| SLAVE_SKIP_ERRORS | OFF |
| INIT_CONNECT | |
| INNODB_BUFFER_POOL_DUMP_PCT | 25 |
| DIV_PRECISION_INCREMENT | 4 |
| RELAY_LOG_PURGE | ON |
| AUTOCOMMIT | ON |
| COLLATION_DATABASE | utf8mb4_bin |
| TABLE_DEFINITION_CACHE | 1400 |
| INNODB_MONITOR_ENABLE | |
| LOG_SYSLOG_TAG | |
| INNODB_LOG_BUFFER_SIZE | 16777216 |
| METADATA_LOCKS_CACHE_SIZE | 1024 |
| HOST_CACHE_SIZE | 653 |
| INNODB_MAX_PURGE_LAG | 0 |
| HOSTNAME | etlbi.com |
| MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232 |
| INNODB_REPLICATION_DELAY | 0 |
| INNODB_LRU_SCAN_DEPTH | 1024 |
| DELAYED_QUEUE_SIZE | 1000 |
| SQL_NOTES | ON |
| INNODB_BUFFER_POOL_LOAD_ABORT | OFF |
| INTERACTIVE_TIMEOUT | 28800 |
| BINLOG_ROW_IMAGE | FULL |
| CORE_FILE | OFF |
| INNODB_LOG_FILE_SIZE | 50331648 |
| LOG_THROTTLE_QUERIES_NOT_USING_INDEXES | 0 |
| TRANSACTION_READ_ONLY | OFF |
| HAVE_COMPRESS | YES |
| TABLE_OPEN_CACHE | 2000 |
| RANGE_OPTIMIZER_MAX_MEM_SIZE | 8388608 |
| PERFORMANCE_SCHEMA_HOSTS_SIZE | -1 |
| HAVE_STATEMENT_TIMEOUT | YES |
| THREAD_CACHE_SIZE | 18 |
| INNODB_DOUBLEWRITE | ON |
| FT_BOOLEAN_SYNTAX | + -><()~*:""&| |
| INNODB_STATS_PERSISTENT | ON |
| OPTIMIZER_TRACE | enabled=off,one_line=off |
| DEFAULT_WEEK_FORMAT | 0 |
| CHARACTER_SET_DATABASE | utf8mb4 |
| INNODB_CHANGE_BUFFER_MAX_SIZE | 25 |
| DATE_FORMAT | %Y-%m-%d |
| INNODB_DEFAULT_ROW_FORMAT | dynamic |
| RELAY_LOG_INFO_REPOSITORY | FILE |
| INNODB_USE_NATIVE_AIO | ON |
| GTID_PURGED | |
| SLAVE_COMPRESSED_PROTOCOL | OFF |
| INNODB_UNDO_TABLESPACES | 0 |
| TX_ISOLATION | REPEATABLE-READ |
| OPTIMIZER_TRACE_LIMIT | 1 |
| SLOW_QUERY_LOG | OFF |
| INNODB_FT_MIN_TOKEN_SIZE | 3 |
| SSL_CRLPATH | |
| INNODB_FT_USER_STOPWORD_TABLE | |
| INTERNAL_TMP_DISK_STORAGE_ENGINE | InnoDB |
| SERVER_ID | 1 |
| SQL_BUFFER_RESULT | OFF |
| IGNORE_BUILTIN_INNODB | OFF |
| INNODB_TEMP_DATA_FILE_PATH | ibtmp1:12M:autoextend |
| BINLOG_MAX_FLUSH_QUEUE_TIME | 0 |
| SYNC_RELAY_LOG_INFO | 10000 |
| LOG_BIN_INDEX | /data/mysql/binlog.index |
| SSL_CERT | server-cert.pem |
| RELAY_LOG_INFO_FILE | relay-log.info |
| INNODB_FT_ENABLE_STOPWORD | ON |
| LOG_SYSLOG_INCLUDE_PID | ON |
| INNODB_STATS_PERSISTENT_SAMPLE_PAGES | 20 |
| TIME_FORMAT | %H:%i:%s |
| PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | 512 |
| SQL_QUOTE_SHOW_CREATE | ON |
| AVOID_TEMPORAL_UPGRADE | OFF |
| GTID_OWNED | |
| INNODB_CHANGE_BUFFERING | all |
| LC_MESSAGES | en_US |
| PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | -1 |
| SECURE_AUTH | ON |
| BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE | 25000 |
| MAX_WRITE_LOCK_COUNT | 18446744073709551615 |
| SLAVE_TYPE_CONVERSIONS | |
| SQL_SELECT_LIMIT | 18446744073709551615 |
| PROFILING_HISTORY_SIZE | 15 |
| SYSTEM_TIME_ZONE | CST |
| MASTER_VERIFY_CHECKSUM | OFF |
| SQL_SLAVE_SKIP_COUNTER | 0 |
| LOG_BUILTIN_AS_IDENTIFIED_BY_PASSWORD | OFF |
| NET_READ_TIMEOUT | 30 |
| KEEP_FILES_ON_CREATE | OFF |
| INNODB_PURGE_THREADS | 4 |
| MAX_DELAYED_THREADS | 20 |
| GTID_MODE | OFF |
| LC_TIME_NAMES | en_US |
| PLUGIN_DIR | /usr/local/mysql57/lib/plugin/ |
| SSL_CAPATH | |
| KEY_CACHE_DIVISION_LIMIT | 100 |
| SLOW_QUERY_LOG_FILE | /data/mysql/etlbi-slow.log |
| INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN | ON |
| GENERAL_LOG_FILE | /data/mysql/etlbi.log |
| SLAVE_CHECKPOINT_GROUP | 512 |
| HAVE_RTREE_KEYS | YES |
| KEYRING_OPERATIONS | ON |
| SHA256_PASSWORD_PUBLIC_KEY_PATH | public_key.pem |
| PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS | -1 |
| HAVE_GEOMETRY | YES |
| INNODB_MAX_DIRTY_PAGES_PCT_LWM | 0.000000 |
| REPLICATION_SENDER_OBSERVE_COMMIT_ONLY | OFF |
| NEW | OFF |
| INNODB_BUFFER_POOL_CHUNK_SIZE | 134217728 |
| FOREIGN_KEY_CHECKS | ON |
| COLLATION_CONNECTION | utf8mb4_bin |
| INNODB_MONITOR_RESET | |
| LOG_STATEMENTS_UNSAFE_FOR_BINLOG | ON |
| INNODB_STATS_AUTO_RECALC | ON |
| DEFAULT_TMP_STORAGE_ENGINE | InnoDB |
| INNODB_COMMIT_CONCURRENCY | 0 |
| STORED_PROGRAM_CACHE | 256 |
| INNODB_CONCURRENCY_TICKETS | 5000 |
| INNODB_STATS_ON_METADATA | OFF |
| INNODB_PURGE_BATCH_SIZE | 300 |
| MAX_SORT_LENGTH | 1024 |
| INNODB_PAGE_CLEANERS | 1 |
| SLAVE_SQL_VERIFY_CHECKSUM | ON |
| INNODB_SUPPORT_XA | ON |
| REQUIRE_SECURE_TRANSPORT | OFF |
| SESSION_TRACK_TRANSACTION_INFO | OFF |
| PID_FILE | /data/mysql/etlbi.pid |
| INNODB_FILL_FACTOR | 100 |
| INNODB_API_DISABLE_ROWLOCK | OFF |
| MYISAM_USE_MMAP | OFF |
| INNODB_COMPRESSION_LEVEL | 6 |
| INNODB_FILE_PER_TABLE | ON |
| INNODB_FT_CACHE_SIZE | 8000000 |
| PARSER_MAX_MEM_SIZE | 18446744073709551615 |
| REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG | OFF |
| FT_MIN_WORD_LEN | 4 |
| DATADIR | /data/mysql/ |
| SOCKET | /tmp/mysql.sock |
| INNODB_DATA_HOME_DIR | |
| DISABLED_STORAGE_ENGINES | |
| INNODB_READ_IO_THREADS | 4 |
| TRANSACTION_WRITE_SET_EXTRACTION | OFF |
| INNODB_WRITE_IO_THREADS | 4 |
| SHA256_PASSWORD_AUTO_GENERATE_RSA_KEYS | ON |
| INNODB_BUFFER_POOL_INSTANCES | 1 |
| INNODB_CHECKSUMS | ON |
| INNODB_UNDO_DIRECTORY | ./ |
| LICENSE | GPL |
| INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF |
| INNODB_FORCE_RECOVERY | 0 |
| INNODB_FT_RESULT_CACHE_LIMIT | 2000000000 |
| EXPIRE_LOGS_DAYS | 0 |
| OPTIMIZER_TRACE_MAX_MEM_SIZE | 16384 |
| HAVE_QUERY_CACHE | YES |
| INNODB_SORT_BUFFER_SIZE | 1048576 |
| INNODB_BUFFER_POOL_LOAD_AT_STARTUP | ON |
| INNODB_FT_TOTAL_CACHE_SIZE | 640000000 |
| VERSION | 5.7.33-log |
| INNODB_API_ENABLE_MDL | OFF |
| SQL_SAFE_UPDATES | OFF |
| INNODB_FILE_FORMAT_CHECK | ON |
| INNODB_FLUSH_SYNC | ON |
| INNODB_READ_AHEAD_THRESHOLD | 56 |
| RELAY_LOG | |
| INNODB_READ_ONLY | OFF |
| INNODB_OPEN_FILES | 2000 |
| INNODB_LOG_FILES_IN_GROUP | 2 |
| INNODB_MONITOR_RESET_ALL | |
| SHA256_PASSWORD_PRIVATE_KEY_PATH | private_key.pem |
| INNODB_OPTIMIZE_FULLTEXT_ONLY | OFF |
| INNODB_DEADLOCK_DETECT | ON |
| MYISAM_STATS_METHOD | nulls_unequal |
| INNODB_FT_MAX_TOKEN_SIZE | 84 |
| SSL_CIPHER | |
| RELAY_LOG_INDEX | /data/mysql/etlbi-relay-bin.index |
| SSL_CA | ca.pem |
| LOG_TIMESTAMPS | UTC |
| INNODB_THREAD_CONCURRENCY | 0 |
| INNODB_FT_SORT_PLL_DEGREE | 2 |
| INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY | 128 |
| BASEDIR | /usr/local/mysql57/ |
| INNODB_BUFFER_POOL_SIZE | 134217728 |
| INNODB_LOG_CHECKSUMS | ON |
| SLAVE_ALLOW_BATCHING | OFF |
| INNODB_BUFFER_POOL_LOAD_NOW | OFF |
| LOCK_WAIT_TIMEOUT | 31536000 |
| IGNORE_DB_DIRS | |
| DEFAULT_AUTHENTICATION_PLUGIN | mysql_native_password |
| BINLOG_CHECKSUM | CRC32 |
| SESSION_TRACK_GTIDS | OFF |
| MYISAM_MMAP_SIZE | 18446744073709551615 |
| INNODB_FT_AUX_TABLE | |
| PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768 |
| INNODB_LOG_WRITE_AHEAD_SIZE | 8192 |
| PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE | 10000 |
| PROTOCOL_VERSION | 10 |
| DELAYED_INSERT_LIMIT | 100 |
| HAVE_PROFILING | YES |
| DATETIME_FORMAT | %Y-%m-%d %H:%i:%s |
| INNODB_CHECKSUM_ALGORITHM | crc32 |
| INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1 |
| INNODB_STATS_INCLUDE_DELETE_MARKED | OFF |
| MAX_RELAY_LOG_SIZE | 0 |
| MAX_PREPARED_STMT_COUNT | 16382 |
| HAVE_CRYPT | YES |
| RELAY_LOG_SPACE_LIMIT | 0 |
| MYISAM_REPAIR_THREADS | 1 |
| MAX_EXECUTION_TIME | 0 |
| PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE | 10000 |
| REPORT_USER | |
| SESSION_TRACK_STATE_CHANGE | OFF |
| INNODB_OLD_BLOCKS_PCT | 37 |
| MAX_ALLOWED_PACKET | 10240000 |
| TIME_ZONE | SYSTEM |
| DELAYED_INSERT_TIMEOUT | 300 |
| OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_inters|
| INNODB_VERSION | 5.7.33 |
| SESSION_TRACK_SYSTEM_VARIABLES | time_zone,autocommit,character_set_client,character_set_results,character_set_co|
| INNODB_CMP_PER_INDEX_ENABLED | OFF |
| COLLATION_SERVER | utf8mb4_bin |
| INNODB_ONLINE_ALTER_LOG_MAX_SIZE | 134217728 |
| INNODB_COMPRESSION_PAD_PCT_MAX | 50 |
| UPDATABLE_VIEWS_WITH_LIMIT | YES |
| INNODB_ADAPTIVE_FLUSHING | ON |
| INNODB_PAGE_SIZE | 16384 |
| INNODB_STATS_METHOD | nulls_equal |
| SORT_BUFFER_SIZE | 262144 |
+----------------------------------------------------------+---------------------------------------------------------------------------------+
506 rows in set, 1 warning (0.01 sec)
mysql>