[client] port = %mysqlport% #character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" default-character-set=cp1251 [mysql] character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" no-auto-rehash no-beep [mysqld] #skip-character-set-client-handshake #skip-name-resolve #sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" %log%general_log = 1 %log%general_log_file = "%dprogdir%\\userdata\\logs\\%mysql_driver%_queries.log" back_log = 100 basedir = "%dprogdir%\\modules\\database\\%mysql_driver%" bind-address = %ip% bulk_insert_buffer_size = 200M character-set-server=%sqlchr% character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" collation-server=%mysqlcharset% connect_timeout = 6 datadir = "%dprogdir%\\userdata\\%mysql_driver%" default-storage-engine=InnoDB expire_logs_days = 2 ft_min_word_len=4 init-connect="SET NAMES %sqlchr%" interactive_timeout=28800 join_buffer_size = 100M key_buffer_size = 125M local-infile=0 log-error = "%dprogdir%\\userdata\\logs\\%mysql_driver%_error.log" lower_case_table_names = 1 max_allowed_packet = 1024M max_connect_errors = 10 max_connections = 70 max_heap_table_size = 225M max_tmp_tables = 125 myisam-recover-options=backup,force myisam_max_sort_file_size = 256M myisam_repair_threads = 1 pid_file = "%dprogdir%\\userdata\\temp\\mysql.pid" port = %mysqlport% query_cache_limit = 999K query_cache_size=250M read_buffer_size=200M read_rnd_buffer_size=4M server-id = 1 skip-external-locking skip-innodb_adaptive_hash_index sort_buffer_size = 10M table_open_cache = 969 thread_cache_size = 4 tmp_table_size = 25M tmpdir = "%dprogdir%\\userdata\\temp" transaction-isolation = READ-COMMITTED wait_timeout=99999 #innodb_fast_shutdown #innodb_file_per_table = 1 #innodb_force_recovery=1 #skip-innodb_doublewrite innodb_additional_mem_pool_size = 10M innodb_buffer_pool_size = 200M innodb_data_file_path = ibdata1:10M:autoextend innodb_data_home_dir = "%dprogdir%\\userdata\\%mysql_driver%" innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 30 innodb_log_buffer_size = 1M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb_read_io_threads=4 innodb_thread_concurrency=4 innodb_write_io_threads=4 [mysqldump] quick max_allowed_packet = 1024M [myisamchk] key_buffer_size = 150M sort_buffer_size = 150M read_buffer = 168M write_buffer = 188M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 2048