MySQL: SHOW GLOBAL VARS

auto_generate_certs, ON
auto_increment_increment, 1
auto_increment_offset, 1
autocommit, ON
automatic_sp_privileges, ON
avoid_temporal_upgrade, OFF
back_log, 80
basedir, /usr/
big_tables, OFF
bind_address, *
binlog_cache_size, 32768
binlog_checksum, CRC32
binlog_direct_non_transactional_updates, OFF
binlog_error_action, ABORT_SERVER
binlog_format, ROW
binlog_group_commit_sync_delay, 0
binlog_group_commit_sync_no_delay_count, 0
binlog_gtid_simple_recovery, ON
binlog_max_flush_queue_time, 0
binlog_order_commits, ON
binlog_row_image, FULL
binlog_rows_query_log_events, OFF
binlog_stmt_cache_size, 32768
binlog_transaction_dependency_history_size, 25000
binlog_transaction_dependency_tracking, COMMIT_ORDER
block_encryption_mode, aes-128-ecb
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, /usr/share/mysql/charsets/
check_proxy_users, OFF
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
core_file, OFF
datadir, /var/lib/mysql/
date_format, %Y-%m-%d
datetime_format, %Y-%m-%d %H:%i:%s
default_authentication_plugin, mysql_native_password
default_password_lifetime, 0
default_storage_engine, InnoDB
default_tmp_storage_engine, InnoDB
default_week_format, 0
delay_key_write, ON
delayed_insert_limit, 100
delayed_insert_timeout, 300
delayed_queue_size, 1000
disabled_storage_engines,
disconnect_on_expired_password, ON
div_precision_increment, 4
end_markers_in_json, OFF
enforce_gtid_consistency, OFF
eq_range_index_dive_limit, 200
event_scheduler, OFF
expire_logs_days, 0
explicit_defaults_for_timestamp, OFF
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, /var/lib/mysql/cbe7ade26676.log
group_concat_max_len, 1024
gtid_executed,
gtid_executed_compression_period, 1000
gtid_mode, OFF
gtid_owned,
gtid_purged,
have_compress, YES
have_crypt, YES
have_dynamic_loading, YES
have_geometry, YES
have_openssl, YES
have_profiling, YES
have_query_cache, YES
have_rtree_keys, YES
have_ssl, YES
have_statement_timeout, YES
have_symlink, DISABLED
host_cache_size, 128
hostname, cbe7ade26676
ignore_builtin_innodb, OFF
ignore_db_dirs,
init_connect,
init_file,
init_slave,
innodb_adaptive_flushing, ON
innodb_adaptive_flushing_lwm, 10
innodb_adaptive_hash_index, ON
innodb_adaptive_hash_index_parts, 8
innodb_adaptive_max_sleep_delay, 150000
innodb_api_bk_commit_interval, 5
innodb_api_disable_rowlock, OFF
innodb_api_enable_binlog, OFF
innodb_api_enable_mdl, OFF
innodb_api_trx_level, 0
innodb_autoextend_increment, 64
innodb_autoinc_lock_mode, 1
innodb_buffer_pool_chunk_size, 134217728
innodb_buffer_pool_dump_at_shutdown, ON
innodb_buffer_pool_dump_now, OFF
innodb_buffer_pool_dump_pct, 25
innodb_buffer_pool_filename, ib_buffer_pool
innodb_buffer_pool_instances, 1
innodb_buffer_pool_load_abort, OFF
innodb_buffer_pool_load_at_startup, ON
innodb_buffer_pool_load_now, OFF
innodb_buffer_pool_size, 134217728
innodb_change_buffer_max_size, 25
innodb_change_buffering, all
innodb_checksum_algorithm, crc32
innodb_checksums, ON
innodb_cmp_per_index_enabled, OFF
innodb_commit_concurrency, 0
innodb_compression_failure_threshold_pct, 5
innodb_compression_level, 6
innodb_compression_pad_pct_max, 50
innodb_concurrency_tickets, 5000
innodb_data_file_path, ibdata1:12M:autoextend
innodb_data_home_dir,
innodb_deadlock_detect, ON
innodb_default_row_format, dynamic
innodb_disable_sort_file_cache, OFF
innodb_doublewrite, ON
innodb_fast_shutdown, 1
innodb_file_format, Barracuda
innodb_file_format_check, ON
innodb_file_format_max, Barracuda
innodb_file_per_table, ON
innodb_fill_factor, 100
innodb_flush_log_at_timeout, 1
innodb_flush_log_at_trx_commit, 2
innodb_flush_method,
innodb_flush_neighbors, 1
innodb_flush_sync, ON
innodb_flushing_avg_loops, 30
innodb_force_load_corrupted, OFF
innodb_force_recovery, 0
innodb_ft_aux_table,
innodb_ft_cache_size, 8000000
innodb_ft_enable_diag_print, OFF
innodb_ft_enable_stopword, ON
innodb_ft_max_token_size, 84
innodb_ft_min_token_size, 3
innodb_ft_num_word_optimize, 2000
innodb_ft_result_cache_limit, 2000000000
innodb_ft_server_stopword_table,
innodb_ft_sort_pll_degree, 2
innodb_ft_total_cache_size, 640000000
innodb_ft_user_stopword_table,
innodb_io_capacity, 200
innodb_io_capacity_max, 2000
innodb_large_prefix, ON
innodb_lock_wait_timeout, 50
innodb_locks_unsafe_for_binlog, OFF
innodb_log_buffer_size, 16777216
innodb_log_checksums, ON
innodb_log_compressed_pages, ON
innodb_log_file_size, 50331648
innodb_log_files_in_group, 2
innodb_log_group_home_dir, ./
innodb_log_write_ahead_size, 8192
innodb_lru_scan_depth, 1024
innodb_max_dirty_pages_pct, 75.000000
innodb_max_dirty_pages_pct_lwm, 0.000000
innodb_max_purge_lag, 0
innodb_max_purge_lag_delay, 0
innodb_max_undo_log_size, 1073741824
innodb_monitor_disable,
innodb_monitor_enable,
innodb_monitor_reset,
innodb_monitor_reset_all,
innodb_numa_interleave, OFF
innodb_old_blocks_pct, 37
innodb_old_blocks_time, 1000
innodb_online_alter_log_max_size, 134217728
innodb_open_files, 300
innodb_optimize_fulltext_only, OFF
innodb_page_cleaners, 1
innodb_page_size, 16384
innodb_print_all_deadlocks, OFF
innodb_purge_batch_size, 300
innodb_purge_rseg_truncate_frequency, 128
innodb_purge_threads, 4
innodb_random_read_ahead, OFF
innodb_read_ahead_threshold, 56
innodb_read_io_threads, 4
innodb_read_only, OFF
innodb_replication_delay, 0
innodb_rollback_on_timeout, OFF
innodb_rollback_segments, 128
innodb_sort_buffer_size, 1048576
innodb_spin_wait_delay, 6
innodb_stats_auto_recalc, ON
innodb_stats_include_delete_marked, OFF
innodb_stats_method, nulls_equal
innodb_stats_on_metadata, OFF
innodb_stats_persistent, ON
innodb_stats_persistent_sample_pages, 20
innodb_stats_sample_pages, 8
innodb_stats_transient_sample_pages, 8
innodb_status_output, OFF
innodb_status_output_locks, OFF
innodb_strict_mode, ON
innodb_support_xa, ON
innodb_sync_array_size, 1
innodb_sync_spin_loops, 30
innodb_table_locks, ON
innodb_temp_data_file_path, ibtmp1:12M:autoextend
innodb_thread_concurrency, 0
innodb_thread_sleep_delay, 10000
innodb_tmpdir,
innodb_undo_directory, ./
innodb_undo_log_truncate, OFF
innodb_undo_logs, 128
innodb_undo_tablespaces, 0
innodb_use_native_aio, ON
innodb_version, 5.7.40
innodb_write_io_threads, 4
interactive_timeout, 28800
internal_tmp_disk_storage_engine, InnoDB
join_buffer_size, 262144
keep_files_on_create, OFF
key_buffer_size, 8388608
key_cache_age_threshold, 300
key_cache_block_size, 1024
key_cache_division_limit, 100
keyring_operations, ON
large_files_support, ON
large_page_size, 0
large_pages, OFF
lc_messages, en_US
lc_messages_dir, /usr/share/mysql/
lc_time_names, en_US
license, GPL
local_infile, ON
lock_wait_timeout, 31536000
locked_in_memory, OFF
log_bin, OFF
log_bin_basename,
log_bin_index,
log_bin_trust_function_creators, OFF
log_bin_use_v1_row_events, OFF
log_builtin_as_identified_by_password, OFF
log_error, stderr
log_error_verbosity, 3
log_output, FILE
log_queries_not_using_indexes, OFF
log_slave_updates, OFF
log_slow_admin_statements, OFF
log_slow_slave_statements, OFF
log_statements_unsafe_for_binlog, ON
log_syslog, OFF
log_syslog_facility, daemon
log_syslog_include_pid, ON
log_syslog_tag,
log_throttle_queries_not_using_indexes, 0
log_timestamps, UTC
log_warnings, 2
long_query_time, 10.000000
low_priority_updates, OFF
lower_case_file_system, OFF
lower_case_table_names, 0
master_info_repository, FILE
master_verify_checksum, OFF
max_allowed_packet, 4194304
max_binlog_cache_size, 18446744073709547520
max_binlog_size, 1073741824
max_binlog_stmt_cache_size, 18446744073709547520
max_connect_errors, 100
max_connections, 151
max_delayed_threads, 20
max_digest_length, 1024
max_error_count, 64
max_execution_time, 0
max_heap_table_size, 16777216
max_insert_delayed_threads, 20
max_join_size, 18446744073709551615
max_length_for_sort_data, 1024
max_points_in_geometry, 65536
max_prepared_stmt_count, 16382
max_relay_log_size, 0
max_seeks_for_key, 18446744073709551615
max_sort_length, 1024
max_sp_recursion_depth, 0
max_tmp_tables, 32
max_user_connections, 0
max_write_lock_count, 18446744073709551615
metadata_locks_cache_size, 1024
metadata_locks_hash_instances, 8
min_examined_row_limit, 0
multi_range_count, 256
myisam_data_pointer_size, 6
myisam_max_sort_file_size, 9223372036853727232
myisam_mmap_size, 18446744073709551615
myisam_recover_options, OFF
myisam_sort_buffer_size, 8388608
myisam_stats_method, nulls_unequal
myisam_use_mmap, OFF
mysql_native_password_proxy_users, OFF
net_buffer_length, 16384
net_read_timeout, 30
net_retry_count, 10
net_write_timeout, 60
new, OFF
ngram_token_size, 2
offline_mode, OFF
old, OFF
old_alter_table, OFF
old_passwords, 0
open_files_limit, 1073741816
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,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,prefer_ordering_index=on
optimizer_trace, enabled=off,one_line=off
optimizer_trace_features, greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit, 1
optimizer_trace_max_mem_size, 16384
optimizer_trace_offset, -1
parser_max_mem_size, 18446744073709551615
performance_schema, OFF
performance_schema_accounts_size, 0
performance_schema_digests_size, 0
performance_schema_events_stages_history_long_size, 0
performance_schema_events_stages_history_size, 0
performance_schema_events_statements_history_long_size, 0
performance_schema_events_statements_history_size, 0
performance_schema_events_transactions_history_long_size, 0
performance_schema_events_transactions_history_size, 0
performance_schema_events_waits_history_long_size, 0
performance_schema_events_waits_history_size, 0
performance_schema_hosts_size, 0
performance_schema_max_cond_classes, 0
performance_schema_max_cond_instances, 0
performance_schema_max_digest_length, 0
performance_schema_max_file_classes, 0
performance_schema_max_file_handles, 0
performance_schema_max_file_instances, 0
performance_schema_max_index_stat, 0
performance_schema_max_memory_classes, 0
performance_schema_max_metadata_locks, 0
performance_schema_max_mutex_classes, 0
performance_schema_max_mutex_instances, 0
performance_schema_max_prepared_statements_instances, 0
performance_schema_max_program_instances, 0
performance_schema_max_rwlock_classes, 0
performance_schema_max_rwlock_instances, 0
performance_schema_max_socket_classes, 0
performance_schema_max_socket_instances, 0
performance_schema_max_sql_text_length, 0
performance_schema_max_stage_classes, 0
performance_schema_max_statement_classes, 0
performance_schema_max_statement_stack, 0
performance_schema_max_table_handles, 0
performance_schema_max_table_instances, 0
performance_schema_max_table_lock_stat, 0
performance_schema_max_thread_classes, 0
performance_schema_max_thread_instances, 0
performance_schema_session_connect_attrs_size, 0
performance_schema_setup_actors_size, 0
performance_schema_setup_objects_size, 0
performance_schema_show_processlist, OFF
performance_schema_users_size, 0
pid_file, /var/run/mysqld/mysqld.pid
plugin_dir, /usr/lib64/mysql/plugin/
port, 3306
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, 1048576
query_cache_type, OFF
query_cache_wlock_invalidate, OFF
query_prealloc_size, 8192
range_alloc_block_size, 4096
range_optimizer_max_mem_size, 8388608
rbr_exec_mode, STRICT
read_buffer_size, 131072
read_only, OFF
read_rnd_buffer_size, 262144
relay_log,
relay_log_basename, /var/lib/mysql/cbe7ade26676-relay-bin
relay_log_index, /var/lib/mysql/cbe7ade26676-relay-bin.index
relay_log_info_file, relay-log.info
relay_log_info_repository, FILE
relay_log_purge, ON
relay_log_recovery, OFF
relay_log_space_limit, 0
replication_optimize_for_static_plugin_config, OFF
replication_sender_observe_commit_only, OFF
report_host,
report_password,
report_port, 3306
report_user,
require_secure_transport, OFF
rpl_stop_slave_timeout, 31536000
secure_auth, ON
secure_file_priv, /var/lib/mysql-files/
server_id, 0
server_id_bits, 32
server_uuid, 487ef562-39f0-11e9-8b29-0242ac130004
session_track_gtids, OFF
session_track_schema, ON
session_track_state_change, OFF
session_track_system_variables, time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session_track_transaction_info, OFF
sha256_password_auto_generate_rsa_keys, ON
sha256_password_private_key_path, private_key.pem
sha256_password_proxy_users, OFF
sha256_password_public_key_path, public_key.pem
show_compatibility_56, OFF
show_create_table_verbosity, OFF
show_old_temporals, OFF
skip_external_locking, ON
skip_name_resolve, ON
skip_networking, OFF
skip_show_database, OFF
slave_allow_batching, OFF
slave_checkpoint_group, 512
slave_checkpoint_period, 300
slave_compressed_protocol, OFF
slave_exec_mode, STRICT
slave_load_tmpdir, /tmp
slave_max_allowed_packet, 1073741824
slave_net_timeout, 60
slave_parallel_type, DATABASE
slave_parallel_workers, 0
slave_pending_jobs_size_max, 16777216
slave_preserve_commit_order, OFF
slave_rows_search_algorithms, TABLE_SCAN,INDEX_SCAN
slave_skip_errors, OFF
slave_sql_verify_checksum, ON
slave_transaction_retries, 10
slave_type_conversions,
slow_launch_time, 2
slow_query_log, OFF
slow_query_log_file, /var/lib/mysql/cbe7ade26676-slow.log
socket, /var/run/mysqld/mysqld.sock
sort_buffer_size, 262144
sql_auto_is_null, OFF
sql_big_selects, ON
sql_buffer_result, OFF
sql_log_off, OFF
sql_mode, STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sql_notes, ON
sql_quote_show_create, ON
sql_safe_updates, OFF
sql_select_limit, 18446744073709551615
sql_slave_skip_counter, 0
sql_warnings, OFF
ssl_ca, ca.pem
ssl_capath,
ssl_cert, server-cert.pem
ssl_cipher,
ssl_crl,
ssl_crlpath,
ssl_key, server-key.pem
stored_program_cache, 256
super_read_only, OFF
sync_binlog, 1
sync_frm, ON
sync_master_info, 10000
sync_relay_log, 10000
sync_relay_log_info, 10000
system_time_zone, UTC
table_definition_cache, 400
table_open_cache, 10
table_open_cache_instances, 16
thread_cache_size, 8
thread_handling, one-thread-per-connection
thread_stack, 262144
time_format, %H:%i:%s
time_zone, SYSTEM
tls_version, TLSv1,TLSv1.1,TLSv1.2
tmp_table_size, 16777216
tmpdir, /tmp
transaction_alloc_block_size, 8192
transaction_isolation, REPEATABLE-READ
transaction_prealloc_size, 4096
transaction_read_only, OFF
transaction_write_set_extraction, OFF
tx_isolation, REPEATABLE-READ
tx_read_only, OFF
unique_checks, ON
updatable_views_with_limit, YES
version, 5.7.40
version_comment, MySQL Community Server (GPL)
version_compile_machine, x86_64
version_compile_os, Linux
wait_timeout, 28800