«
»

mysql/5.0.45 …

August 12, 2009 2:09 pm GMT-0700 | In Tech

I recently did some performance testing with a few big tables on mysql/5.0.45 under CentOS and noticed a sharp drop in query speed a few minutes after restarting mysql. More tests showed mysql/5.0.51a or newer don’t have this problem. OK, I guess a picture is worth a thousand words… (SELECT queries only, and also mysql buffer size is huge, so disk I/O is minimal during test.)
mysql_performance
It’s most likely due to mysql bug 21074 (fixed in mysql/5.0.50). Unfortunately mysql/5.0.45 is the version that ships with CentOS 5.3 and some other Redhat-derived Linux distro. Consider upgrading if you are using mysql/5.0.45 and your mysql server appears to be heavily CPU-bound.

Tags: , ,

6 Comments »

RSS feed for comments on this post.

  1. 我还在学呢。

    Comment by 亦歌 — August 13, 2009 2:33 am GMT-0700 #

  2. 这种测试都是用什么测试工具搞的呢?测试结果用什么画的呢?

    Comment by 有颜色的猫 — August 14, 2009 4:30 am GMT-0700 #

  3. 测试就几行 Python …… 画图是 matplotlib

    Comment by atppp — August 14, 2009 10:14 am GMT-0700 #

  4. 我囧，我被这玩意坑惨了……

    Comment by fancy — August 14, 2009 10:59 pm GMT-0700 #

  5. 你好！请问一下，是否能够将kbs的数据转换到discuz或者其他的论坛程序？

    Comment by aiyi — August 19, 2009 10:52 pm GMT-0700 #

  6. “测试就几行 Python …… 画图是 matplotlib”

    发个测试的脚本，我也测测手头的服务器看看，3x:)

    Comment by mysql_study — August 20, 2009 8:32 pm GMT-0700 #

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This weblog is licensed under a Creative Commons License.
Powered by WordPress. Theme based on Pool by Borja Fernandez.