因为哈希碰撞漏洞原因,升级了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/databasedefault-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 = 120language= 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 = 2tmpdir=c:/server/temp/mysql
#*** MyISAM Specific optionsmyisam_sort_buffer_size=16M
key_buffer_size = 8M
用的是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/databasedefault-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 = 120language= 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 = 2tmpdir=c:/server/temp/mysql
#*** MyISAM Specific optionsmyisam_sort_buffer_size=16M
key_buffer_size = 8M
在linux下我测试过了,没楼主说的事.