Posted by & filed under MySQL.

The packages of MySQL 5.5.23 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures with no major change except bug fixes.

As usual, please read carefully the fullĀ Changelog before upgrading.

10 Responses to “MySQL 5.5.23”

  1. Dave

    Thank you so much for you work. Upgrades are just fine. I’m very satisfied with dotdeb! Keep it up!

    // Using PHP a MySQL on Ubuntu

    Reply
  2. Vladimir Laskov

    mysql -e “FLUSH LOGS;”
    ERROR 1105 (HY000) at line 1: Unknown error

    fixed after:

    1. remove package mysql-server-5.5 5.5.23-1~dotdeb.0
    2. install mysql-server-5.5_5.5.20-1_amd64.deb from experimental repo
    3. DEBIAN_FRONTEND=noninteractive apt-get -y –force-yes install mysql-server-5.5

    stage 3 – installing mysql-server-5.5 5.5.23-1~dotdeb.0

    and done

    # mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 47
    Server version: 5.5.23-1~dotdeb.0-log (Debian)

    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

    mysql> FLUSH LOGS;
    Query OK, 0 rows affected (0.01 sec)

    Reply
  3. Guillaume Plessis

    @Laph : After reading your link, the fact is that tcmalloc is distributed as a separate package (libtcmalloc-minimal0). Install it and set malloc-lib=tcmalloc in your my.cnf (you had to redefine LD_PRELOAD manually in MySQL prior to 5.5)

    Reply
  4. Laph

    @Guillaume:
    I know there’s a separate package “libtcmalloc-minimal0″ in the Debian Repo’s. And if you install this package, adding “malloc-lib=/usr/lib/libtcmalloc_minimal.so.0″ to “[mysqld_safe]” enables it.
    But the MySQL docs also say “[...]but there is a shortcut form to enable use of the tcmalloc library that is shipped with binary MySQL distributions for Linux in MySQL 5.5.”

    This “Shortcut” is “malloc-lib=tcmalloc” and as I understand it, this Shortcut uses a bundled library: “Linux users can use the libtcmalloc_minimal.so included in binary packages by [...]“.
    And this fails with the dotdeb Packages (MySQLd fails to start).

    Nevertheless, the first approach works as well as the LD_PRELOAD approach, described in your article.

    Reply
    • Guillaume Plessis

      @Laph : I think that they mention the tcmalloc library included in the binary MySQL distribution from mysql.com. I’ll take a look at why the “shortcut” fails.

      Reply

Leave a Reply

  • (will not be published)


5 − = two