Tag: MySQL

Categories
MySQL PHP

About the “mysql_connect(): Headers and client library minor version mismatch” warning

After having MySQL 5.6.17 published, some users complained about a warning thrown by their PHP applications :

PHP Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50535 Library:50617

In fact, this could happen with any application linked to libmysqlclient18 in a certain version (php5-mysql from Dotdeb is linked to the 5.5.35 version from the stock Debian distribution) when connecting to a MySQL server in another version (5.6.17 in our case). The warning is thrown by libmysqlclient18 itself. And this is just a warning, there is no reason why any bad behavior would happen in that case.

Of course, I could build php5-mysql against the latest libmysqlclient18 (5.6.17), 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 libmysqlclient18 5.5.35). For example : mod_php5 + Apache + mod_auth_mysql would crash.

If this this warning really annoys you, feel free to install php5-mysqlnd instead of php5-mysql :

  • it’s a drop-in replacement
  • it’s not linked against any libmysqlclient library
  • it won’t throw any irrelevant warning about version mismatch
  • it has a lot of benefits. See http://www.php.net/mysqlnd for more info

I hope this helps.

Categories
MySQL

MySQL 5.6.17 for Wheezy

After months of work in (slow) progress, I’m glad to announce that packages of MySQL 5.6.17 are now available for Debian 7.4 “Wheezy” on both amd64 and i386 architectures.

This is our first major release of the MySQL 5.6 branch, so be very careful when upgrading your boxes : backup your data first, keep a spare/delayed MySQL slave… And be sure to know in details what’s new in MySQL 5.6 :

  • A better Optimizer
  • InnoDB great new features : online DDL, split kernel mutex, multi-threaded purge, separate flush thread
  • New NoSQL-style memcached APIs
  • Partitioning improvements for querying and managing huge tables
  • Replication now supports multi-threaded slaves, GTID and checksums
  • More data is available through the PERFORMANCE_SCHEMA.
  • …

Of course, feedbacks are welcome, as usual.

By the way, sorry for that delay. Among other reasons, I had to deal with the Oracle/MariaDB/Percona – and now WebscaleSQL – dilemma. It’s still not concluded, since MariaDB is now well integrated in Debian Sid and that its 10.x has been declared as GA a few days ago. Stay tuned, some more announcement might be made in the next few weeks on the Dotdeb side.

Enjoy! And if you want to show your support, follow this link… 🙂

Categories
MySQL

Percona toolkit 2.2.6

Percona toolkit 2.2.6 is now available on Dotdeb for both Debian 7.0 “Wheezy” and Debian 6.0 “Squeeze”. This release has 16 bug fixes and a few new features. One bug fix is very important, so 2.2 users are strongly encouraged to upgrade.

As usual, before upgrading, please read the list of changes for Percona toolkit 2.2.6 and the announcement by Hrvoje Matijakovic.

Categories
MySQL

Percona toolkit 2.2.5

Percona toolkit 2.2.5 is now available on Dotdeb for both Debian 7.0 “Wheezy” and Debian 6.0 “Squeeze”. It fixes 5 bugs as well as 4 new features.

As usual, before upgrading, please read the list of changes for Percona toolkit 2.2.5 and the announcement by Hrvoje Matijakovic.

Categories
MySQL

Percona toolkit 2.2.4

Percona toolkit 2.2.4 is now available on Dotdeb for both Debian 7.0 “Wheezy” and Debian 6.0 “Squeeze”. It fixes 4 bugs as well as 2 new features :

  • pt-query-digest has a new option, --output json-anon, that provides the same data as --output json without query examples
  • pt-online-schema-change now outputs the current timestamp for operations that may take a while

As usual, before upgrading, please read the list of changes for Percona toolkit 2.2.4 and the announcement by Hrvoje Matijakovic.

Categories
MySQL

Percona toolkit 2.2.3

Percona toolkit 2.2.3 is now available on Dotdeb for both Debian 7.0 “Wheezy” and Debian 6.0 “Squeeze”. It fixes bugs in the previous release and includes the following changes :

  • pt-online-schema-change did not handle the failure of the DROP TRIGGER statements correctly
  • Created pt-agent
  • pt-query-digest –output json now includes more data

As usual, before upgrading, please read the list of changes for Percona toolkit 2.2.3 and the announcement by Matt Griffin.

Categories
MySQL

MySQL 5.5.31 for Squeeze

Packages of MySQL 5.5.31 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. They fix some serious vulnerabilities and InnoDB-, partition- and replication-related bugs as well.

Please note that the Pinba engine has also been rebuilt to be used against this new version.

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

Categories
MySQL

Percona toolkit 2.2.1

Percona toolkit 2.2.1 is now available on Dotdeb for Debian 6.0 “Squeeze”. It supports MySQL 5.6 and Percona XtraDB Cluster, and brings some more changes :

  • pt-online-schema-change (pt-osc) is much more resilient
  • pt-upgrade is brand-new
  • pt-query-digest is simpler
  • Version check is on by default
  • pt-query-advisor, pt-tcp-model, pt-trend, and pt-log-player are gone
  • pt-stalk and pt-mysql-summary have built-in MySQL options
  • pt-stalk --no-stalk is no longer magical
  • pt-fk-error-logger and pt-deadlock-logger are standardized

As usual, please read the list of changes for Percona toolkit 2.2.1 before upgrading.

Categories
MySQL

Percona toolkit 2.1.9

Percona toolkit 2.1.9 is now available on Dotdeb for Debian 6.0 “Squeeze”. It includes many bug fixes and it is worth upgrading to, especially if you were affected by the backwards-incompatible changes to pt-heartbeat in 2.1.8. Take a look at this blog post by Daniel Nichter for more info.

As usual, please read the list of changes for Percona toolkit 2.1.9 before upgrading.

Categories
MySQL

MySQL 5.5.30

Packages of MySQL 5.5.30 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. They fixes some InnoDB-, partition- and replication-related issues and some more bugs. And a new configuration directive, called innodb_print_all_deadlocks, has been backported from MySQL 5.6.

Please note that the Pinba engine has also been rebuilt to be used against this new version.

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