http://www.jb51.net/article/35167.htm
https://dev.mysql.com/doc/refman/5.0/en/host-cache.html
现象: http用客户端连接mysql 主库连不上,,,,, 在mysql服务器本地可以连上,,,,在http服务器使用telent port可以连上,,,,,,
mysql机器cpu io负载都正常,,,,, 主库iptables 配置没问题,
思路
查看mysql的错误日志 /log/mysql/dblog/err.log (可以通过show variables like '%err%' 查看错误日志的位置)
2014-02-24 12:27:58 18585 [Warning] IP address '192.168.1.1' could not be resolved: Temporary failure in name resolution
2014-02-24 12:27:58 18585 [Warning] IP address '192.168.1.1' could not be resolved: Temporary failure in name resolution
2014-02-24 12:27:58 18585 [Warning] IP address '192.168.1.1' could not be resolved: Temporary failure in name resolution
2014-02-24 12:27:58 18585 [Warning] IP address '192.168.1.1' could not be resolved: Temporary failure in name resolution
2014-02-24 12:27:58 18585 [Warning] IP address '192.168.1.1' could not be resolved: Temporary failure in name resolution
DNS反向解析导致mysql消耗mysql大量性能,,,,,,
未完待续,,,,,
mysql的问题刚刚修复,,,后面的redis又来了,,,,
redis.clients.jedis.exceptions.JedisDataException: LOADING Redis is loading the dataset in memory
原因是,redis使用的内存超过操作系统一半的内存,,,