[client] port=3306 socket=/data/mysql/mysql.sock [mysqld_safe] nice = -15 [mysqld] datadir = /data/mysql socket = /data/mysql/mysql.sock tmp_table_size = 64M key_buffer_size = 16M read_buffer_size = 1M sort_buffer_size = 16M innodb_buffer_pool_size = 5G innodb_log_file_size = 512M innodb_log_buffer_size = 512M innodb_data_file_path=ibdata1:500M:autoextend innodb_autoextend_increment=512 innodb_file_per_table max_allowed_packet=16M net_buffer_length = 32768 query_cache_size = 256M thread_cache_size = 64 max_connections = 2000 log_slow_queries = slow_queries.log log_error = error.log lower-case-table-names = 1 tmpdir = /data/mysql/tmp default-table-type=innodb # utf8 default-character-set=utf8 log-bin = /home/mysql_logs/binary_log table_cache = 1024 # Replication skip-slave-start server-id = 201204 replicate-same-server-id = 0 master-host = slave master-port = 3307 master-user = slave master-password = password relay-log = /data/mysql/relay-bin relay-log-index = /data/mysql/relay-bin log-slave-updates ## Slave options only #read-only innodb_flush_log_at_trx_commit=2