[mysqld] skip-locking query_cache_size = 250M query_cache_limit = 20M max_connections = 800 max_allowed_packet = 8M table_cache = 800 thread_cache = 32 log-slow-queries default-table-type = InnoDB key_buffer = 5M sort_buffer_size = 1M record_buffer = 1M myisam_sort_buffer_size = 1M read_rnd_buffer_size = 1M innodb_file_per_table innodb_data_file_path = ibdata1:100M:autoextend innodb_autoextend_increment = 100M innodb_buffer_pool_size = 4500M innodb_additional_mem_pool_size = 10M innodb_log_file_size = 250M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 transaction-isolation = READ-COMMITTED thread_concurrency = 4 open_files_limit = 4200 max_connect_errors = 999999999 relay_log=/usr/local/mysql/data/relay-bin relay_log_index=/usr/local/mysql/data/relay-bin.index log-bin=/usr/local/mysql/data/binlog master-host=xxx master-port=xxx master-user=xxx master-password=xxx server-id=8 [mysql] i-am-a-dummy prompt=\h/\d>\_