mysql打开速度很慢
来源:互联网 发布:金融行业的大数据 编辑:程序博客网 时间:2024/04/28 14:55
最近在Linux服务器上安装MySql5后,本地使用客户端连MySql速度超慢,本地程序连接也超慢。
解决方法:在配置文件my.cnf的[mysqld]下加入skip-name-resolve。
原因是默认安装的MySql开启了DNS的反向解析。如果禁用的话就不能在MySQL的授权表中使用主机名了而只能用ip格式。
附:How MySQL uses DNSWhen a new thread connects to mysqld, mysqld will spawn a new thread to handle the request. This thread will first check if the hostname is in the hostname cache. If not the thread will call gethostbyaddr_r() and gethostbyname_r() to resolve the hostname.
If the operating system doesn't support the above thread-safe calls, the thread will lock a mutex and call gethostbyaddr() and gethostbyname() instead. Note that in this case no other thread can resolve other hostnames that is not in the hostname cache until the first thread is ready.
You can disable DNS host lookup by starting mysqld with --skip-name-resolve. In this case you can however only use IP names in the MySQL privilege tables.
If you have a very slow DNS and many hosts, you can get more performance by either disabling DNS lookup with --skip-name-resolve or by increasing the HOST_CACHE_SIZE define (default: 128) and recompile mysqld.
You can disable the hostname cache with --skip-host-cache. You can clear the hostname cache with FLUSH HOSTS or mysqladmin flush-hosts.
If you don't want to allow connections over TCP/IP, you can do this by starting mysqld with --skip-networking.
0 0
- mysql打开速度很慢
- PHP网站打开速度很慢
- WordPress打开速度很慢的解决方法
- 网站打开速度慢
- PHP+MySQL网站打开速度慢的几个因素
- mysql cluster 子查询速度很慢
- mysql第一次查询速度很慢
- MYSQL远程速度慢
- MYSQL远程连接速度慢
- IE打开速度慢的解决办法
- 网站为何打开速度慢原因分析
- IE8 打开速度慢的解决办法
- IE8打开网页慢速度优化
- SecureCRT远程连接打开速度慢
- stackoverflow打开速度慢的一种解决方法
- 网站打开速度慢的原因
- wordpress后台打开速度非常慢怎么办
- 为什么打开网页速度慢,或者很难打开网页,无法收发邮件?
- js基本功能大全
- 图像序列合成视频
- 福建第四届省赛
- Arduino - 编程参考手册
- 解决ubuntu鼠标自动休眠引起鼠标失灵的问题
- mysql打开速度很慢
- 最简单的奇数阶幻方(魔方)算法详解
- Spark SQL and DataFrames Version 1.6
- leetcode (1) Two Sum js代码实现
- LINUX执行 .run文件
- UDP通信
- 第十六周--学期总结
- iOS中self.和下划线的区别
- (解题报告)HDU2024---C语言合法标识符