- 论坛徽章:
- 0
|
本帖最后由 77902543 于 2011-04-03 05:07 编辑
MySQL - 3.23.58-nt
一般有200多个客户端连接数据库,CPU AMD X2 3600+,MySql的CPU使用率在10~30间,是不是有点高了啊?
服务器变量和设置
变量 值
back log 50
basedir F:\mysql\
binlog cache size 32,768
character set latin1
character sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent insert ON
connect timeout 5
datadir F:\mysql\data\
delay key write ON
delayed insert limit 100
delayed insert timeout 300
delayed queue size 1,000
flush OFF
flush time 1,800
have bdb NO
have gemini NO
have innodb NO
have isam YES
have raid NO
have openssl NO
init file
interactive timeout 28,800
join buffer size 131,072
key buffer size 8,388,600
language F:\mysql\share\english\
large files support ON
log OFF
log update OFF
log bin OFF
log slave updates OFF
log long queries OFF
long query time 10
low priority updates OFF
lower case table names 1
max allowed packet 1,048,576
max binlog cache size 4,294,967,295
max binlog size 1,073,741,824
max connections 10,240
max connect errors 10
max delayed threads 20
max heap table size 16,777,216
max join size 4,294,967,295
max sort length 1,024
max user connections 0
max tmp tables 32
max write lock count 4,294,967,295
myisam max extra sort file size 256
myisam max sort file size 2,047
myisam recover options 0
myisam sort buffer size 8,388,608
named pipe OFF
net buffer length 16,384
net read timeout 30
net retry count 10
net write timeout 60
open files limit 0
pid file F:\mysql\data\qiyue01.pid
port 3,306
protocol version 10
record buffer 131,072
record rnd buffer 131,072
query buffer size 0
safe show database OFF
server id 0
slave net timeout 3,600
skip locking ON
skip networking OFF
skip show database OFF
slow launch time 2
socket MySQL
sort buffer 2,097,144
sql mode 0
table cache 64
table type MYISAM
thread cache size 0
thread stack 65,536
transaction isolation READ-COMMITTED
timezone 中国标准时间
tmp table size 33,554,432
tmpdir C:\WINDOWS\TEMP\
version 3.23.58-nt
wait timeout 28,800 |
|