MySQL_Show_Global_Variables

Variable_name;Value
allow_client_hostname_forwarding;ON
allow_repl_client_for_replication_config;OFF
auto_generate_certs;ON
auto_increment_increment;1
auto_increment_offset;1
autocommit;ON
automatic_sp_privileges;ON
avoid_temporal_upgrade;OFF
back_log;850
basedir;/mysql/
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
block_encryption_mode;aes-128-ecb
block_slave_sql_access;0
block_user_access;33280
bulk_insert_buffer_size;8388608
character_set_client;utf8
character_set_connection;utf8
character_set_database;utf8
character_set_filesystem;binary
character_set_results;utf8
character_set_server;utf8
character_set_system;utf8
character_sets_dir;/usr/share/mysql/charsets/
check_proxy_users;OFF
collation_connection;utf8_general_ci
collation_database;utf8_general_ci
collation_server;utf8_general_ci
completion_type;NO_CHAIN
concurrent_insert;AUTO
connect_timeout;10
core_file;OFF
datadir;/mysql/datadir/
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;ON
enforce_storage_engine;InnoDB
eq_range_index_dive_limit;200
event_scheduler;OFF
expire_logs_days;0
explicit_defaults_for_timestamp;OFF
flush;OFF
flush_time;0
force_ssl_for_tcp;NONE
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;/mysql/logs/general.log
group_concat_max_len;1024
gtid_executed;14662cd0-37e0-11e8-ae85-42010a9c0ff2:1-22128431
gtid_executed_compression_period;1000
gtid_mode;ON
gtid_owned;
gtid_purged;14662cd0-37e0-11e8-ae85-42010a9c0ff2:1-21429252
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;YES
host_cache_size;803
hostname;localhost
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;1476395008
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_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;1
innodb_flush_method;O_DIRECT
innodb_flush_neighbors;2
innodb_flush_sync;ON
innodb_flushing_avg_loops;5
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;5000
innodb_io_capacity_max;10000
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;536870912
innodb_log_files_in_group;2
innodb_log_group_home_dir;./
innodb_log_write_ahead_size;8192
innodb_lru_scan_depth;2048
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;all
innodb_monitor_reset;
innodb_monitor_reset_all;
innodb_old_blocks_pct;37
innodb_old_blocks_time;1000
innodb_online_alter_log_max_size;134217728
innodb_open_files;2000
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_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.14
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
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;ON
log_bin_basename;/mysql/binlog/mysql-bin
log_bin_index;/mysql/binlog/mysql-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_n_first_received_events;4
log_n_first_sent_events;4
log_output;FILE
log_queries_not_using_indexes;OFF
log_slave_updates;ON
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;TABLE
master_verify_checksum;OFF
max_allowed_packet;33554432
max_binlog_cache_size;18446744073709547520
max_binlog_size;104857600
max_binlog_stmt_cache_size;18446744073709547520
max_connect_errors;100
max_connections;4000
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_repair_threads;1
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;1048576
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
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_users_size;0
pid_file;/mysql/mysql.pid
plugin_dir;/usr/lib/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;/mysql/relaylog/relay-log
relay_log_basename;/mysql/relaylog/relay-log
relay_log_index;/mysql/relaylog/relay-log.index
relay_log_info_file;relay-log.info
relay_log_info_repository;TABLE
relay_log_purge;ON
relay_log_recovery;ON
relay_log_space_limit;0
report_host;
report_password;
report_port;3306
report_user;
require_secure_transport;OFF
require_super_for_system_schema_ddl;information_schema,mysql,performance_schema,sys
require_super_for_system_table_writes;event,func,plugin,proc,heartbeat
reserved_super_connections;20
rpl_semi_sync_master_async_notify_sleep_interval;1000000
rpl_semi_sync_master_async_notify_socket;/semisync/semisync.sock
rpl_semi_sync_master_async_notify_timeout;5000000
rpl_semi_sync_master_do_async_notify;ON
rpl_semi_sync_master_enabled;ON
rpl_semi_sync_master_slave_lag_heartbeat_frequency_us;500000
rpl_semi_sync_master_timeout;3000
rpl_semi_sync_master_trace_level;32
rpl_semi_sync_master_wait_for_slave_count;1
rpl_semi_sync_master_wait_no_slave;ON
rpl_semi_sync_master_wait_point;AFTER_SYNC
rpl_semi_sync_slave_enabled;OFF
rpl_semi_sync_slave_lag_enabled;OFF
rpl_semi_sync_slave_trace_level;32
rpl_stop_slave_timeout;31536000
secure_auth;ON
secure_file_priv;/mysql/tmp/
server_id;2986854427
server_id_bits;32
server_uuid;14662cd0-37e0-11e8-ae85-42010a9c0ff2
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_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;/mysql/tmp
slave_max_allowed_packet;1073741824
slave_net_timeout;30
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;ON
slow_query_log_file;/mysql/logs/slow.log
socket;/mysql/mysql.sock
sort_buffer_size;262144
sql_auto_is_null;OFF
sql_big_selects;ON
sql_buffer_result;OFF
sql_log_off;OFF
sql_mode;ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,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;/mysql/datadir/client_ca_cert.pem
ssl_capath;
ssl_cert;/mysql/datadir/server_cert.pem
ssl_cipher;ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
ssl_crl;
ssl_crlpath;
ssl_key;/mysql/datadir/server_pkey.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
system_user_table;ON
table_definition_cache;1400
table_open_cache;2000
table_open_cache_instances;16
thread_cache_size;48
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;/mysql/tmp
transaction_alloc_block_size;8192
transaction_prealloc_size;4096
transaction_write_set_extraction;OFF
tx_isolation;REPEATABLE-READ
tx_read_only;OFF
unique_checks;ON
updatable_views_with_limit;YES
version;5.7.14-google-log
version_comment;(Google)
version_compile_machine;x86_64
version_compile_os;Linux
wait_timeout;28800