系统级故障回顾

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使用的内存超过操作系统一半的内存，，，