上周日，一台服务器无故停止服务，不能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
1 Comment
Leave a comment
Categories
Monthly Archives
- 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
快速链接
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.
基本原因：
非正常关闭退出重启后，mysql会进行一些数据修复，批量处理bin log，可能还要处理相关复制检查？