mysqld settings: ft_min_word_len | 3 | key_buffer_size | 384M | max_allowed_packet | 16M | thread_stack | 256K | thread_cache_size | 8 | max_connections | 500 | query-cache-type | 1 | query_cache_limit | 5M | query_cache_size | 500M | max_heap_table_size | 536870912 | tmp_table_size | 536870912 | table_open_cache | 2500 | log-bin | mysql-bin | binlog_format | mixed |
innodb settings: innodb_buffer_pool_size | 2000M |
| innodb_additional_mem_pool_size | 200M | deprecated | innodb_log_buffer_size | 5M |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_lock_wait_timeout | 50 |
|
On systems with networked file storage (SANS) with slow disk IO times considerer usinginnodb_flush_log_at_trx_commit = 2. See 'adaptive flushing' for a description of the consequence. mysqldump settings: quick |
| max_allowed_packet | 24M |
|