[client] port=4407 [mysql] default-character-set=latin1 [mysqld] port=3306 skip-name-resolve basedir="G:/MySQL" datadir="G:/MySQL/Data/" default-character-set=latin1 default-storage-engine=MYISAM sql-mode="NO_AUTO_CREATE_USER" max_connections=4000 max_connect_error=10 skip-locking key_buffer = 16M myisam_sort_buffer_size = 32M join_buffer_size = 1M read_buffer_size = 8M sort_buffer_size = 2M table_cache = 2K thread_cache_size = 128 interactive_timeout = 25 thread_cache = 128 wait_timeout = 300 connect_timeout = 30 tmp_table_size = 31M max_allowed_packet = 16M read_rnd_buffer_size = 1 bulk_insert_buffer_size = 8M thread_concurrency = 512 query_cache_limit = 64M query_cache_size = 128M query_cache_type = 1 # query_prealloc_size = 16384 # query_alloc_block_size = 16384 # myisam_max_sort_file_size=100G # myisam_max_extra_sort_file_size=100G # myisam_sort_buffer_size=2M key_buffer_size = 16M read_buffer_size = 64K read_rnd_buffer_size = 256K sort_buffer_size = 208K skip-innodb [mysqld_safe] open_files_limit = 16k