The packages of MySQL 5.5.28 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. They fixes some InnoDB-, partition- and replication-related issues.
The Pinba engine has also been rebuilt to be used with the new version.
As usual, please read carefully the full Changelog before upgrading.
21 replies on “MySQL 5.5.28”
The ssl replication problems in MySQL 5.5.18 are fixed in this release. Instead of only use the key param you should now also use MASTER_SSL_CA and MASTER_SSL_CERT
thanks mysql 5.5.28
Hi. Firstly, Thanks for releasing MySQL 5.5.28 but, I am getting this when I try to start my MySQL server:
* Starting MySQL database server mysqld [ OK ]
* Checking for tables which need an upgrade, are corrupt or were
not closed cleanly.
and after searching a lot on google, I found that my error is:
Unknown table engine ‘PERFORMANCE_SCHEMA’
Can you help me?
@Doug : these messages on MySQL startup are the normal behavior. It starts, then checks if all the tables are ok. No big deal.
Hi, thanks for this release, but I have a little problem with php5-mysql.
This package depends only on libmysqlclient16 (5.1.21). Impossible to use libmysqlclient18 (5.5.28).
How to use the right mysql lib ?
@Renaud : Dotdeb is built for Debian stable. Debian stable contains libmysqlclient16.
If you use Dotdeb with another distribution (at your own risk), install php5-mysqlnd instead of php5-mysql : The MySQL native driver doesn’t depend on any libmysqlclient package.
I use a stable Debian 6 Squeeze and dotdeb repository
Dotdeb provide Mysqm Server 5.5.28 and its lib libmysqlclient18 (5.5.28).
Unfortunatly, php5-mysql (provided by dotdeb-squeeze and dotdeb-squeeze-php54) depends only on libmysqlclient16 (5.1.21)
libmysqlclient16 is provided by official squeeze repo but libmysqlclient18 is provided by dotdeb repository.
So i would like to use dotdeb mysql and php5 packages including libmysqlclient18.
Why this is not possible ?
@Renaud : only php5-mysql from PHP 5.4 depend on libmysqlclient16 (>= 5.1.21-1). This last package is present in Debian stable in version 5.1.63 that will satisfy the dependency :
http://packages.debian.org/libmysqlclient16
On the other side, php5-mysql depends on libmysqlclient16 only because it has been built against this version of libmysqlclient16 (MySQL 5.1 in fact). Of course, I could build php5-mysql from PHP 5.4 against my libmysqlclient18 (MySQL 5.5), but it would lead to very bad issues, such as duplicate symbols or segfaults when PHP is loaded with other MySQL-linked modules from the stock Debian distribution (those are linked to libmysqlclient16). For example : mod_php5 + Apache + mod_auth_mysql would crash.
If this libmysqlclient16 dependency really annoys you, feel free to use install php5-mysqlnd, that is not linked against any libmysqlclient library and that has a lot of benefits :
http://www.php.net/mysqlnd
Thanks for the quick responses.
Unfortunatly, phpmyadmin depends on php5-mysql :-/
Sorry I broke the replies :-/
Thanks for the quick responses.
Unfortunatly, phpmyadmin depends on php5-mysql and there is a conflict between php5-mysql and php5-mysqlnd
I upgraded to the latest mysql 5.5.28 but mysql and mysqld show me different versions
mysql 5.5.28
mysqld 5.5.24
Sorry for the offtopic but, dou you have a NDB build? Or do you know of any Debian repo with up-to-date Mysql Cluster NDB engine? Thanks!
@Vide : Dotdeb’s build does not contain NDB. Maybe the .deb package from dev.mysql.com has this feature.
Hey Guillaume,
do you have any plans releasing 5.6.8 RC ?
I think many people are excited about innoDB FTS – as I am.
@Finn Dorby : I won’t package RC of MySQL, you’ll have to wait until 5.6 is GA.
BTW, InnoDB FTS might not be such a great feature. You can take a look at Sphinxsearch, it rocks.
@Guillaume: thank you for pointing me to sphinx, which i stumbled upon before, but never had a project where i could actually use it. Now i decided to use sphinx and mongoDB for my search index. And thanks for dotdeb. You do great work.
Hi Guillaume, do you plan on providing the debug symbols for mysql-server-5.5 ? I don’t see it listed on the mirror sites. Merci!
Hello Michael,
because I want to follow Debian’s packaging scheme for full compatibility, that’s probably a feature you’ll want to submit to http://bugs.debian.org/ . If there’s no move from them, I’ll try to package an extra libmysqlclient18-dbg. Please keep me informed, ok?
Renaud,
did you solve the issue, and how?
[…] Analysis and solutions. This is not a real problem, just a cosmetic one. The client library version is lower and will be compatible for calling a higher server version. Only the other way round it would break things. At least this is the idea why the author has packaged it with this dependency [source]. […]