- 论坛徽章:
- 0
|
我有一台论坛的数据库服务器配置是2颗4核CPU,8G内存,目前数据库中的单个表最大为5.3G,索引最大为1.7G, 数据库的my.cnf配置如下:
wait_timeout = 5
interactive_timeout=10
key_buffer_size = 800M
max_allowed_packet = 32M
table_cache = 4096
record_buffer=400M
sort_buffer_size = 16M
net_buffer_length = 2M
myisam_sort_buffer_size = 256M
thread_cache_size = 64
read_buffer_size = 64M
read_rnd_buffer_size = 100M
query_cache_size = 64M
query_cache_type= 1
long_query_time = 4
log-slow-queries = /database/mysql/slowsql.sql
thread_concurrency=8
tmp_table_size=1000M
max_connections=1000
max_heap_table_size = 800M
skip-bdb
skip-name-resolve
join_buffer_size=64M
default-character-set = gbk
open_files_limit = 4096
请大家帮我建议建议,论坛的访问量很大,会出现每个两三天就重启(内存不够)的现象,
[ 本帖最后由 xueleixu 于 2008-7-22 22:52 编辑 ] |
|