Variable_nameValue
auto_increment_increment1
auto_increment_offset1
automatic_sp_privilegesON
back_log50
basedir/usr/
bdb_cache_size8388600
bdb_home/var/lib/mysql/
bdb_log_buffer_size32768
bdb_logdir
bdb_max_lock10000
bdb_shared_dataOFF
bdb_tmpdir/tmp/
binlog_cache_size32768
bulk_insert_buffer_size8388608
character_set_clientcp1251
character_set_connectioncp1251
character_set_databasecp1251
character_set_filesystembinary
character_set_resultscp1251
character_set_servercp1251
character_set_systemutf8
character_sets_dir/usr/share/mysql/charsets/
collation_connectioncp1251_general_ci
collation_databasecp1251_general_ci
collation_servercp1251_general_ci
completion_type0
concurrent_insert1
connect_timeout5
datadir/var/lib/mysql/
date_format%Y-%m-%d
datetime_format%Y-%m-%d %H:%i:%s
default_week_format0
delay_key_writeON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
div_precision_increment4
engine_condition_pushdownOFF
expire_logs_days0
flushOFF
flush_time0
ft_boolean_syntax+ -><()~*:""&|
ft_max_word_len84
ft_min_word_len4
ft_query_expansion_limit20
ft_stopword_file(built-in)
group_concat_max_len1024
have_archiveNO
have_bdbYES
have_blackhole_engineNO
have_compressYES
have_cryptYES
have_csvNO
have_dynamic_loadingYES
have_example_engineNO
have_federated_engineNO
have_geometryYES
have_innodbYES
have_isamNO
have_merge_engineYES
have_ndbclusterNO
have_opensslDISABLED
have_sslDISABLED
have_query_cacheYES
have_raidNO
have_rtree_keysYES
have_symlinkYES
hostnamelocalhost
init_connect
init_file
init_slave
innodb_additional_mem_pool_size1048576
innodb_autoextend_increment8
innodb_buffer_pool_awe_mem_mb0
innodb_buffer_pool_size8388608
innodb_checksumsON
innodb_commit_concurrency0
innodb_concurrency_tickets500
innodb_data_file_pathibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewriteON
innodb_fast_shutdown1
innodb_file_io_threads4
innodb_file_per_tableOFF
innodb_flush_log_at_trx_commit1
innodb_flush_method
innodb_force_recovery0
innodb_lock_wait_timeout50
innodb_locks_unsafe_for_binlogOFF
innodb_log_arch_dir
innodb_log_archiveOFF
innodb_log_buffer_size1048576
innodb_log_file_size5242880
innodb_log_files_in_group2
innodb_log_group_home_dir./
innodb_max_dirty_pages_pct90
innodb_max_purge_lag0
innodb_mirrored_log_groups1
innodb_open_files300
innodb_rollback_on_timeoutOFF
innodb_support_xaON
innodb_sync_spin_loops20
innodb_table_locksON
innodb_thread_concurrency8
innodb_thread_sleep_delay10000
interactive_timeout28800
join_buffer_size131072
key_buffer_size8388600
key_cache_age_threshold300
key_cache_block_size1024
key_cache_division_limit100
language/usr/share/mysql/english/
large_files_supportON
large_page_size0
large_pagesOFF
lc_time_namesen_US
licenseGPL
local_infileON
locked_in_memoryOFF
logOFF
log_binOFF
log_bin_trust_function_creatorsOFF
log_error
log_queries_not_using_indexesOFF
log_slave_updatesOFF
log_slow_queriesOFF
log_warnings1
long_query_time10
low_priority_updatesOFF
lower_case_file_systemOFF
lower_case_table_names0
max_allowed_packet1048576
max_binlog_cache_size4294967295
max_binlog_size1073741824
max_connect_errors10
max_connections100
max_delayed_threads20
max_error_count64
max_heap_table_size16777216
max_insert_delayed_threads20
max_join_size4294967295
max_length_for_sort_data1024
max_prepared_stmt_count16382
max_relay_log_size0
max_seeks_for_key4294967295
max_sort_length1024
max_sp_recursion_depth0
max_tmp_tables32
max_user_connections0
max_write_lock_count4294967295
multi_range_count256
myisam_data_pointer_size6
myisam_max_sort_file_size2147483647
myisam_recover_optionsOFF
myisam_repair_threads1
myisam_sort_buffer_size8388608
myisam_stats_methodnulls_unequal
net_buffer_length16384
net_read_timeout30
net_retry_count10
net_write_timeout60
newOFF
old_passwordsOFF
open_files_limit1024
optimizer_prune_level1
optimizer_search_depth62
pid_file/var/run/mysqld/mysqld.pid
port3306
preload_buffer_size32768
profilingOFF
profiling_history_size15
protocol_version10
query_alloc_block_size8192
query_cache_limit1048576
query_cache_min_res_unit4096
query_cache_size0
query_cache_typeON
query_cache_wlock_invalidateOFF
query_prealloc_size8192
range_alloc_block_size2048
read_buffer_size131072
read_onlyOFF
read_rnd_buffer_size262144
relay_log_purgeON
relay_log_space_limit0
rpl_recovery_rank0
secure_authOFF
secure_file_priv
server_id0
skip_external_lockingON
skip_networkingOFF
skip_show_databaseOFF
slave_compressed_protocolOFF
slave_load_tmpdir/tmp/
slave_net_timeout3600
slave_skip_errorsOFF
slave_transaction_retries10
slow_launch_time2
socket/var/lib/mysql/mysql.sock
sort_buffer_size2097144
sql_big_selectsON
sql_mode
sql_notesON
sql_warningsOFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engineMyISAM
sync_binlog0
sync_frmON
system_time_zoneMSD
table_cache64
table_lock_wait_timeout50
table_typeMyISAM
thread_cache_size0
thread_stack196608
time_format%H:%i:%s
time_zoneSYSTEM
timed_mutexesOFF
tmp_table_size33554432
tmpdir/tmp/
transaction_alloc_block_size8192
transaction_prealloc_size4096
tx_isolationREPEATABLE-READ
updatable_views_with_limitYES
version5.0.45
version_bdbSleepycat Software: Berkeley DB 4.1.24: (July 4, 2007)
version_commentSource distribution
version_compile_machinei686
version_compile_osredhat-linux-gnu
wait_timeout28800