Home

MySQL Variables
Variables    Processes   State   Variables   

 

NameValue
auto_increment_increment1
auto_increment_offset1
autocommitON
automatic_sp_privilegesON
avoid_temporal_upgradeOFF
back_log150
basedir/usr/
big_tablesOFF
bind_address*
binlog_cache_size32768
binlog_checksumCRC32
binlog_direct_non_transactional_updatesOFF
binlog_error_actionIGNORE_ERROR
binlog_formatMIXED
binlog_gtid_simple_recoveryOFF
binlog_max_flush_queue_time0
binlog_order_commitsON
binlog_row_imageFULL
binlog_rows_query_log_eventsOFF
binlog_stmt_cache_size32768
binlogging_impossible_modeIGNORE_ERROR
block_encryption_modeaes-128-ecb
bulk_insert_buffer_size8388608
character_set_clientutf8
character_set_connectionutf8
character_set_databaselatin1
character_set_filesystembinary
character_set_resultsutf8
character_set_serverlatin1
character_set_systemutf8
character_sets_dir/usr/share/mysql/charsets/
collation_connectionutf8_general_ci
collation_databaselatin1_swedish_ci
collation_serverlatin1_swedish_ci
completion_typeNO_CHAIN
concurrent_insertAUTO
connect_timeout10
core_fileOFF
datadir/var/lib/mysql/
date_format%Y-%m-%d
datetime_format%Y-%m-%d %H:%i:%s
default_storage_engineMyISAM
default_tmp_storage_engineInnoDB
default_week_format0
delay_key_writeON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
disconnect_on_expired_passwordON
div_precision_increment4
end_markers_in_jsonOFF
enforce_gtid_consistencyOFF
eq_range_index_dive_limit10
error_count0
event_schedulerON
expire_logs_days1
explicit_defaults_for_timestampOFF
external_user
flushOFF
flush_time0
foreign_key_checksON
ft_boolean_syntax+ -><()~*:""&|
ft_max_word_len84
ft_min_word_len4
ft_query_expansion_limit20
ft_stopword_file(built-in)
general_logOFF
general_log_file/var/lib/mysql/dd1304.log
group_concat_max_len1024
gtid_executed
gtid_modeOFF
gtid_nextAUTOMATIC
gtid_owned
gtid_purged
have_compressYES
have_cryptYES
have_dynamic_loadingYES
have_geometryYES
have_opensslDISABLED
have_profilingYES
have_query_cacheYES
have_rtree_keysYES
have_sslDISABLED
have_symlinkYES
host_cache_size628
hostnamedd1304
identity0
ignore_builtin_innodbOFF
ignore_db_dirs
init_connect
init_file
init_slave
innodb_adaptive_flushingON
innodb_adaptive_flushing_lwm10
innodb_adaptive_hash_indexON
innodb_adaptive_max_sleep_delay150000
innodb_additional_mem_pool_size8388608
innodb_api_bk_commit_interval5
innodb_api_disable_rowlockOFF
innodb_api_enable_binlogOFF
innodb_api_enable_mdlOFF
innodb_api_trx_level0
innodb_autoextend_increment64
innodb_autoinc_lock_mode1
innodb_buffer_pool_dump_at_shutdownOFF
innodb_buffer_pool_dump_nowOFF
innodb_buffer_pool_filenameib_buffer_pool
innodb_buffer_pool_instances8
innodb_buffer_pool_load_abortOFF
innodb_buffer_pool_load_at_startupOFF
innodb_buffer_pool_load_nowOFF
innodb_buffer_pool_size268435456
innodb_change_buffer_max_size25
innodb_change_bufferingall
innodb_checksum_algorithminnodb
innodb_checksumsON
innodb_cmp_per_index_enabledOFF
innodb_commit_concurrency0
innodb_compression_failure_threshold_pct5
innodb_compression_level6
innodb_compression_pad_pct_max50
innodb_concurrency_tickets5000
innodb_data_file_pathibdata1:12M:autoextend
innodb_data_home_dir
innodb_disable_sort_file_cacheOFF
innodb_doublewriteON
innodb_fast_shutdown1
innodb_file_formatAntelope
innodb_file_format_checkON
innodb_file_format_maxAntelope
innodb_file_per_tableON
innodb_flush_log_at_timeout1
innodb_flush_log_at_trx_commit2
innodb_flush_method
innodb_flush_neighbors1
innodb_flushing_avg_loops30
innodb_force_load_corruptedOFF
innodb_force_recovery0
innodb_ft_aux_table
innodb_ft_cache_size8000000
innodb_ft_enable_diag_printOFF
innodb_ft_enable_stopwordON
innodb_ft_max_token_size84
innodb_ft_min_token_size3
innodb_ft_num_word_optimize2000
innodb_ft_result_cache_limit2000000000
innodb_ft_server_stopword_table
innodb_ft_sort_pll_degree2
innodb_ft_total_cache_size640000000
innodb_ft_user_stopword_table
innodb_io_capacity200
innodb_io_capacity_max2000
innodb_large_prefixOFF
innodb_lock_wait_timeout50
innodb_locks_unsafe_for_binlogOFF
innodb_log_buffer_size8388608
innodb_log_compressed_pagesON
innodb_log_file_size50331648
innodb_log_files_in_group2
innodb_log_group_home_dir./
innodb_lru_scan_depth1024
innodb_max_dirty_pages_pct75
innodb_max_dirty_pages_pct_lwm0
innodb_max_purge_lag0
innodb_max_purge_lag_delay0
innodb_mirrored_log_groups1
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct37
innodb_old_blocks_time1000
innodb_online_alter_log_max_size134217728
innodb_open_files1024
innodb_optimize_fulltext_onlyOFF
innodb_page_size16384
innodb_print_all_deadlocksOFF
innodb_purge_batch_size300
innodb_purge_threads1
innodb_random_read_aheadOFF
innodb_read_ahead_threshold56
innodb_read_io_threads4
innodb_read_onlyOFF
innodb_replication_delay0
innodb_rollback_on_timeoutOFF
innodb_rollback_segments128
innodb_sort_buffer_size1048576
innodb_spin_wait_delay6
innodb_stats_auto_recalcON
innodb_stats_methodnulls_equal
innodb_stats_on_metadataOFF
innodb_stats_persistentON
innodb_stats_persistent_sample_pages20
innodb_stats_sample_pages8
innodb_stats_transient_sample_pages8
innodb_status_outputOFF
innodb_status_output_locksOFF
innodb_strict_modeOFF
innodb_support_xaON
innodb_sync_array_size1
innodb_sync_spin_loops30
innodb_table_locksON
innodb_thread_concurrency0
innodb_thread_sleep_delay10000
innodb_tmpdir
innodb_undo_directory.
innodb_undo_logs128
innodb_undo_tablespaces0
innodb_use_native_aioON
innodb_use_sys_mallocON
innodb_version5.6.33
innodb_write_io_threads4
insert_id0
interactive_timeout28800
join_buffer_size2097152
keep_files_on_createOFF
key_buffer_size134217728
key_cache_age_threshold300
key_cache_block_size1024
key_cache_division_limit100
large_files_supportON
large_page_size0
large_pagesOFF
last_insert_id0
lc_messagesen_US
lc_messages_dir/usr/share/mysql/
lc_time_namesen_US
licenseGPL
local_infileOFF
lock_wait_timeout31536000
locked_in_memoryOFF
log_binON
log_bin_basename/var/lib/mysql/mysql-bin
log_bin_index/var/lib/mysql/mysql-bin.index
log_bin_trust_function_creatorsON
log_bin_use_v1_row_eventsOFF
log_error
log_outputFILE
log_queries_not_using_indexesOFF
log_slave_updatesOFF
log_slow_admin_statementsOFF
log_slow_slave_statementsOFF
log_throttle_queries_not_using_indexes0
log_warnings1
long_query_time5.000000
low_priority_updatesOFF
lower_case_file_systemOFF
lower_case_table_names0
master_info_repositoryFILE
master_verify_checksumOFF
max_allowed_packet16777216
max_binlog_cache_size4294967296
max_binlog_size1073741824
max_binlog_stmt_cache_size4294967296
max_connect_errors100
max_connections500
max_delayed_threads20
max_digest_length1024
max_error_count64
max_heap_table_size16777216
max_insert_delayed_threads20
max_join_size18446744073709551615
max_length_for_sort_data1024
max_prepared_stmt_count16382
max_relay_log_size0
max_seeks_for_key18446744073709551615
max_sort_length1024
max_sp_recursion_depth0
max_tmp_tables32
max_user_connections25
max_write_lock_count18446744073709551615
metadata_locks_cache_size1024
metadata_locks_hash_instances8
min_examined_row_limit0
multi_range_count256
myisam_data_pointer_size6
myisam_max_sort_file_size9223372036853727232
myisam_mmap_size18446744073709551615
myisam_recover_optionsOFF
myisam_repair_threads1
myisam_sort_buffer_size33554432
myisam_stats_methodnulls_unequal
myisam_use_mmapOFF
net_buffer_length16384
net_read_timeout30
net_retry_count10
net_write_timeout60
newOFF
oldOFF
old_alter_tableOFF
old_passwords0
open_files_limit60000
optimizer_prune_level1
optimizer_search_depth62
optimizer_switchindex_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,subquery_materialization_cost_based=on,use_index_extensions=on
optimizer_traceenabled=off,one_line=off
optimizer_trace_featuresgreedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit1
optimizer_trace_max_mem_size16384
optimizer_trace_offset-1
performance_schemaON
performance_schema_accounts_size100
performance_schema_digests_size10000
performance_schema_events_stages_history_long_size10000
performance_schema_events_stages_history_size10
performance_schema_events_statements_history_long_size10000
performance_schema_events_statements_history_size10
performance_schema_events_waits_history_long_size10000
performance_schema_events_waits_history_size10
performance_schema_hosts_size100
performance_schema_max_cond_classes80
performance_schema_max_cond_instances6196
performance_schema_max_digest_length1024
performance_schema_max_file_classes50
performance_schema_max_file_handles32768
performance_schema_max_file_instances92308
performance_schema_max_mutex_classes200
performance_schema_max_mutex_instances24480
performance_schema_max_rwlock_classes40
performance_schema_max_rwlock_instances13688
performance_schema_max_socket_classes10
performance_schema_max_socket_instances1020
performance_schema_max_stage_classes150
performance_schema_max_statement_classes168
performance_schema_max_table_handles2048
performance_schema_max_table_instances12500
performance_schema_max_thread_classes50
performance_schema_max_thread_instances1100
performance_schema_session_connect_attrs_size512
performance_schema_setup_actors_size100
performance_schema_setup_objects_size100
performance_schema_users_size100
pid_file/var/run/mysqld/mysqld.pid
plugin_dir/usr/lib/mysql/plugin/
port3306
preload_buffer_size32768
profilingOFF
profiling_history_size15
protocol_version10
proxy_user
pseudo_slave_modeOFF
pseudo_thread_id1366754
query_alloc_block_size8192
query_cache_limit1048576
query_cache_min_res_unit4096
query_cache_size33554432
query_cache_typeON
query_cache_wlock_invalidateOFF
query_prealloc_size8192
rand_seed10
rand_seed20
range_alloc_block_size4096
read_buffer_size131072
read_onlyOFF
read_rnd_buffer_size262144
relay_log
relay_log_basename
relay_log_index
relay_log_info_filerelay-log.info
relay_log_info_repositoryFILE
relay_log_purgeON
relay_log_recoveryOFF
relay_log_space_limit0
report_host
report_password
report_port3306
report_user
rpl_stop_slave_timeout31536000
secure_authON
secure_file_priv
server_id1
server_id_bits32
server_uuid38e65fb7-3e0d-11e4-9cd2-001d60a3ffbe
show_old_temporalsOFF
simplified_binlog_gtid_recoveryOFF
skip_external_lockingON
skip_name_resolveON
skip_networkingOFF
skip_show_databaseOFF
slave_allow_batchingOFF
slave_checkpoint_group512
slave_checkpoint_period300
slave_compressed_protocolOFF
slave_exec_modeSTRICT
slave_load_tmpdir/var/tmp/mysql
slave_max_allowed_packet1073741824
slave_net_timeout3600
slave_parallel_workers0
slave_pending_jobs_size_max16777216
slave_rows_search_algorithmsTABLE_SCAN,INDEX_SCAN
slave_skip_errorsOFF
slave_sql_verify_checksumON
slave_transaction_retries10
slave_type_conversions
slow_launch_time2
slow_query_logON
slow_query_log_file/var/log/mysql/slowqueries.log
socket/var/run/mysqld/mysqld.sock
sort_buffer_size15728640
sql_auto_is_nullOFF
sql_big_selectsON
sql_buffer_resultOFF
sql_log_binON
sql_log_offOFF
sql_modeNO_ENGINE_SUBSTITUTION
sql_notesON
sql_quote_show_createON
sql_safe_updatesOFF
sql_select_limit18446744073709551615
sql_slave_skip_counter0
sql_warningsOFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_crl
ssl_crlpath
ssl_key
storage_engineMyISAM
stored_program_cache256
sync_binlog0
sync_frmON
sync_master_info10000
sync_relay_log10000
sync_relay_log_info10000
system_time_zoneCEST
table_definition_cache2048
table_open_cache1024
table_open_cache_instances1
thread_cache_size8
thread_concurrency10
thread_handlingone-thread-per-connection
thread_stack262144
time_format%H:%i:%s
time_zoneSYSTEM
timed_mutexesOFF
timestamp1508351974.142149
tmp_table_size16777216
tmpdir/var/tmp/mysql
transaction_alloc_block_size8192
transaction_allow_batchingOFF
transaction_prealloc_size4096
tx_isolationREPEATABLE-READ
tx_read_onlyOFF
unique_checksON
updatable_views_with_limitYES
version5.6.33-nmm1-log
version_comment(Ubuntu)
version_compile_machinex86_64
version_compile_osdebian-linux-gnu
wait_timeout120
warning_count0