墨菲定律与 DBA

今天参加培训的时候胡思乱想,忽然间想起来墨菲定律(Murphy’s Law)这个有趣的话题. 西方文化中,有很多所谓的”定律”, 墨菲定律应该算是一则比较著名的”定律”了.什么是墨菲定律? 最简单的表达形式是”有可能出错的事情,就会出错(Anything that can go wrong will go wrong)”。
爱德华·墨菲、约翰·保罗·斯特拉普和乔治·尼克斯凭这条定律居然还得到了搞笑诺贝尔奖(IgNobel)奖。而墨菲定律的一些衍生版本也的确有趣.比如”东西久久都派不上用场,就可以丢掉;东西一丢掉,往往就必须要用它”,再比如”你出去买爆米花的时候,银幕上偏偏就出现了精采镜头”.
抛开 Murphy’s Law 衍生出来如此多的版本不谈,说一下墨菲定律和 DBA 之间的关系。Anything that can go wrong will go wrong, 这句话对 DBA 来说,应该是引起注意的, 甚至作为金科玉律也不为过,一般来说,没有哪一个人管理的数据库是完美无缺的,但是如果你发现了数据库的缺限置之不理,存在侥幸心理,那么最后往往会发生你最担心的问题。我就曾经亲生经历过几起类似的事件,事后总结的时候想 “如果我…如何做” 就好了. 但是已经发生的事情就不允许假设了.


引用一下这个定律的来龙去脉:

Murphy’s Law (“If anything can go wrong, it will”) was born here (Edwards Air Force Base) – in 1949 at North Base.
It was named after Capt. Edward A. Murphy, an engineer working on Air Force Project MX981, (a project) designed to see how much sudden deceleration a person can stand in a crash.
One day, after finding that a transducer was wired wrong, he cursed the technician responsible and said, “If there is any way to do it wrong, he’ll find it.”
The contractor’s project manager kept a list of “laws” and added this one, which he called Murphy’s Law.
Actually, what he did was take an old law that had been around for years in a more basic form (see first paragraph above) and give it a name.
Shortly afterwards, the Air Force doctor (Dr. John Paul Stapp) who rode a sled on the deceleration track to a stop, pulling 40 Gs, gave a press conference. He said that their good safety record on the project was due to a firm belief in Murphy’s Law and in the necessity to try and circumvent it.
Aerospace manufacturers picked it up and used it widely in their ads during the next few months, and soon it was being quoted in many news and magazine articles. Murphy’s Law was born.
The Northrop project manager, George E. Nichols, had a few laws of his own. Nichols’ Fourth Law says, “Avoid any action with an unacceptable outcome.”
The doctor, well-known Col. John P. Stapp, had a paradox: Stapp’s Ironical Paradox, which says, “The universal aptitude for ineptitude makes any human accomplishment an incredible miracle.”
Nichols is still around. At NASA’s Jet Propulsion Lab in Pasadena, he’s the quality control manager for the Viking project to send an unmanned spacecraft to Mars.

由上面的介绍可以看出,如果积极的看墨菲定律, 对提高系统的品质是有积极的作用的. 所以 DBA 、SA 朋友们,时刻把这个准则放在心里, 防患于未然.


  • http://www.oracledba.com.cn gytyl

    这个难道就是初生牛犊不怕虎吗
    如果我啥都不知道,
    那么就是我不知道那里会出现错误
    那么就是说,都不会出现错误,呵呵
    要是这样该多好呀

  • http://www.vingel.com Vingel

    “没有哪一个人管理的数据库是完美无缺的,但是如果你发现了数据库的缺限置之不理,存在侥幸心理,那么最后往往会发生你最担心的问题。”
    跟破窗理论有点类似。
    《程序修炼之道》说,“别容忍破窗子!”。

  • ALL开拓者

    有的时候是很不注意出错处理,看来还是要先把态度调好

  • anysql

    上面的url指向的是内部的站点的, 当然不能访问了, 建议删除.

  • http://www.dbanotes.net/ Fenng

    因为访问不到,所以我才引用出来 :)
    Google 快照可以看到的

  • http://www.oracledba.com.cn gytyl

    不是吧,引用的我能看到呀,奇怪了.

  • sopher

    是哪里看不到啊?

  • Woody Allen

    哇哈哈,大辉同学,第一次看到你的BLOG,到此一游啊

  • 恶魔在身边Y

    所谓的墨菲定律——如果坏事情有可能发生,不管这种可能性多么小,它总会发生,并引起最大可能的损失。

  • http://www.awflasher.com/blog/ aw

    老文章了,不过一搜就出来了
    我很好奇被Murphy骂的那个技师后来怎么评价这个定律的~~呵呵

  • http://www.bigorange.com.hk/index.cfm/CHINESE/__38364___26044___27225___33394___31354___38291_ mini storage

    事在人為嘛. 不過, 大環境實在變得太快. 今天的標準可以是明日黃花!

  • http://www.sina.com.cn 新新

    我在一次杂志上无疑看到墨菲法则,看看觉得以前老师讲过,现在又看到,可能觉得好奇就深入地看下去。。。,我现在觉得很有道理,人总是担心一件事情,,这件事情出现的机率就高,而且是向着事情的坏的方向发展,对抗的最好方法就是,就是别担心它,出现是正常的,不出现也是正常的,有的事情既然自己尚不能完全把握,又要去做它,假如要出现—就多做几次,并在前一次中找到避免的方法和经验。这是墨菲在我身上出现多次后的经验我,供大家参考,欢迎有朋友一起探讨QQ:416702722