[mysqld] server-id = 1 datadir = /mysql tmpdir = /var/tmp pid-file = /mysql/mysql.pid port = 3306 bind = 127.0.0.1 socket = /tmp/mysql.sock skip-name-resolve skip-thread-priority low-priority-updates log-slow-queries skip-grant-tables skip-locking #skip-networking #log = /mysql/mysql.log default-character-set=cp1251 long_query_time=2 wait_timeout=120 key_buffer=256M max_allowed_packet=32M myisam_sort_buffer_size=16M table_cache=512 sort_buffer=4M net_buffer_length=132K max_connections=300 max_user_connections=300 query_cache_limit=8M query_cache_size=64M query_cache_type=1 ft_min_word_len=2 default-table-type=innodb innodb_data_home_dir = /mysql/ innodb_data_file_path = ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:100M:autoextend innodb_log_group_home_dir = /mysql/ innodb_log_arch_dir = /mysql/ innodb_mirrored_log_groups=1 innodb_log_files_in_group=3 innodb_log_file_size=32M innodb_log_buffer_size=32M innodb_flush_log_at_trx_commit=0 innodb_log_archive=0 innodb_buffer_pool_size=256M innodb_additional_mem_pool_size=32M innodb_file_io_threads=4 innodb_thread_concurrency=4 innodb_lock_wait_timeout=50 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer=8M sort_buffer=8M [myisamchk] key_buffer=8M sort_buffer=8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open_files_limit = 8192