mysql could not be resolved: Name or service not known
2024-08-27 04:01:20
问题: mysql DNS反解:skip-name-resolve
错误日志有类似警告:
1.120119 16:26:04 [Warning] IP address '192.168.1.10' could not be resolved: Name or service not known
2.120119 16:26:04 [Warning] IP address '192.168.1.14' could not be resolved: Name or service not known
3.120119 16:26:04 [Warning] IP address '192.168.1.17' could not be resolved: Name or service not known
通过show processlist发现大量类似如下的连接:
1.|592|unauthenticated user|192.168.1.10:35320|NULL|Connect| |login|NULL|
2.|593|unauthenticated user|192.168.1.14:35321|NULL|Connect| |login|NULL|
3.|594|unauthenticated user|192.168.1.17:35322|NULL|Connect| |login|NULL|
skip-name-resolve 参数的作用:不再进行反解析(ip不反解成域名),这样可以加快数据库的反应时间。
修改配置文件添加并需要重启:
复制代码代码如下:
[mysqld]
skip-name-resolve
skip-name-resolve
其实就是在[mysqld]下面一行加入skip-name-resolve重启mysql服务就可以了。
最新文章
- TypeError: test() got multiple values for keyword argument 'key'
- java模拟面试 试题
- sql server 表中的编号自增
- SQLAlchemy模型使用
- java中泛型上限,下限应用
- 【08_238】Product of Array Except Self
- Ubuntu 下忘记mysql 密码
- AngularJs学习教程
- C#主要支持 5 种动态创建对象的方式
- yii2 ActiveRecord常用用法
- Printing Architecture
- Android,机器狗应用
- ssh The authenticity of host 192.168.0.xxx can't be established
- C#处理JSON 数据
- ZooKeeper介绍,安装,配置文件解析
- firewall防火墙
- Android测试中常用的adb命令
- ps | grep排除grep这个进程
- 线程安全的CopyOnWriteArrayList
- mac 安装Seaslog扩展及SeasLogger应用