- 论坛徽章:
- 0
|
cpu是2.4HZ, 2G内存
系统是FreeBSD6.0
top参数:
last pid: 2457; load averages: 4.11, 3.89, 2.09 up 0+00:11:26 10:26:24
289 processes: 1 starting, 5 running, 283 sleeping
CPU states: 45.9% user, 0.0% nice, 3.8% system, 0.0% interrupt, 50.3% idle
Mem: 1457M Active, 194M Inact, 203M Wired, 47M Cache, 112M Buf, 105M Free
Swap: 4070M Total, 240K Used, 4069M Free
mysql配置:
#log_slow_queries
skip-locking
skip-innodb
#key_buffer = 200M
#max_allowed_packet = 1M
#table_cache = 512k
#sort_buffer_size = 3M
read_buffer_size = 500
#read_rnd_buffer_size = 4M
#myisam_sort_buffer_size = 64M
#thread_cache_size = 256
query_cache_size= 32M
#tmp_table_size = 500M
max_connections=200
#default-character-set=gb2312
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
wait_timeout=120
现在的情况时mysql链接一上120,就导致整个服务器运行很慢,页面也打不开,请问以上的配置需要修改哪些地方? |
|