[mysql] skip_auto_rehash socket=/var/lib/mysql/mysql.sock [client] port = 3306 socket=/var/lib/mysql/mysql.sock [mysql_upgrade] basedir=/usr datadir=/var/lib/mysql user=mysql socket=/var/lib/mysql/mysql.sock [mysqld_safe] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock pid_file=/var/run/mysqld/mysqld.pid log_error=/var/log/mysqld.log [mysql.server] basedir=/usr user=mysql [mysqld] old_passwords=1 engine_condition_pushdown=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock server_id=151 port = 3306 safe-user-create skip_external_locking skip-name-resolve #skip_slave_start language=/usr/share/mysql/english expire_logs_days=60 log_queries_not_using_indexes slow_query_log slow_query_log_file=/var/lib/mysql/ccomr-gdb1.log long_query_time=1 #event_scheduler=on # should only be on for systems that require it auto_increment_increment=1 auto_increment_offset=1 read_only=1 #slaves only ## Charater set defaults #character_set_client=utf8 #character_set_server=utf8 #collation_server=utf8_general_ci ##full text indexing ft_max_word_len=84 ft_min_word_len=4 ft_query_expansion_limit=20 ft_boolean_syntax=+ -><()~*:""&| ## innodb parameters ############################################ innodb_additional_mem_pool_size=1M #innodb_log_file_size=1G # default is 500MB but we want to reduce disk IO and we will take a chance that the crash recovery will be long. innodb_status_file innodb_file_per_table innodb_buffer_pool_size=11G innodb_flush_log_at_trx_commit = 1 #sync_binlog = 1 innodb_rollback_on_timeout #innodb_stats_on_metadata=0 #deactivate this if we are having performance issues default is 1 (on) innodb_support_xa # enabling this is an absolute must for replication (or anything that uses binary logging) ##myisam parameters myisam_data_pointer_size=4 myisam_max_sort_file_size=500M myisam_sort_buffer=16M concurrent_insert=1 join_buffer_size=256M key_buffer_size = 6G #cold_cache.key_buffer=500M #hot_cache.key_buffer=500M #init_file=/var/lib/mysql/mysqld_init.sql table_cache = 4k preload_buffer=16K sort_buffer_size = 2M read_buffer_size = 8M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 16M thread_cache_size = 8 query_cache_size = 12M query_prealloc_size = 24k ##networking parameters max_allowed_packet=8M max_connect_errors=75 max_connections=1500 max_delayed_threads=20 max_error_count=64 max_heap_table_size=16M max_join_size=4G max_relay_log_size=0 max_seeks_for_key=1G max_length_for_sort_data=2k max_sort_length=1k max_tmp_tables=32 max_write_lock_count=1G low_priority_updates=1 back_log=100 wait_timeout=10 connect_timeout=10 interactive_timeout=1800 net_read_timeout=10 ##replication parameters report-host=ccomr-gdb1.cci.clearchannel.com slave_exec_mode=STRICT #IDEMPOTENT for multimaster setups relay-log=/var/lib/mysql/ccomr-gdb1-relay-bin slave_compressed_protocol=1 slave_skip_errors=1062 1452 #<<<<