https://blog.youkuaiyun.com/aniwnzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/aniwn/article/details/6743978https://blog.youkuaiyun.com/aniwn/article/details/6743978aniwnFri, 02 Sep 2011 18:14:25 +0800https://blog.youkuaiyun.com/aniwn/article/details/5899591https://blog.youkuaiyun.com/aniwn/article/details/5899591aniwnTue, 21 Sep 2010 15:34:00 +0800问题是80的apache转发到8080的apache时失败：
[error] (99)Cannot assign requested address: proxy: HTTP: attempt to connect to 127.0.0.1:8080 (*) failed

netstat里time wait太多导致了[error] (99)Cannot assign requested address

sysctl -w net.ipv4.t]]>https://blog.youkuaiyun.com/aniwn/article/details/5873312https://blog.youkuaiyun.com/aniwn/article/details/5873312aniwnThu, 09 Sep 2010 14:21:00 +0800昨天经历了一次mysql灾难，mysqld打开文件数用光，导致一系列问题的发生。
 
一开始是页面打不开，观察web服务器，apache进城挂住，显然是连接db出问题了，再看mysql，mysql登入，并没有如以前顺畅的登入显示提示符，而是卡着不动，等了半天，终于进去了。
输入show processlist;thread数正常，几乎没有sql语句在执行；
系统console下top，load正常，这下有点瞎，web和db服务器负担都挺小的啊，怎么就卡住不]]>https://blog.youkuaiyun.com/aniwn/article/details/5856186https://blog.youkuaiyun.com/aniwn/article/details/5856186aniwnWed, 01 Sep 2010 17:50:00 +0800以前也看到这个报错，一直没有解决，偶尔报的多了，重启mysqld就解决了。
 
今天又看了一下，每次报这个错的时候系统负载都很高，内存吃光这些都不是主要问题，关键在于可以打开的文件句柄数超过了my.cnf的--open-files-limit。
 
那么怎么解决了，无非就是在机器硬件许可的情况下加大这个值，注意，修改这个值是需要重启mysqld的，考虑到报错不多，生产服务器能不重启就不重启，所以先这么放着了，去优化一下其他地方，别的地方打开文件少了，自然就]]>https://blog.youkuaiyun.com/aniwn/article/details/5841197https://blog.youkuaiyun.com/aniwn/article/details/5841197aniwnThu, 26 Aug 2010 16:39:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/5671907https://blog.youkuaiyun.com/aniwn/article/details/5671907aniwnTue, 15 Jun 2010 10:43:00 +08001、slave上的log-bin开启了，但是没有正常记录日志，导致replication错位时不知道应该change master到哪里
2、replication为什么会错位
 
问题待解决。]]>https://blog.youkuaiyun.com/aniwn/article/details/5299098https://blog.youkuaiyun.com/aniwn/article/details/5299098aniwnMon, 08 Feb 2010 16:20:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/4417503https://blog.youkuaiyun.com/aniwn/article/details/4417503aniwnThu, 06 Aug 2009 10:46:00 +0800 check table member;+--------------------+-------+----------+-----------------------------+| Table              | O]]>https://blog.youkuaiyun.com/aniwn/article/details/3318416https://blog.youkuaiyun.com/aniwn/article/details/3318416aniwnMon, 17 Nov 2008 11:33:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/3246631https://blog.youkuaiyun.com/aniwn/article/details/3246631aniwnFri, 07 Nov 2008 14:34:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/3237107https://blog.youkuaiyun.com/aniwn/article/details/3237107aniwnThu, 06 Nov 2008 13:27:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/3183062https://blog.youkuaiyun.com/aniwn/article/details/3183062aniwnThu, 30 Oct 2008 11:18:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/2490767https://blog.youkuaiyun.com/aniwn/article/details/2490767aniwnWed, 28 May 2008 15:53:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/2163794https://blog.youkuaiyun.com/aniwn/article/details/2163794aniwnMon, 10 Mar 2008 16:05:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/2087885https://blog.youkuaiyun.com/aniwn/article/details/2087885aniwnSun, 10 Feb 2008 21:52:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/2033872https://blog.youkuaiyun.com/aniwn/article/details/2033872aniwnThu, 10 Jan 2008 15:41:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/1965211https://blog.youkuaiyun.com/aniwn/article/details/1965211aniwnMon, 24 Dec 2007 16:53:00 +0800new->get(http://www.sohu.co]]>https://blog.youkuaiyun.com/aniwn/article/details/1946231https://blog.youkuaiyun.com/aniwn/article/details/1946231aniwnTue, 18 Dec 2007 09:44:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/1417963https://blog.youkuaiyun.com/aniwn/article/details/1417963aniwnTue, 28 Nov 2006 09:39:00 +0800https://blog.youkuaiyun.com/aniwn/article/details/467910https://blog.youkuaiyun.com/aniwn/article/details/467910aniwnTue, 30 Aug 2005 14:55:00 +0800