Categories
MySQL

MySQL 5.5.23

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

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 : 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.

Comments are closed.