使用mysql命令登陆数据库时有时候会卡在那里很慢,查看日志,确定没有报错,进程正常,登陆的用户也不是很多,网络也没有问题,我们可以尝试在配置文件中添加skip-name-resolve选项,配置文件内容如下:
- [mysqld7]
- socket = /disk2/mysql5.0/data/mysql7_wper/mysql.sock
- port = 3307
- pid-file = /disk2/mysql5.0/data/mysql7_wper/mysql.pid
- datadir = /disk2/mysql5.0/data/mysql7_wper/
- user = mysql
- server-id = 30
- log-bin = mysql-bin
- expire_logs_days = 7
- master-host=192.168.192.91
- master-port=3306
- master-user=backup
- master-password=wxxx
- replicate_do_db=bbs_weand_com
- skip-name-resolve
重启服务,再尝试登陆是不是会感觉很快呢
因为mysql在用户登陆的时候, 需要进行用户来源地址的反向解析验证, 参数”skip-name-resolve”明确指定跳过此操作.
转载于:https://blog.51cto.com/leezqang/950047