Variables

auto_increment_increment1
auto_increment_offset1
autocommitON
automatic_sp_privilegesON
back_log1000
basedir/usr
big_tablesOFF
binlog_cache_size32768
binlog_direct_non_transactional_updatesOFF
binlog_formatMIXED
binlog_stmt_cache_size32768
bulk_insert_buffer_size8388608
character_set_clientutf8mb4
character_set_connectionutf8mb4
character_set_databaselatin1
character_set_filesystembinary
character_set_resultsutf8mb4
character_set_serverlatin1
character_set_systemutf8
character_sets_dir/usr/share/percona-server/charsets/
collation_connectionutf8mb4_general_ci
collation_databaselatin1_swedish_ci
collation_serverlatin1_swedish_ci
completion_typeNO_CHAIN
concurrent_insertAUTO
connect_timeout10
csv_mode 
datadir/data/ssd/mysql/
date_format%Y-%m-%d
datetime_format%Y-%m-%d %H:%i:%s
default_storage_engineInnoDB
default_week_format0
delay_key_writeON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
div_precision_increment4
enforce_storage_engine 
engine_condition_pushdownON
error_count0
event_schedulerOFF
expand_fast_index_creationOFF
expire_logs_days4
external_user 
extra_max_connections1
extra_port0
fast_index_creationON
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/data/ssd/mysql/sfp-db-1.log
group_concat_max_len1024
have_compressYES
have_cryptYES
have_csvYES
have_dynamic_loadingYES
have_flashcacheYES
have_geometryYES
have_innodbYES
have_ndbclusterNO
have_opensslDISABLED
have_partitioningYES
have_profilingYES
have_query_cacheYES
have_response_time_distributionYES
have_rtree_keysYES
have_sslDISABLED
have_symlinkYES
have_tlsv1_2YES
hostnamesfp-db-1.v30.ch3.sourceforge.com
identity0
ignore_builtin_innodbOFF
init_connect 
init_file 
init_slave 
innodb_adaptive_flushingON
innodb_adaptive_flushing_methodestimate
innodb_adaptive_hash_indexON
innodb_adaptive_hash_index_partitions1
innodb_additional_mem_pool_size8388608
innodb_autoextend_increment8
innodb_autoinc_lock_mode1
innodb_blocking_buffer_pool_restoreOFF
innodb_buffer_pool_instances1
innodb_buffer_pool_populateOFF
innodb_buffer_pool_restore_at_startup0
innodb_buffer_pool_shm_checksumON
innodb_buffer_pool_shm_key0
innodb_buffer_pool_size8589934592
innodb_change_bufferingall
innodb_checkpoint_age_target0
innodb_checksumsON
innodb_commit_concurrency0
innodb_concurrency_tickets500
innodb_corrupt_table_actionassert
innodb_data_file_pathibdata1:10M:autoextend
innodb_data_home_dir 
innodb_dict_size_limit0
innodb_doublewriteON
innodb_doublewrite_file 
innodb_fake_changesOFF
innodb_fast_checksumOFF
innodb_fast_shutdown1
innodb_file_formatAntelope
innodb_file_format_checkON
innodb_file_format_maxAntelope
innodb_file_per_tableON
innodb_flush_log_at_trx_commit1
innodb_flush_methodO_DIRECT
innodb_flush_neighbor_pagesarea
innodb_force_load_corruptedOFF
innodb_force_recovery0
innodb_ibuf_accel_rate100
innodb_ibuf_active_contract1
innodb_ibuf_max_size4294950912
innodb_import_table_from_xtrabackup0
innodb_io_capacity200
innodb_kill_idle_transaction0
innodb_large_prefixOFF
innodb_lazy_drop_table0
innodb_lock_wait_timeout50
innodb_locking_fake_changesON
innodb_locks_unsafe_for_binlogOFF
innodb_log_block_size512
innodb_log_buffer_size20971520
innodb_log_file_size10485760
innodb_log_files_in_group2
innodb_log_group_home_dir./
innodb_max_bitmap_file_size104857600
innodb_max_changed_pages1000000
innodb_max_dirty_pages_pct75
innodb_max_purge_lag0
innodb_merge_sort_block_size1048576
innodb_mirrored_log_groups1
innodb_old_blocks_pct37
innodb_old_blocks_time0
innodb_open_files300
innodb_page_size16384
innodb_print_all_deadlocksOFF
innodb_purge_batch_size20
innodb_purge_threads1
innodb_random_read_aheadOFF
innodb_read_aheadlinear
innodb_read_ahead_threshold56
innodb_read_io_threads4
innodb_recovery_statsOFF
innodb_recovery_update_relay_logOFF
innodb_replication_delay0
innodb_rollback_on_timeoutOFF
innodb_rollback_segments128
innodb_show_locks_held10
innodb_show_verbose_locks0
innodb_spin_wait_delay6
innodb_stats_auto_update0
innodb_stats_methodnulls_equal
innodb_stats_on_metadataOFF
innodb_stats_sample_pages8
innodb_stats_update_need_lock1
innodb_strict_modeOFF
innodb_support_xaON
innodb_sync_spin_loops30
innodb_table_locksON
innodb_thread_concurrency0
innodb_thread_concurrency_timer_basedOFF
innodb_thread_sleep_delay10000
innodb_track_changed_pagesOFF
innodb_use_atomic_writesOFF
innodb_use_global_flush_log_at_trx_commitON
innodb_use_native_aioON
innodb_use_sys_mallocON
innodb_use_sys_stats_tableOFF
innodb_version5.5.52-38.3
innodb_write_io_threads4
insert_id0
interactive_timeout28800
join_buffer_size131072
keep_files_on_createOFF
key_buffer_size64424509440
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/percona-server/
lc_time_namesen_US
licenseGPL
local_infileON
lock_wait_timeout31536000
locked_in_memoryOFF
logOFF
log_binON
log_bin_trust_function_creatorsOFF
log_error/var/log/mysqld.log
log_outputFILE
log_queries_not_using_indexesOFF
log_slave_updatesOFF
log_slow_admin_statementsOFF
log_slow_filter 
log_slow_queriesOFF
log_slow_rate_limit1
log_slow_rate_typesession
log_slow_slave_statementsOFF
log_slow_sp_statementsON
log_slow_verbosity 
log_warnings1
log_warnings_suppress 
long_query_time10.000000
low_priority_updatesOFF
lower_case_file_systemOFF
lower_case_table_names0
max_allowed_packet8388608
max_binlog_cache_size18446744073709547520
max_binlog_files0
max_binlog_size1073741824
max_binlog_stmt_cache_size18446744073709547520
max_connect_errors1000
max_connections1500
max_delayed_threads20
max_error_count64
max_heap_table_size536870912
max_insert_delayed_threads20
max_join_size18446744073709551615
max_length_for_sort_data1024
max_long_data_size8388608
max_prepared_stmt_count16382
max_relay_log_size0
max_seeks_for_key18446744073709551615
max_slowlog_files0
max_slowlog_size0
max_sort_length1024
max_sp_recursion_depth0
max_tmp_tables32
max_user_connections10
max_write_lock_count18446744073709551615
metadata_locks_cache_size1024
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_size8388608
myisam_stats_methodnulls_unequal
myisam_use_mmapOFF
net_buffer_length16384
net_read_timeout60
net_retry_count100
net_write_timeout120
newOFF
oldOFF
old_alter_tableOFF
old_passwordsOFF
open_files_limit9511
optimizer_fixON
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
performance_schemaOFF
performance_schema_events_waits_history_long_size10000
performance_schema_events_waits_history_size10
performance_schema_max_cond_classes80
performance_schema_max_cond_instances1000
performance_schema_max_file_classes50
performance_schema_max_file_handles32768
performance_schema_max_file_instances10000
performance_schema_max_mutex_classes200
performance_schema_max_mutex_instances1000000
performance_schema_max_rwlock_classes30
performance_schema_max_rwlock_instances1000000
performance_schema_max_table_handles100000
performance_schema_max_table_instances50000
performance_schema_max_thread_classes50
performance_schema_max_thread_instances1000
pid_file/data/ssd/mysql/sfp-db-1.v30.ch3.sourceforge.com.pid
plugin_dir/usr/lib64/mysql/plugin/
port3306
preload_buffer_size32768
profilingOFF
profiling_history_size15
protocol_version10
proxy_user 
pseudo_slave_modeOFF
pseudo_thread_id441739895
query_alloc_block_size8192
query_cache_limit1048576
query_cache_min_res_unit4096
query_cache_size33554432
query_cache_strip_commentsOFF
query_cache_typeON
query_cache_wlock_invalidateOFF
query_prealloc_size8192
query_response_time_range_base10
query_response_time_statsOFF
rand_seed10
rand_seed20
range_alloc_block_size4096
read_buffer_size131072
read_onlyOFF
read_rnd_buffer_size262144
relay_log/data/ssd/mysql/mysqld-relay-bin
relay_log_index/data/ssd/mysql/mysqld-relay-bin.index
relay_log_info_file/data/ssd/mysql/relay-log.info
relay_log_purgeON
relay_log_recoveryOFF
relay_log_space_limit0
report_host 
report_password 
report_port3306
report_user 
rpl_recovery_rank0
secure_authOFF
secure_file_priv 
server_id1
skip_external_lockingON
skip_name_resolveON
skip_networkingOFF
skip_show_databaseOFF
slave_compressed_protocolOFF
slave_exec_modeSTRICT
slave_load_tmpdir/data/ssd/tmp
slave_max_allowed_packet1073741824
slave_net_timeout3600
slave_skip_errorsOFF
slave_transaction_retries10
slave_type_conversions 
slow_launch_time2
slow_query_logOFF
slow_query_log_always_write_time10.000000
slow_query_log_file/var/log/slow-mysql-queries.log
slow_query_log_timestamp_alwaysOFF
slow_query_log_timestamp_precisionsecond
slow_query_log_use_global_control 
socket/data/ssd/mysql/mysql.sock
sort_buffer_size2097152
sql_auto_is_nullOFF
sql_big_selectsON
sql_big_tablesOFF
sql_buffer_resultOFF
sql_log_binON
sql_log_offOFF
sql_low_priority_updatesOFF
sql_max_join_size18446744073709551615
sql_mode 
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_key 
storage_engineInnoDB
stored_program_cache256
sync_binlog0
sync_frmON
sync_master_info0
sync_relay_log0
sync_relay_log_info0
system_time_zoneUTC
table_definition_cache400
table_open_cache4000
thread_cache_size128
thread_concurrency64
thread_handlingone-thread-per-connection
thread_pool_high_prio_modetransactions
thread_pool_high_prio_tickets4294967295
thread_pool_idle_timeout60
thread_pool_max_threads100000
thread_pool_oversubscribe3
thread_pool_size32
thread_pool_stall_limit500
thread_stack262144
thread_statisticsOFF
time_format%H:%i:%s
time_zoneSYSTEM
timed_mutexesOFF
timestamp1488112129
tls_versionTLSv1.1,TLSv1.2
tmp_table_size16777216
tmpdir/data/ssd/tmp
transaction_alloc_block_size8192
transaction_prealloc_size4096
tx_isolationREPEATABLE-READ
unique_checksON
updatable_views_with_limitYES
userstatOFF
version5.5.52-38.3-log
version_commentPercona Server (GPL), Release 38.3, Revision 109ad68
version_compile_machinex86_64
version_compile_osLinux
wait_timeout301
warning_count0
Language: