[client] port = 3306 socket = /tmp/mysql.sock # The MySQL server configuration [mysqld] port = 3306 bind-address = 127.0.0.1 socket = /tmp/mysql.sock default-character-set = utf8 character-set-server = utf8 default-collation = utf8_general_ci skip-locking key_buffer = 16K max_allowed_packet = 4M table_cache = 128 sort_buffer_size = 64K read_buffer_size = 4096K read_rnd_buffer_size = 1024K thread_stack = 256K key_buffer_size = 10M tmp_table_size = 256M max_heap_table_size = 256M thread_cache_size = 64 query_cache_limit = 64k query_cache_size = 64k query_cache_type = 2 log_warnings = 0 log_slow_queries = /var/log/mysql-slow.log long_query_time = 5 max_connections = 8 tmpdir = /var/tmp wait_timeout = 600 interactive_timeout = 600 connect_timeout = 600 skip-federated server-id = 1 low_priority_updates = 1 log-bin=mysql-bin expire_logs_days = 1 sync_binlog = 0 log-queries-not-using-indexes = 1 concurrent_insert = 2 skip-innodb # InnoDB tables configuration innodb_data_home_dir = /srv/databases/mysql innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /srv/databases/mysql innodb_log_arch_dir = /srv/databases/mysql innodb_buffer_pool_size = 32M innodb_additional_mem_pool_size = 4M innodb_log_file_size = 8M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 600 innodb_thread_concurrency = 2 thread_concurrency = 2 [mysqldump] quick max_allowed_packet = 8M [mysql] no-auto-rehash [isamchk] key_buffer = 4M sort_buffer_size = 4M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 4M sort_buffer_size = 4M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout