MySQL 5.1 Stability

MySQL 5.1 Stability


I have been helping customer today to resolve his lockups in production by downgrading from MySQL 5.1.25 to 5.0 We have other customers (and our own projects as well) which run on MySQL 5.1 successfully but I can’t it is on par with MySQL 5.0 stability yet.

This given customer was running MyISAM on FreeBSD with quite basic queries, so may be there are some issues with FreeBSD and MySQL 5.1 still ?


Share this post

Comments (12)

  • Arjen Lentz Reply

    Anything specific?

    June 30, 2008 at 4:42 pm
  • Antony Curtis Reply

    Depends upon which version of FreeBSD…
    FreeBSD < 7 has problems handling mutex contentions. MySQL 5.1 does hit mutexes harder than 5.0.
    AFAIK, these issues has been addressed on FreeBSD 7 but I haven’t examined or tried it yet.

    June 30, 2008 at 4:47 pm
  • peter Reply

    This was FreeBSD 6.3 I think

    I could blame it on FreeBSD but I seen similar situation – queries locking in various states like “end” “freeing items” “Locked” etc on other systems.

    June 30, 2008 at 8:09 pm
  • Mark Callaghan Reply

    Too bad the MySQL server doesn’t provide the equivalent of SHOW INNODB STATUS so you can get more details on lock holders and waiters.

    June 30, 2008 at 9:40 pm
  • gslin Reply

    MyISAM with FreeBSD has been reported have scalability problem to mutex locking, both 6.3 and 7.0.

    June 30, 2008 at 9:46 pm
  • Andreas Müller Reply

    I have also performance problems with 5.1.25
    After some hours I found this optimizer/index problem:

    July 1, 2008 at 4:32 am
  • peter Reply


    Indeed it would be great to get some platform independent diagnostic tool to see where things are stuck.

    July 1, 2008 at 2:03 pm
  • peter Reply


    Thanks for report, though MySQL 5.0 and 4.1 work OK for the same workload.

    July 1, 2008 at 2:03 pm
  • peter Reply


    Indeed 5.1.25 in particular adds this “famous” optimizer regression.

    I would be very careful with optimizer changes in RC stage – unlike normal “bugs” optimizer changes often make things better in some cases but worse in others and it is hard to predict the impact without wide user testing.

    July 1, 2008 at 2:06 pm
  • Sander Reply

    I had severe problems with MySQL 5.1 and FreeBSD back in February / March. This was on FreeBSD7 (Release), using InnoDB tables and a few MyISAM tables. And by severe I mean crashes and lockups every few minutes (!).

    After the downgrade to 5.0, everything was running smooth again.

    July 2, 2008 at 4:18 am
  • Andreas Müller Reply

    The problem seems to be verified and I hope it would be fixed soon. The leading bug report is

    It seems that there are 3 reports at the moment regarding to the same problem.

    July 2, 2008 at 4:46 am
  • Florent Steiner Reply

    I have the very same problem on CentOS 5.6 x84_64 on a server with MyISAM tables.

    So I guess it’s not because of FreeBSD.

    Switching back to 5.0 tonight …

    October 22, 2008 at 4:51 am

Leave a Reply