[현재 설정된 값보기]

shell> mysqladmin .... variables

[기본값 보기]

shell> /path/to/mysqld --no-defaults --help | less
./mysqld  Ver 4.0.23-max for unknown-freebsd4.7 on i386 (Official MySQL-max binary)
....
....
....
Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
basedir                           /usr/local/mysql/
bdb-home                          (No default value)
bdb-logdir                        (No default value)
sync-bdb-logs                     TRUE
bdb-tmpdir                        (No default value)
sync-frm                          TRUE
bind-address                      (No default value)
console                           FALSE
chroot                            (No default value)
character-sets-dir                /usr/local/mysql/share/mysql/charsets/
datadir                           /usr/local/mysql/data/
default-character-set             latin1
enable-locking                    FALSE
enable-pstack                     FALSE
gdb                               FALSE
innodb_data_home_dir              (No default value)
innodb_log_group_home_dir         (No default value)
innodb_log_arch_dir               (No default value)
innodb_flush_log_at_trx_commit    1
innodb_flush_method               (No default value)
innodb_fast_shutdown              TRUE
innodb_status_file                FALSE
innodb_max_dirty_pages_pct        90
innodb_max_purge_lag              0
innodb_table_locks                TRUE
init-file                         (No default value)
log                               (No default value)
language                          /usr/local/mysql/share/mysql/english/
local-infile                      TRUE
log-bin                           (No default value)
log-bin-index                     (No default value)
log-isam                          myisam.log
log-update                        (No default value)
log-slow-queries                  (No default value)
log-slave-updates                 FALSE
low-priority-updates              FALSE
master-host                       (No default value)
master-user                       test
master-port                       3306
master-connect-retry              60
master-retry-count                86400
master-info-file                  master.info
master-ssl                        FALSE
master-ssl-key                    (No default value)
master-ssl-cert                   (No default value)
master-ssl-capath                 (No default value)
master-ssl-cipher                 (No default value)
myisam-recover                    OFF
memlock                           FALSE
disconnect-slave-event-count      0
abort-slave-event-count           0
max-binlog-dump-events            0
sporadic-binlog-dump-fail         FALSE
new                               FALSE
old-protocol                      10
pid-file                          /usr/local/mysql/data/channel.pid
log-error
port                              3306
replicate-same-server-id          FALSE
report-host                       (No default value)
report-user                       (No default value)
report-password                   (No default value)
report-port                       3306
rpl-recovery-rank                 0
relay-log                         (No default value)
relay-log-index                   (No default value)
safe-user-create                  FALSE
server-id                         0
show-slave-auth-info              FALSE
concurrent-insert                 TRUE
skip-grant-tables                 FALSE
skip-slave-start                  FALSE
relay-log-info-file               relay-log.info
slave-load-tmpdir                 /var/tmp/
socket                            /tmp/mysql.sock
sql-bin-update-same               FALSE
sql-mode                          OFF
temp-pool                         TRUE
tmpdir                            /var/tmp/
external-locking                  FALSE
use-symbolic-links                TRUE
symbolic-links                    TRUE
log-warnings                      1
warnings                          1
back_log                          50
bdb_cache_size                    8388600
bdb_log_buffer_size               0
bdb_max_lock                      10000
bdb_lock_max                      10000
binlog_cache_size                 32768
connect_timeout                   5
delayed_insert_timeout            300
delayed_insert_limit              100
delayed_queue_size                1000
flush_time                        0
ft_min_word_len                   4
ft_max_word_len                   254
ft_max_word_len_for_sort          20
ft_stopword_file                  (No default value)
innodb_mirrored_log_groups        1
innodb_log_files_in_group         2
innodb_log_file_size              5242880
innodb_log_buffer_size            1048576
innodb_buffer_pool_size           8388608
innodb_additional_mem_pool_size   1048576
innodb_file_io_threads            4
innodb_lock_wait_timeout          50
innodb_thread_concurrency         8
innodb_force_recovery             0
interactive_timeout               28800
join_buffer_size                  131072
key_buffer_size                   8388600
long_query_time                   10
lower_case_table_names            0
max_allowed_packet                1048576
max_binlog_cache_size             4294967295
max_binlog_size                   1073741824
max_connections                   100
max_connect_errors                10
max_delayed_threads               20
max_heap_table_size               16777216
max_join_size                     4294967295
max_relay_log_size                0
max_seeks_for_key                 4294967295
max_sort_length                   1024
max_tmp_tables                    32
max_user_connections              0
max_write_lock_count              4294967295
bulk_insert_buffer_size           8388608
myisam_block_size                 1024
myisam_max_extra_sort_file_size   268435456
myisam_max_sort_file_size         2147483647
myisam_repair_threads             1
myisam_sort_buffer_size           8388608
net_buffer_length                 16384
net_retry_count                   1000000
net_read_timeout                  30
net_write_timeout                 60
open_files_limit                  0
query_alloc_block_size            8192
query_cache_limit                 1048576
query_cache_size                  0
query_cache_type                  1
query_cache_wlock_invalidate      FALSE
query_prealloc_size               8192
read_buffer_size                  131072
read_rnd_buffer_size              262144
record_buffer                     131072
relay_log_space_limit             0
slave_compressed_protocol         FALSE
slave_net_timeout                 3600
range_alloc_block_size            2048
read-only                         FALSE
slow_launch_time                  2
sort_buffer_size                  2097144
table_cache                       64
thread_concurrency                10
thread_cache_size                 0
tmp_table_size                    33554432
thread_stack                      196608
transaction_alloc_block_size      8192
transaction_prealloc_size         4096
wait_timeout                      28800
default-week-format               0
----------------------------------------------