auto_increment_increment |
1 |
auto_increment_offset |
1 |
autocommit |
ON |
automatic_sp_privileges |
ON |
back_log |
50 |
basedir |
/usr/local/mysql/ |
big_tables |
OFF |
binlog_cache_size |
32768 |
binlog_format |
MIXED |
bulk_insert_buffer_size |
8388608 |
character_set_client |
utf8 |
character_set_connection |
utf8 |
character_set_database |
utf8 |
character_set_filesystem |
binary |
character_set_results |
utf8 |
character_set_server |
euckr |
character_set_system |
utf8 |
character_sets_dir |
/usr/local/mysql/share/mysql/charsets/ |
collation_connection |
utf8_general_ci |
collation_database |
utf8_general_ci |
collation_server |
euckr_korean_ci |
completion_type |
0 |
concurrent_insert |
1 |
connect_timeout |
10 |
datadir |
/usr/local/mysql/data/ |
date_format |
%Y-%m-%d |
datetime_format |
%Y-%m-%d %H:%i:%s |
default_week_format |
0 |
delay_key_write |
ON |
delayed_insert_limit |
100 |
delayed_insert_timeout |
300 |
delayed_queue_size |
1000 |
div_precision_increment |
4 |
engine_condition_pushdown |
ON |
error_count |
0 |
event_scheduler |
OFF |
expire_logs_days |
0 |
flush |
OFF |
flush_time |
0 |
foreign_key_checks |
ON |
ft_boolean_syntax |
+ -><()~*:""&| |
ft_max_word_len |
84 |
ft_min_word_len |
4 |
ft_query_expansion_limit |
20 |
ft_stopword_file |
(built-in) |
general_log |
OFF |
general_log_file |
/usr/local/mysql/data/dev01.log |
group_concat_max_len |
1024 |
have_community_features |
YES |
have_compress |
YES |
have_crypt |
YES |
have_csv |
YES |
have_dynamic_loading |
YES |
have_geometry |
YES |
have_innodb |
YES |
have_ndbcluster |
NO |
have_openssl |
NO |
have_partitioning |
NO |
have_query_cache |
YES |
have_rtree_keys |
YES |
have_ssl |
NO |
have_symlink |
YES |
hostname |
dev01 |
identity |
0 |
init_connect |
|
init_file |
|
init_slave |
|
innodb_adaptive_hash_index |
ON |
innodb_additional_mem_pool_size |
1048576 |
innodb_autoextend_increment |
8 |
innodb_autoinc_lock_mode |
1 |
innodb_buffer_pool_size |
8388608 |
innodb_checksums |
ON |
innodb_commit_concurrency |
0 |
innodb_concurrency_tickets |
500 |
innodb_data_file_path |
ibdata1:10M:autoextend |
innodb_data_home_dir |
|
innodb_doublewrite |
ON |
innodb_fast_shutdown |
1 |
innodb_file_io_threads |
4 |
innodb_file_per_table |
OFF |
innodb_flush_log_at_trx_commit |
1 |
innodb_flush_method |
|
innodb_force_recovery |
0 |
innodb_lock_wait_timeout |
50 |
innodb_locks_unsafe_for_binlog |
OFF |
innodb_log_buffer_size |
1048576 |
innodb_log_file_size |
5242880 |
innodb_log_files_in_group |
2 |
innodb_log_group_home_dir |
./ |
innodb_max_dirty_pages_pct |
90 |
innodb_max_purge_lag |
0 |
innodb_mirrored_log_groups |
1 |
innodb_open_files |
300 |
innodb_rollback_on_timeout |
OFF |
innodb_support_xa |
ON |
innodb_sync_spin_loops |
20 |
innodb_table_locks |
ON |
innodb_thread_concurrency |
8 |
innodb_thread_sleep_delay |
10000 |
insert_id |
0 |
interactive_timeout |
28800 |
join_buffer_size |
131072 |
keep_files_on_create |
OFF |
key_buffer_size |
402653184 |
key_cache_age_threshold |
300 |
key_cache_block_size |
1024 |
key_cache_division_limit |
100 |
language |
/usr/local/mysql/share/mysql/english/ |
large_files_support |
ON |
large_page_size |
0 |
large_pages |
OFF |
last_insert_id |
0 |
lc_time_names |
en_US |
license |
GPL |
local_infile |
ON |
locked_in_memory |
OFF |
log |
OFF |
log_bin |
ON |
log_bin_trust_function_creators |
OFF |
log_bin_trust_routine_creators |
OFF |
log_error |
/usr/local/mysql/data/dev01.err |
log_output |
FILE |
log_queries_not_using_indexes |
OFF |
log_slave_updates |
OFF |
log_slow_queries |
OFF |
log_warnings |
1 |
long_query_time |
10.000000 |
low_priority_updates |
OFF |
lower_case_file_system |
OFF |
lower_case_table_names |
0 |
max_allowed_packet |
1048576 |
max_binlog_cache_size |
4294967295 |
max_binlog_size |
1073741824 |
max_connect_errors |
10 |
max_connections |
151 |
max_delayed_threads |
20 |
max_error_count |
64 |
max_heap_table_size |
16777216 |
max_insert_delayed_threads |
20 |
max_join_size |
4294967295 |
max_length_for_sort_data |
1024 |
max_prepared_stmt_count |
16382 |
max_relay_log_size |
0 |
max_seeks_for_key |
4294967295 |
max_sort_length |
1024 |
max_sp_recursion_depth |
0 |
max_tmp_tables |
32 |
max_user_connections |
0 |
max_write_lock_count |
4294967295 |
min_examined_row_limit |
0 |
multi_range_count |
256 |
myisam_data_pointer_size |
6 |
myisam_max_sort_file_size |
2147483647 |
myisam_recover_options |
OFF |
myisam_repair_threads |
1 |
myisam_sort_buffer_size |
67108864 |
myisam_stats_method |
nulls_unequal |
myisam_use_mmap |
OFF |
net_buffer_length |
16384 |
net_read_timeout |
30 |
net_retry_count |
10 |
net_write_timeout |
60 |
new |
OFF |
old |
OFF |
old_alter_table |
OFF |
old_passwords |
OFF |
open_files_limit |
1185 |
optimizer_prune_level |
1 |
optimizer_search_depth |
62 |
pid_file |
/usr/local/mysql/data/dev01.pid |
plugin_dir |
/usr/local/mysql/lib/mysql/plugin |
port |
3306 |
preload_buffer_size |
32768 |
profiling |
OFF |
profiling_history_size |
15 |
protocol_version |
10 |
pseudo_thread_id |
192822 |
query_alloc_block_size |
8192 |
query_cache_limit |
1048576 |
query_cache_min_res_unit |
4096 |
query_cache_size |
33554432 |
query_cache_type |
ON |
query_cache_wlock_invalidate |
OFF |
query_prealloc_size |
8192 |
rand_seed1 |
|
rand_seed2 |
|
range_alloc_block_size |
4096 |
read_buffer_size |
2097152 |
read_only |
OFF |
read_rnd_buffer_size |
8388608 |
relay_log |
|
relay_log_index |
|
relay_log_info_file |
relay-log.info |
relay_log_purge |
ON |
relay_log_space_limit |
0 |
report_host |
|
report_password |
|
report_port |
3306 |
report_user |
|
rpl_recovery_rank |
0 |
secure_auth |
OFF |
secure_file_priv |
|
server_id |
1 |
skip_external_locking |
ON |
skip_networking |
OFF |
skip_show_database |
OFF |
slave_compressed_protocol |
OFF |
slave_exec_mode |
STRICT |
slave_load_tmpdir |
/tmp |
slave_net_timeout |
3600 |
slave_skip_errors |
OFF |
slave_transaction_retries |
10 |
slow_launch_time |
2 |
slow_query_log |
OFF |
slow_query_log_file |
/usr/local/mysql/data/dev01-slow.log |
socket |
/tmp/mysql.sock |
sort_buffer_size |
2097152 |
sql_auto_is_null |
ON |
sql_big_selects |
ON |
sql_big_tables |
OFF |
sql_buffer_result |
OFF |
sql_log_bin |
ON |
sql_log_off |
OFF |
sql_log_update |
ON |
sql_low_priority_updates |
OFF |
sql_max_join_size |
4294967295 |
sql_mode |
|
sql_notes |
ON |
sql_quote_show_create |
ON |
sql_safe_updates |
OFF |
sql_select_limit |
4294967295 |
sql_slave_skip_counter |
|
sql_warnings |
OFF |
ssl_ca |
|
ssl_capath |
|
ssl_cert |
|
ssl_cipher |
|
ssl_key |
|
storage_engine |
MyISAM |
sync_binlog |
0 |
sync_frm |
ON |
system_time_zone |
KST |
table_definition_cache |
256 |
table_lock_wait_timeout |
50 |
table_open_cache |
512 |
table_type |
MyISAM |
thread_cache_size |
8 |
thread_handling |
one-thread-per-connection |
thread_stack |
196608 |
time_format |
%H:%i:%s |
time_zone |
SYSTEM |
timed_mutexes |
OFF |
timestamp |
1255313910 |
tmp_table_size |
16777216 |
tmpdir |
/tmp |
transaction_alloc_block_size |
8192 |
transaction_prealloc_size |
4096 |
tx_isolation |
READ-COMMITTED |
unique_checks |
ON |
updatable_views_with_limit |
YES |
version |
5.1.30-log |
version_comment |
Source distribution |
version_compile_machine |
i686 |
version_compile_os |
pc-linux-gnu |
wait_timeout |
28800 |
warning_count |
0 |
