升级到了PHP5.3.10和MySQL5.1.61,数据库查询总有两稍迟钝
ABC从 2012-02-28 10:49:30 因为哈希碰撞漏洞原因,升级了PHP和MySQL,但现在程序在查询数据库时总有两秒的迟钝,很不爽啊。
用的是PHP的Mysqld连接的数据库,下面的MySQL的配置。请高人指点。
[client]
port=3306
[mysql]
port=3306
default-character-set=UTF8
[mysqld]
basedir = c:/server/mysql
#只监本地端口,不对外公开
bind-address=127.0.0.1
datadir = c:/server/mysql/database
default-character-set=UTF8
default-storage-engine=MyISAM
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
default-time-zone = '+8:00'
interactive_timeout = 120
language= c:/server/mysql/share/english
log_error = c:/erver/logs/mysql.log
key_buffer_size=128M
max_connections = 100
pid_file=C:/Server/temp/mysql.pid
query_cache_size = 128M
query_cache_type = 1
sort_buffer_size = 32M
table_cache = 256
thread_cache=8
#单个CPU核心数*CPU个数
thread_concurrency = 2
tmpdir=c:/server/temp/mysql
#*** MyISAM Specific options
myisam_sort_buffer_size=16M
key_buffer_size = 8M