[client] default-character-set = cp1251 [mysqld] skip-locking skip-innodb skip-name-resolve user = mysql datadir = /www/db tmpdir = /www/tmp/mysql log-error = /logs/mysql/mysql log-slow-queries = /logs/mysql/mysql-slow.log long_query_time = 10 #skip_grant_tables key_buffer_size = 512M myisam-recover = BACKUP,FORCE #default-character-set = cp1251 #init-connect = "SET NAMES cp1251" max_connections = 384 # 100 max_connect_errors = 10000 # 10 thread_cache_size = 16 # 0 table_cache = 1024 # 64 max_allowed_packet = 16M # 1M myisam_sort_buffer_size = 64M # 8M sort_buffer_size = 4M # 2M read_buffer_size = 1M # 128K read_rnd_buffer_size = 512K # 256K tmp_table_size = 64M # 32M #max_seeks_for_key = 8192 # 4bil query_cache_size = 8M # 0 max_write_lock_count = 8 # 4bil open-files-limit = 1024 # 1024 for linux wait_timeout = 300 lower_case_table_names = 1 log_queries_not_using_indexes = 1 ft_min_word_len = 2 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer = 512M sort_buffer = 512M read_buffer = 64M