[현재 설정된 값보기]
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
---------------------------------------------- |
sun's longitude:43 05 56
/board/delete.php:소스보기
