由 robocat 在 02-05-2004 17:59 发表:
大家看看我的mysql，为什么我的vbb论坛回贴要差不多30秒才有反映，删除、编辑等很快
服务器变量和设置
变量 会话值 全局值
back log 50 50
basedir /opt/mysql/ /opt/mysql/
binlog cache size 32768 32768
bulk insert buffer size 8388608 8388608
character set gb2312 gb2312
character sets gb2312 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251 gb2312 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251
concurrent insert ON ON
connect timeout 30 30
convert character set
datadir /opt/mysql/var/ /opt/mysql/var/
default week format 0 0
delay key write ON ON
delayed insert limit 100 100
delayed insert timeout 300 300
delayed queue size 1000 1000
flush OFF OFF
flush time 0 0
ft boolean syntax + -><()~:""&| + -><()~:""&|
ft min word len 4 4
ft max word len 254 254
ft max word len for sort 20 20
ft stopword file (built-in) (built-in)
have bdb NO NO
have crypt YES YES
have innodb YES YES
have isam YES YES
have raid NO NO
have symlink YES YES
have openssl NO NO
have query cache YES YES
init file
innodb additional mem pool size 1048576 1048576
innodb buffer pool size 8388608 8388608
innodb data file path ibdata1:10M:autoextend ibdata1:10M:autoextend
innodb data home dir
innodb file io threads 4 4
innodb force recovery 0 0
innodb thread concurrency 8 8
innodb flush log at trx commit 1 1
innodb fast shutdown ON ON
innodb flush method
innodb lock wait timeout 50 50
innodb log arch dir ./ ./
innodb log archive OFF OFF
innodb log buffer size 1048576 1048576
innodb log file size 5242880 5242880
innodb log files in group 2 2
innodb log group home dir ./ ./
innodb mirrored log groups 1 1
innodb max dirty pages pct 90 90
interactive timeout 30 30
join buffer size 131072 131072
key buffer size 16777216 16777216
language /opt/mysql/share/mysql/english/ /opt/mysql/share/mysql/english/
large files support ON ON
local infile ON ON
locked in memory OFF OFF
log OFF OFF
log update OFF OFF
log bin ON ON
log slave updates OFF OFF
log slow queries OFF OFF
log warnings OFF OFF
long query time 10 10
low priority updates OFF OFF
lower case table names OFF OFF
max allowed packet 1047552 1047552
max binlog cache size 4294967295 4294967295
max binlog size 1073741824 1073741824
max connections 1000 1000
max connect errors 100 100
max delayed threads 20 20
max heap table size 16777216 16777216
max join size 4294967295 4294967295
max relay log size 0 0
max seeks for key 4294967295 4294967295
max sort length 1024 1024
max user connections 0 0
max tmp tables 32 32
max write lock count 4294967295 4294967295
myisam max extra sort file size 268435456 268435456
myisam max sort file size 2147483647 2147483647
myisam repair threads 1 1
myisam recover options OFF OFF
myisam sort buffer size 8388608 8388608
net buffer length 8192 8192
net read timeout 30 30
net retry count 10 10
net write timeout 60 60
new OFF OFF
open files limit 5010 5010
pid file /opt/mysql/var/roboweb.pid /opt/mysql/var/roboweb.pid
log error
port 3306 3306
protocol version 10 10
query alloc block size 8192 8192
query cache limit 1048576 1048576
query cache size 671088