Created
October 18, 2012 10:55
-
-
Save debility-zz/3910990 to your computer and use it in GitHub Desktop.
mysql 5.5 config at RDS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql -ufusic -h testdb.xxxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -p -e "show variables;" > mysql.params | |
Variable_name : Value | |
----- | |
auto_increment_increment : 1 | |
auto_increment_offset : 1 | |
autocommit : ON | |
automatic_sp_privileges : ON | |
back_log : 50 | |
basedir : /rdsdbbin/mysql/ | |
big_tables : OFF | |
binlog_cache_size : 32768 | |
binlog_direct_non_transactional_updates : OFF | |
binlog_format : MIXED | |
binlog_stmt_cache_size : 32768 | |
bulk_insert_buffer_size : 8388608 | |
character_set_client : utf8 | |
character_set_connection : utf8 | |
character_set_database : latin1 | |
character_set_filesystem : binary | |
character_set_results : utf8 | |
character_set_server : latin1 | |
character_set_system : utf8 | |
character_sets_dir : /rdsdbbin/mysql-5.5.27.R1/share/charsets/ | |
collation_connection : utf8_general_ci | |
collation_database : latin1_swedish_ci | |
collation_server : utf8mb4_general_ci | |
completion_type : NO_CHAIN | |
concurrent_insert : AUTO | |
connect_timeout : 10 | |
datadir : /rdsdbdata/db/ | |
date_format : %Y-%m-%d | |
datetime_format : %Y-%m-%d %H:%i:%s | |
default_storage_engine : InnoDB | |
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 | |
external_user : | |
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 : /rdsdbdata/db/ip-10-146-2-107.log | |
group_concat_max_len : 1024 | |
have_compress : YES | |
have_crypt : YES | |
have_csv : YES | |
have_dynamic_loading : YES | |
have_geometry : YES | |
have_innodb : YES | |
have_ndbcluster : NO | |
have_openssl : YES | |
have_partitioning : YES | |
have_profiling : YES | |
have_query_cache : YES | |
have_rtree_keys : YES | |
have_ssl : YES | |
have_symlink : YES | |
hostname : ip-10-146-2-107 | |
identity : 0 | |
ignore_builtin_innodb : OFF | |
init_connect : | |
init_file : | |
init_slave : | |
innodb_adaptive_flushing : ON | |
innodb_adaptive_hash_index : ON | |
innodb_additional_mem_pool_size : 2097152 | |
innodb_autoextend_increment : 8 | |
innodb_autoinc_lock_mode : 1 | |
innodb_buffer_pool_instances : 1 | |
innodb_buffer_pool_size : 326107136 | |
innodb_change_buffering : all | |
innodb_checksums : ON | |
innodb_commit_concurrency : 0 | |
innodb_concurrency_tickets : 500 | |
innodb_data_file_path : ibdata1:10M:autoextend | |
innodb_data_home_dir : /rdsdbdata/db/innodb | |
innodb_doublewrite : ON | |
innodb_fast_shutdown : 1 | |
innodb_file_format : Antelope | |
innodb_file_format_check : ON | |
innodb_file_format_max : Antelope | |
innodb_file_per_table : ON | |
innodb_flush_log_at_trx_commit : 1 | |
innodb_flush_method : O_DIRECT | |
innodb_force_load_corrupted : OFF | |
innodb_force_recovery : 0 | |
innodb_io_capacity : 200 | |
innodb_large_prefix : OFF | |
innodb_lock_wait_timeout : 50 | |
innodb_locks_unsafe_for_binlog : OFF | |
innodb_log_buffer_size : 8388608 | |
innodb_log_file_size : 134217728 | |
innodb_log_files_in_group : 2 | |
innodb_log_group_home_dir : /rdsdbdata/log/innodb | |
innodb_max_dirty_pages_pct : 75 | |
innodb_max_purge_lag : 0 | |
innodb_mirrored_log_groups : 1 | |
innodb_old_blocks_pct : 37 | |
innodb_old_blocks_time : 0 | |
innodb_open_files : 300 | |
innodb_purge_batch_size : 20 | |
innodb_purge_threads : 0 | |
innodb_random_read_ahead : OFF | |
innodb_read_ahead_threshold : 56 | |
innodb_read_io_threads : 4 | |
innodb_replication_delay : 0 | |
innodb_rollback_on_timeout : OFF | |
innodb_rollback_segments : 128 | |
innodb_spin_wait_delay : 6 | |
innodb_stats_method : nulls_equal | |
innodb_stats_on_metadata : ON | |
innodb_stats_sample_pages : 8 | |
innodb_strict_mode : OFF | |
innodb_support_xa : ON | |
innodb_sync_spin_loops : 30 | |
innodb_table_locks : ON | |
innodb_thread_concurrency : 0 | |
innodb_thread_sleep_delay : 10000 | |
innodb_use_native_aio : ON | |
innodb_use_sys_malloc : ON | |
innodb_version : 1.1.8 | |
innodb_write_io_threads : 4 | |
insert_id : 0 | |
interactive_timeout : 28800 | |
join_buffer_size : 131072 | |
keep_files_on_create : OFF | |
key_buffer_size : 16777216 | |
key_cache_age_threshold : 300 | |
key_cache_block_size : 1024 | |
key_cache_division_limit : 100 | |
large_files_support : ON | |
large_page_size : 0 | |
large_pages : OFF | |
last_insert_id : 0 | |
lc_messages : en_US | |
lc_messages_dir : /rdsdbbin/mysql-5.5.27.R1/share/ | |
lc_time_names : en_US | |
license : GPL | |
local_infile : ON | |
lock_wait_timeout : 31536000 | |
locked_in_memory : OFF | |
log : OFF | |
log_bin : ON | |
log_bin_trust_function_creators : OFF | |
log_error : /rdsdbdata/log/error/mysql-error.log | |
log_output : TABLE | |
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 : 18446744073709547520 | |
max_binlog_size : 134217728 | |
max_binlog_stmt_cache_size : 18446744073709547520 | |
max_connect_errors : 10 | |
max_connections : 34 | |
max_delayed_threads : 20 | |
max_error_count : 64 | |
max_heap_table_size : 16777216 | |
max_insert_delayed_threads : 20 | |
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 | |
metadata_locks_cache_size : 1024 | |
min_examined_row_limit : 0 | |
multi_range_count : 256 | |
myisam_data_pointer_size : 6 | |
myisam_max_sort_file_size : 9223372036853727232 | |
myisam_mmap_size : 18446744073709551615 | |
myisam_recover_options : OFF | |
myisam_repair_threads : 1 | |
myisam_sort_buffer_size : 8388608 | |
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 : 65535 | |
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,engine_condition_pushdown=on | |
performance_schema : OFF | |
performance_schema_events_waits_history_long_size : 10000 | |
performance_schema_events_waits_history_size : 10 | |
performance_schema_max_cond_classes : 80 | |
performance_schema_max_cond_instances : 1000 | |
performance_schema_max_file_classes : 50 | |
performance_schema_max_file_handles : 32768 | |
performance_schema_max_file_instances : 10000 | |
performance_schema_max_mutex_classes : 200 | |
performance_schema_max_mutex_instances : 1000000 | |
performance_schema_max_rwlock_classes : 30 | |
performance_schema_max_rwlock_instances : 1000000 | |
performance_schema_max_table_handles : 100000 | |
performance_schema_max_table_instances : 50000 | |
performance_schema_max_thread_classes : 50 | |
performance_schema_max_thread_instances : 1000 | |
pid_file : /rdsdbdata/log/mysql-3306.pid | |
plugin_dir : /rdsdbbin/mysql-5.5.27.R1/lib/plugin/ | |
port : 3306 | |
preload_buffer_size : 32768 | |
profiling : OFF | |
profiling_history_size : 15 | |
protocol_version : 10 | |
proxy_user : | |
pseudo_thread_id : 127 | |
query_alloc_block_size : 8192 | |
query_cache_limit : 1048576 | |
query_cache_min_res_unit : 4096 | |
query_cache_size : 0 | |
query_cache_type : ON | |
query_cache_wlock_invalidate : OFF | |
query_prealloc_size : 8192 | |
rand_seed1 : 0 | |
rand_seed2 : 0 | |
range_alloc_block_size : 4096 | |
read_buffer_size : 262144 | |
read_only : OFF | |
read_rnd_buffer_size : 524288 | |
relay_log : /rdsdbdata/log/relaylog/relaylog | |
relay_log_index : | |
relay_log_info_file : relay-log.info | |
relay_log_purge : ON | |
relay_log_recovery : OFF | |
relay_log_space_limit : 0 | |
report_host : | |
report_password : | |
report_port : 3306 | |
report_user : | |
rpl_recovery_rank : 0 | |
secure_auth : OFF | |
secure_file_priv : /tmp/ | |
server_id : 1701460335 | |
skip_external_locking : ON | |
skip_name_resolve : OFF | |
skip_networking : OFF | |
skip_show_database : OFF | |
slave_compressed_protocol : OFF | |
slave_exec_mode : STRICT | |
slave_load_tmpdir : /rdsdbdata/tmp | |
slave_max_allowed_packet : 1073741824 | |
slave_net_timeout : 3600 | |
slave_skip_errors : OFF | |
slave_transaction_retries : 10 | |
slave_type_conversions : | |
slow_launch_time : 2 | |
slow_query_log : OFF | |
slow_query_log_file : /rdsdbdata/db/ip-10-146-2-107-slow.log | |
socket : /tmp/mysql.sock | |
sort_buffer_size : 2097152 | |
sql_auto_is_null : OFF | |
sql_big_selects : ON | |
sql_big_tables : OFF | |
sql_buffer_result : OFF | |
sql_log_bin : ON | |
sql_log_off : OFF | |
sql_low_priority_updates : OFF | |
sql_max_join_size : 18446744073709551615 | |
sql_mode : | |
sql_notes : ON | |
sql_quote_show_create : ON | |
sql_safe_updates : OFF | |
sql_select_limit : 18446744073709551615 | |
sql_slave_skip_counter : 0 | |
sql_warnings : OFF | |
ssl_ca : /rdsdbdata/rds-metadata/ca-cert.pem | |
ssl_capath : | |
ssl_cert : /rdsdbdata/rds-metadata/server-cert.pem | |
ssl_cipher : EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA | |
ssl_key : /rdsdbdata/rds-metadata/server-key.pem | |
storage_engine : InnoDB | |
stored_program_cache : 256 | |
sync_binlog : 0 | |
sync_frm : ON | |
sync_master_info : 0 | |
sync_relay_log : 0 | |
sync_relay_log_info : 0 | |
system_time_zone : UTC | |
table_definition_cache : 400 | |
table_open_cache : 400 | |
thread_cache_size : 0 | |
thread_concurrency : 10 | |
thread_handling : one-thread-per-connection | |
thread_stack : 196608 | |
time_format : %H:%i:%s | |
time_zone : UTC | |
timed_mutexes : OFF | |
timestamp : 1350542175 | |
tmp_table_size : 16777216 | |
tmpdir : /rdsdbdata/tmp | |
transaction_alloc_block_size : 8192 | |
transaction_prealloc_size : 4096 | |
tx_isolation : REPEATABLE-READ | |
unique_checks : ON | |
updatable_views_with_limit : YES | |
version : 5.5.27-log | |
version_comment : Source distribution | |
version_compile_machine : x86_64 | |
version_compile_os : Linux | |
wait_timeout : 28800 | |
warning_count : 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment