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 hidden or 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