[mysqld] ###################################################### ###### General settings ###### ###################################################### max_allowed_packet = 256M tmpdir = /var/lib/tmpfs datadir = /var/lib/mysql/ transaction-isolation = READ-COMMITTED relay-log = ppmaster-relay-bin skip-name-resolve bind-address=192.168.0.10 #extra_port = 3316 #extra_max_connections = 2 # LOGGING # log-error = /var/log/mysql/mysql-error.log log-queries-not-using-indexes = 0 slow-query-log = 1 slow-query-log-file = /var/log/mysql/mysql-slow.log slow_query_log_use_global_control = 1 long_query_time = 1 ###################################################### ###### Replication and binlogs ###### ###################################################### server-id = 21 replicate-do-db = ppdb #slave-skip-errors=1062 ###################################################### ###### Performance ###### ###################################################### thread_stack = 256K thread_cache_size = 2048 thread_concurrency = 16 max_connections = 1200 open-files-limit = 65535 table_cache = 50000 #table_open_cache = 50000 #query_cache_limit = 1M #query_cache_size = 512M query_cache_type = OFF innodb_old_blocks_time = 0 #MySQL 5.5 innodb_buffer_pool_size = 40G innodb-use-sys-malloc = 0 innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_file_per_table = 1 #thread_handling = pool-of-threads #Oct 2013, execution plan stability innodb_stats_sample_pages = 32 innodb_stats_on_metadata = 0