上周日，一台服务器无故停止服务，不能ssh，只能重启后恢复服务，对业务影响很大。
今天，一台DB服务器再次服务SSH，ping不通，最后也只能重启解决。
重启服务器后，MySQL自动拉起，服务程序自动拉起，出现的一个不清楚的问题：
InnoDB在重启后进行bin log的恢复过程中，应用程序的连接请求被挂起，一直等到恢复完成，ready for connections后client才真正连接上，等待连接的这段时间发生了什么呢？有意思，接下来会抽空查查！
--EOF--
再次遭遇机器故障，问题:MySQL在恢复服务时如何处理连接请求的？
Related Entries
No TrackBacks
TrackBack URL: http://www.guduo.net/cgi-bin/mt/mt-tb.cgi/129
Categories
Monthly Archives
- May 2016 (1)
- August 2014 (1)
- November 2013 (1)
- February 2013 (5)
- January 2013 (1)
- December 2012 (10)
- June 2012 (2)
- February 2012 (3)
- January 2012 (2)
- December 2011 (4)
- October 2011 (4)
- September 2011 (1)
- August 2011 (1)
- July 2011 (1)
- May 2011 (1)
- April 2011 (7)
- March 2011 (6)
- February 2011 (1)
- January 2011 (3)
- December 2010 (16)
- November 2010 (4)
- October 2010 (9)
- September 2010 (4)
- August 2010 (6)
- July 2010 (5)
- June 2010 (7)
- May 2010 (8)
- April 2010 (7)
- March 2010 (12)
- February 2010 (18)
- January 2010 (21)
- December 2009 (18)
- November 2009 (4)
- September 2009 (4)
- August 2009 (4)
- July 2009 (3)
- June 2009 (2)
- May 2009 (14)
- April 2009 (14)
- March 2009 (12)
- February 2009 (4)
- January 2009 (15)
- December 2008 (13)
- November 2008 (8)
- October 2008 (3)
- September 2008 (1)
- August 2008 (3)
- July 2008 (6)
- June 2008 (20)
- May 2008 (9)
- April 2008 (24)
- March 2008 (25)
- February 2008 (26)
Pages
- hifi
快速链接
May 2016
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 |
Search
About this Entry
This page contains a single entry by 谷多 published on November 20, 2008 12:28 AM.
从Oracle复制到MySQL -- Tungsten Replicator was the previous entry in this blog.
QQMail新用法：群邮件记录工作日志 is the next entry in this blog.
Find recent content on the main index or look in the archives to find all content.
Leave a comment