Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
abort-slave-event-count 0
allow-suspicious-udfs FALSE
auto-increment-increment 1
auto-increment-offset 1
automatic-sp-privileges TRUE
back_log 50
basedir /data/gagarin/opt/builds/production/mysql_common-5.1.73-jet-1/
bind-address (No default value)
binlog-direct-non-transactional-updates FALSE
binlog-row-event-max-size 1024
binlog_cache_size 32768
binlog_format (No default value)
bulk_insert_buffer_size 8388608
character-set-client-handshake TRUE
character-set-filesystem binary
character-set-server utf8
character-sets-dir /data/gagarin/opt/builds/production/mysql_common-5.1.73-jet-1/share/mysql/charsets/
chroot (No default value)
collation-server utf8_general_ci
completion-type 0
concurrent-insert 1
connect_timeout 10
console FALSE
datadir .
datetime_format %Y-%m-%d %H:%i:%s
date_format %Y-%m-%d
default-character-set utf8
default-collation utf8_general_ci
default-storage-engine MyISAM
default-table-type MyISAM
default-time-zone (No default value)
default_week_format 0
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
des-key-file (No default value)
disconnect-slave-event-count 0
div_precision_increment 4
enable-locking FALSE
engine-condition-pushdown TRUE
expire_logs_days 0
external-locking FALSE
flush_time 0
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (No default value)
gdb FALSE
general_log FALSE
general_log_file /jet/log/mysqld/general.log
group_concat_max_len 1024
help TRUE
init-connect (No default value)
init-file (No default value)
init-slave (No default value)
interactive_timeout 28800
join_buffer_size 131072
keep_files_on_create FALSE
key_buffer_size 8384512
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /data/gagarin/opt/builds/production/mysql_common-5.1.73-jet-1/share/mysql/english/
large-pages FALSE
lc-time-names en_US
local-infile TRUE
log /jet/log/mysqld/general.log
log-bin (No default value)
log-bin-index (No default value)
log-bin-trust-function-creators FALSE
log-bin-trust-routine-creators FALSE
log-error
log-isam myisam.log
log-output FILE
log-queries-not-using-indexes FALSE
log-short-format FALSE
log-slave-updates FALSE
log-slow-admin-statements FALSE
log-slow-slave-statements FALSE
log-tc tc.log
log-tc-size 24576
log-update (No default value)
log-warnings 1
log_slow_queries /jet/log/mysqld/slow.log
long_query_time 10
low-priority-updates FALSE
lower_case_table_names 0
master-connect-retry 60
master-host (No default value)
master-info-file master.info
master-password (No default value)
master-port 3306
master-retry-count 86400
master-ssl FALSE
master-ssl-ca (No default value)
master-ssl-capath (No default value)
master-ssl-cert (No default value)
master-ssl-cipher (No default value)
master-ssl-key (No default value)
master-user test
max-binlog-dump-events 0
max_allowed_packet 1048576
max_binlog_cache_size 18446744073709547520
max_binlog_size 1073741824
max_connections 151
max_connect_errors 10
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_join_size 18446744073709551615
max_length_for_sort_data 1024
max_long_data_size 1048576
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
memlock FALSE
min_examined_row_limit 0
multi_range_count 256
myisam-recover OFF
myisam_block_size 1024
myisam_data_pointer_size 6
myisam_max_extra_sort_file_size 2147483647
myisam_max_sort_file_size 9223372036853727232
myisam_mmap_size 18446744073709551615
myisam_repair_threads 1
myisam_sort_buffer_size 8388608
myisam_stats_method nulls_unequal
myisam_use_mmap FALSE
ndb-use-copying-alter-table FALSE
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new FALSE
old FALSE
old-alter-table FALSE
old-passwords FALSE
old-style-user-limits FALSE
open_files_limit 1024
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
pid-file /jet/prs/mysqld/data/download.pid
plugin-load (No default value)
plugin_dir /jet/var/mysqld/plugin
port 3306
port-open-timeout 0
preload_buffer_size 32768
profiling_history_size 15
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type 1
query_cache_wlock_invalidate FALSE
query_prealloc_size 8192
range_alloc_block_size 4096
read_buffer_size 131072
read_only FALSE
read_rnd_buffer_size 262144
record_buffer 131072
relay-log (No default value)
relay-log-index (No default value)
relay-log-info-file relay-log.info
relay_log_purge TRUE
relay_log_space_limit 0
replicate-same-server-id FALSE
report-host (No default value)
report-password (No default value)
report-port 3306
report-user (No default value)
rpl-recovery-rank 0
safe-user-create FALSE
secure-auth FALSE
secure-file-priv (No default value)
server-id 0
show-slave-auth-info FALSE
skip-grant-tables FALSE
skip-slave-start FALSE
slave-exec-mode STRICT
slave-load-tmpdir /jet/tmp/mysqld
slave_compressed_protocol FALSE
slave_max_allowed_packet 1073741824
slave_net_timeout 3600
slave_transaction_retries 10
slow-query-log FALSE
slow_launch_time 2
slow_query_log_file /jet/log/mysqld/slow.log
socket /jet/run/mysqld/mysql.sock
sort_buffer_size 2097144
sporadic-binlog-dump-fail FALSE
sql-mode
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
symbolic-links FALSE
sync-binlog 0
sync-frm TRUE
sysdate-is-now FALSE
table_cache 64
table_definition_cache 256
table_lock_wait_timeout 50
table_open_cache 64
tc-heuristic-recover (No default value)
temp-pool TRUE
thread_cache_size 0
thread_concurrency 10
thread_stack 262144
timed_mutexes FALSE
time_format %H:%i:%s
tmpdir /jet/tmp/mysqld
tmp_table_size 16777216
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
updatable_views_with_limit 1
use-symbolic-links FALSE
verbose TRUE
wait_timeout 28800
warnings 1
Plugins have parameters that are not reflected in this list
because execution stopped before plugins were initialized.
To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.