Categories
MySQL

Built from the Valley, MySQL 5.1.34 is available

Blogging and building live from MySQL Conf 09… If you want more details about what happens here (technical sessions, MySQL 5.4, InnoDB improvements, MySQL Cluster, Sun/Oracle fusion…) or want to enjoy a drink in the Valley, please let me know…

MySQL Conf 09
credits : Duncan Davidson

Back to the Dotdeb business : MySQL 5.1.34 has been published with its lot of bugfixes. It is now built and available on Dotdeb for your Lenny/Etch amd64/i386 Debian servers. No change in the packaging, just apt-get upgrade

Categories
MySQL

MySQL 5.1 updated

Quick post : MySQL AB has just released MySQL 5.1.33… This maintenance release fixes several bugs… The packages are now available for Lenny and Etch, amd64 and i386…They re-introduces the readline support in the MySQL client… Enjoy.

Categories
MySQL

MySQL 5.1.32 is now available

MySQL AB has just released MySQL 5.1.32. This maintenance release fixes several bugs and one security issue. Upgrading is recommended, especially for those using replication.

Last but not least, it is now packaged for Lenny and Etch, amd64 and i386! Feel free to upgrade your servers…

Categories
Miscellaneous

Dotdeb : Debian 5.0 “Lenny” support in progress…

Debian GNU/Linux 5.0 “Lenny” has been published on last Valentine’s day. Although most of the Dotdeb packages for the previous release, “Etch”, are compatible with Lenny, it is now time for Dotdeb to have dedicated packages for this new distribution.

Lenny banner

I’m actually kind of busy at work, but I managed to build and upload the most important packages : PHP5, PHP5 PECL extensions and MySQL 5.1. Additional pieces of software (Google Perftools, for example) will appear in the next few days. Please be patient and don’t hesit to make suggestions.

What (about LAMP) has changed in Lenny?

  • Apache 1.3 has been removed, in favour of Apache 2.2. You have to migrate before any other change.
  • In addition, libapache-mod-php5 is still present, but it’s a non-sense and a cause of mistake : it depends on the missing apache-common package! You have been warned.
  • MySQL 5.0 comes in a satisfying recent release (5.0.51a) and will take profit of official Debian security releases.

What will change in the Lenny branch of Dotdeb?

  • PHP5 (5.2, 5.3, …) has now the focus and will be updated frequently, so PHP4 is not maintained anymore. PHP6 will be uploaded when it’s ready.
  • Up-to-date MySQL 5.1 packages will be provided as often as needed
  • MySQL 5.0 effort has been discontinued in favour the official Debian packages.
  • I’m wondering if I will keep maintaining the mail-related packages (Qmail, Vpopmail, Ezmlm, Qmailadmin…). If you really need them, let me know in the comments.

Should I switch to Lenny or should I stick to Etch?

It’s up to you. I will continue maintaining up-to-date packages for Etch in the next few months, so you’ll have time to upgrade your servers. Whatever you choose, you just have to take care of the Dotdeb entries in your sources.list :

  • It should refer to stable or lenny if you want to make the switch and take benefits from the brand new Debian distribution :
deb http://your.mirror/ stable all
deb-src http://your.mirror/ stable all
  • It should refer to oldstable or etch if you want to stick to the good old Etch and to take your time to upgrade.
deb http://your.mirror/ oldstable all
deb-src http://your.mirror/ oldstable all

(Please chose a mirror near your location on this page)

Conclusion

Thanks for using Dotdeb! This personnal project still aims (and will continue) to provide an efficient and up-to-date LAMP stack to your servers.

Categories
MySQL

MySQL 5.0.77 available

MySQL 5.0.77 packages are now available on Dotdeb for Debian Etch amd64/i386.

This is a maintenance release that fix some annoying bugs and a severe security issue.

Please read the official list of changes in 5.0.77  before upgrading.

Categories
MySQL

MySQL 5.1.31 available

MySQL 5.1.31 is now available on Dotdeb for Etch amd64/i386. It fixes several problems and brings many enhancement to the previous release.

Please read the official Changelog before upgrading.

Categories
MySQL

MySQL 5.0.75 available

MySQL AB has just made MySQL 5.0.75 available. Even it is just a maintenance release – since the 5.1 branch is now golden – it is now packaged and uploaded to Dotdeb for Etch amd64/i386.

Anyway, if you did not make the jump and still use MySQL 5.0, please upgrade your server, to fix some annoying bugs, fill up some security holes and enhance the overall security of your favorite SGDB. And don’t forget to take a look at the release notes of MySQL 5.0.75.

Categories
MySQL

MySQL 5.1.30 GA available on Dotdeb

MySQL, the most popular open source database, releases on November 27, 2008, its version 5.1 GA (General Availability). It is now available on Dotdeb for Etch (amd64/i386)!

Version 5.1 introduces several enhancements to the already rich set of features. Most notable are partitioningrow based replication, the event scheduler, a new plugin infrastructure, and logs on demand.

There are more new features, but the general improvement is better performance and manageability. Many users have already adopted MySQL 5.1 in production. Their feedback has been reported in the MySQL technical articles. Check them out. MySQL 5.1 is ready for prime time!

Categories
Documentation MySQL

Using the Google Perftools to speed up your MySQL server

The Google Perftools, especially tcmalloc (Thread Caching Malloc), can be very useful to speed up your applications, depending on your environment :

TCMalloc is faster than the glibc 2.3 malloc (available as a separate library called ptmalloc2) and other mallocs that I have tested. ptmalloc2 takes approximately 300 nanoseconds to execute a malloc/free pair on a 2.8 GHz P4 (for small objects). The TCMalloc implementation takes approximately 50 nanoseconds for the same operation pair.

Its deployment in your LAMP stack can speed up your MySQL servers, since it enhances memory allocation on threaded applications with the downside of larger memory footprints.

Here is how to use it easily…

Installation

First of all, be sure you use Debian 5.0 (a.k.a. “Lenny”) or later. Then install the minimal tcmalloc library from Dotdeb :

apt-get install libtcmalloc-minimal0

Then, since the mainstream MySQL packages are not compiled against tcmalloc, you’ll have to trick your OS’ dynamic linker by adding the following line at the top of your /etc/init.d/mysql init script :

export LD_PRELOAD="/usr/lib/libtcmalloc_minimal.so.0"

/etc/init.d/mysql modification

After relauching your MySQL server using the modified init script, you’ll take profit from tcmalloc’s faster memory allocation.

Results

At the time of writing this article, I didn’t make benchmarks, but some reported that they had a ~15-20% performance gain. Please leave comments about your experience.

Categories
MySQL

MySQL 5.0.67 available

Norbert Tretkowski recently worked on packaging MySQL 5.0.67, the latest Community Edition release of MySQL Server. But, since the next Debian version – Lenny – is already frozen, the packages were not uploaded to the official archive.

Instead of that, I rebuilt them and made them available on Dotdeb for Etch amd64/i386.

Please take a look at the official Changelog before upgrading and thank Norbert for his good work.