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.
Categories
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 replies on “MySQL 5.5.23”
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
hi guys.
there is a bug on your MySQL build-5.5.23
details are here:
http://bugs.mysql.com/bug.php?id=64988
@anon : thanks for this report, I’ll take a look at it. Stay tuned.
Very big thanks for your perfect work!
I like dotdeb! 🙂
THANKS!
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)
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.
@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 : http://localhost:8080/2008/08/25/using-the-google-perftools-to-speed-up-your-mysql-server/
@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)
@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.
@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.