[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 [mysqld] skip-slave-start ft_min_word_len = 3 character-set-server = utf8 default-character-set = utf8 user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow.log long_query_time = 1 skip-locking key_buffer = 1G max_allowed_packet = 16M table_cache = 5000 thread_cache = 40 sort_buffer_size = 64M net_buffer_length = 8K read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M max_heap_table_size = 256M tmp_table_size = 256M open_files_limit = 16384 language = /usr/share/mysql/english query_cache_size = 128M thread_concurrency = 8 log-bin = /var/log/mysql/mysql-bin server-id = 3 relay-log = /var/log/mysql/mysql_relay_log log-slave-updates replicate-same-server-id = 0 tmpdir = /tmp/ innodb_buffer_pool_size = 384M innodb_additional_mem_pool_size = 20M innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_file_size = 100M innodb_log_buffer_size = 8M set-variable = innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [myisamchk] ft_min_word_len = 3 [mysqldump] quick max_allowed_packet = 64M