2003server+IIS6.0+PHP+MYSQL下
针对4G内存8个2.66G CPU
主要使用MyISAM
连接数量较多的mysql服务器
看我配制的my.ini是不是合理,请指正,谢谢。[mysql]
default-character-set=utf8
default-character-set=utf8
default-storage-engine=MYISAM
max_connections=2048
query_cache_size=95M
table_cache=3944
tmp_table_size=512M
thread_cache_size=256
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=83M
key_buffer_size=512M
read_buffer_size=8M
read_rnd_buffer_size=32M
sort_buffer_size=64M
skip-innodb
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=4M
innodb_buffer_pool_size=8M
innodb_log_file_size=10M
innodb_thread_concurrency=8
针对4G内存8个2.66G CPU
主要使用MyISAM
连接数量较多的mysql服务器
看我配制的my.ini是不是合理,请指正,谢谢。[mysql]
default-character-set=utf8
default-character-set=utf8
default-storage-engine=MYISAM
max_connections=2048
query_cache_size=95M
table_cache=3944
tmp_table_size=512M
thread_cache_size=256
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=83M
key_buffer_size=512M
read_buffer_size=8M
read_rnd_buffer_size=32M
sort_buffer_size=64M
skip-innodb
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=4M
innodb_buffer_pool_size=8M
innodb_log_file_size=10M
innodb_thread_concurrency=8
可以有特殊字符,比如〓★●→☞
我也不知道是TEXT还是VARCHAR,这个在那里看哦?
SHOW COLUMNS
DESCRIBE tbl_name
myisam_max_sort_file_size=10GB
一般来讲,此值设为物理内存的30-40%
D:\mysql\bin\mysqld-nt: Out of memory (Needed 1676220 bytes)