mysql显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known错误解决
来源:互联网 发布:java available的用法 编辑:程序博客网 时间:2024/06/06 00:48
mysql日志显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known,那是因为mysql默认会反向解析DNS,对于访问者Mysql不会判断是hosts还是ip都会进行dns反向解析,频繁地查询数据库和权限检查,这大大增加了数据库的压力,导致数据库连接缓慢,严重的时候甚至死机,出现“连接数据库时出错”等字样。
解决办法:禁用dns反查即可
进入/etc 找到mysql的配置文件my.cnf(linux环境下)或者my.ini(windows环境下)进行编辑加入如下一行即可:
[mysqld]
skip-name-resolve
阅读全文
0 0
- mysql显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known错误解决
- IP address '121.41.35.30' could not be resolved: Name or service not known解决方法
- [Warning] IP address'10.0.9.121' could not be resolved: Temporary failure in name resolution
- could not translate host name “localhost”, service “5432″ to address: Name or service not known
- install LuaForWindow 提示The server name or address could not be resolved. 错误
- MySQL告警: [Warning] IP address '10.176.246.53' could not be resolved: Temporary fail
- [MySQL]IP address '192.168.31.110' could not be resolved: Temporary failure in name resolution
- skip-name-resolve && skip-host-cache && mysql IP address could not be resolved
- mysql IP address 'xxx' could not be resolved
- git错误--ssh: Could not resolve hostname ssh.github.com: Name or service not known--解决方式
- git错误--ssh: Could not resolve hostname ssh.github.com: Name or service not known--解决方式
- Unable to resolve address ' ' service ' ': Name or service not known
- Unable to resolve address ' ' service ' ': Name or service not known
- java.net.UnknownHostException: XXXX Name or service not known
- Could not resolve hostname 。。。。。。: Name or service not known
- IP address could not be resolved: Temporary failure in name resolution
- IP address could not be resolved: Temporary failure in name resolution
- IP address could not be resolved: Temporary failure in name resolution
- Java监听器Listener使用说明
- BZOJ4416: [Shoi2013]阶乘字符串
- 年年岁岁花相似,岁岁年年人不同——我的2016跨2017
- opencv转换颜色表示法
- running beyond virtual/physical memory limits问题解决
- mysql显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known错误解决
- Maven私服的搭建
- kinect骨骼追踪
- opencv图像叠加
- NOIP 2003 提高组 复赛 加分二叉树
- 快速工作术
- C++通过Wininet库提交POST信息登录到PHPChina中文开发者社区
- 交叉证书
- ~