mysql 进程中总是有很多 unauthenticated user 用户

多机连接 mysql,做服务器群,最近总发现有很多 unauthenticated user ,经查询是mysql 做反查超时造成的,

查了些资料说要修改 my.inf ,同时要增加 hosts 文件中关于服务器的地址。不知道是否真的管用,还需要在观察些时间吧 

port=3306

set-variable = key_buffer_size=64M
set-variable = max_connections=1024
set-variable = interactive_timeout=30
set-variable = wait_timeout=30
set-variable = join_buffer_size=10M
set-variable = long_query_time=20
set-variable = table_cache=256
set-variable = sort_buffer=4M
set-variable = record_buffer=1M
set-variable = back_log=500

skip-name-resolve
skip-locking

发布者

admin

互联网web开发管理