MySQL 5.5.23

April 13, 2012 · Guillaume Plessis

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.

Dave April 14, 2012
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
anon April 20, 2012
hi guys.
there is a bug on your MySQL build-5.5.23
details are here:
http://bugs.mysql.com/bug.php?id=64988
Guillaume Plessis April 20, 2012
@anon : thanks for this report, I’ll take a look at it. Stay tuned.
Jan April 26, 2012
Very big thanks for your perfect work! I like dotdeb! :-)
THANKS!
Vladimir Laskov May 3, 2012
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)
Laph May 7, 2012
Hi Guillaume,
according to this: http://dev.mysql.com/doc/refman/5.5/en/mysqld-safe.html#option_mysqld_safe_malloc-lib MySQL 5.5+ allows to set a malloc lib via .cnf.
But the “shipped tcmalloc library” seems to be missing in the dotdeb binaries.
Guillaume Plessis May 7, 2012
@Laph : thanks for this link, I’ll take a look at it for the next MySQL releases. As a temporary workaround, you can use the workaround that is described in this 4yo article : /2008/08/25/using-the-google-perftools-to-speed-up-your-mysql-server/
Guillaume Plessis May 7, 2012
@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)
Laph May 8, 2012
@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.
- Guillaume Plessis May 8, 2012
  @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.

mysql