MySQL Performance Blog

We’ve been busy expanding our training curriculum to include training for developers building applications with MySQL.  We have reached the point where we’re ready for a pilot teach – and it brings me great pleasure to announce that we’re opening it up for blog readers to attend, free of charge.

The details:
San Francisco
4th December
9:30AM – 5PM

Spaces are limited, so to give everyone a fair chance we’re delaying registration to open at noon tomorrow (Friday) Pacific Time. It’s strictly first in first served, so be quick!  The registration link is here.

Dear Community,

As of today release 0.9.5rc is available.

In this release there are following changes:
Changelog:

• Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your
  tables are InnoDB and you DO NOT CARE about binary log
  position of backup
• XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported. We thank a well known Social Network site for the sponsorship.
  
• Windows conscious change more
• Impoved error messages in innobackupex
• Windows conscious experimental change
• Suppress purge when –stats
• Build number in RPM name. For instance, in the name xtrabackup-0.9.5rc-50.rhel5.x86_64.rpm 50 is the build number.
• Suppress master_thread ibuf operations for –stats
• Suppress ibuf operations for –stats
• fFx fatal bug at –backup when added –stats
• New option –stats to gather index stats
• Fixed some bugs for a 32bit platform

Fixed bugs:

• Bug #435634 in Percona-XtraBackup: “xtrabackup can’t write to a file on windows”
• Bug #437788 in Percona-XtraBackup: “xtrabackup.exe can’t write to a file”
• Bug #386535 in Percona-XtraBackup: “ibbackup_binlog_marker bug still persists”
• Bug #402884 in Percona-XtraBackup: “tries to create temporary tables in relative ./tmp directory”
• Bug #417178 in Percona-XtraBackup: “can’t backup tables with $ in name”

The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/.

The Debian package is also available via APT. Just add these lines  in /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Update the local database

# apt-get update

And install xtrabackup

# apt-get install xtrabackup

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

It’s time to announce our plans for Percona Performance Conference 2010. We will hold the event on April 12th and 13th in Santa Clara, California. In the months to come we will announce the theme, the exact location (we have it reserved, but it’s subject to change), the exact dates (we may add days), and we’ll open up registration and a Call For Proposals. Stay tuned!

After many complains we removed captcha in comments and replaced to Anti-Captcha ( http://wordpress.org/extend/plugins/anti-captcha/). Now you need enabled JavaScript in your browser to post comments.

On the heels of our earlier announcement of Fernando and Yves, I’m happy to welcome Devananda van der Veen to our team.

Devananda, also known as Deva, is a talented, detail-oriented MySQL expert and systems administrator. His previous job was at Hydra, an advertising network, where he was sole DBA and half of the systems and network engineering team. Deva likes to automate: he wrote the mycat MySQL administration tools, and he knows how to administer lots of servers simultaneously. He is active in open-source software development, and very excited about Drizzle.

Deva lives with his wife and dogs on Washington’s beautiful Olympic Peninsula, far from noise, pollution, and crowds.

Welcome, Deva!

Dear Community,

We are glad to present you release 8 of XtraDB.

The release includes following new features:

• The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4
• MySQL 5.1.39 as a base release

Fixed bugs:

• Bugs#413858: Crash from failed assertion in dict0dict.c
• Bug#417751:
  XtraDB crashes on startup on windows
• fix-import-extern-pages
• Number of mysql-tests are fixed

The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.39-8/
The latest source code of XtraDB, including development branch you can find on LaunchPAD.

We are launching also the repository with Debian packages.
To install XtraDB with APT put in your /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Then run

# apt-get update
# apt-get install mysql-server-5.1

Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

Dear Community,

As of today the 19-th build of MySQL server with Percona patches is available.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.86
• Fix from Neil Katin to userstatv2.patch
• fix InnoDB slowness with large queries

Fixed bugs in the build:

• Bug #413858 in Percona patches: “Crash from failed assertion in dict0dict.c”

You can download binaries and sources with the patches here

http://www.percona.com/mysql/5.0.86-b19/
There is Debian packages repository available since Build 19.
To install MySQL with Percona patches with APT put in your /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Then run

# apt-get update
# apt-get install mysql-server-5.0

The Percona patches live on Launchpad : https://launchpad.net/percona-patches and you can report bug to Launchpad bug system:

https://launchpad.net/percona-patches/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Videos from the 2009 Percona Performance Conference are now available on www.percona.tv. Let us know which you like best so we can have some ideas for the 2010 conference!

I’m happy to extend a warm welcome to two new members of the Percona team.

First is Yves Trudeau, about whom I can say many things:

• One of the top MySQL Cluster (NDB Cluster) experts in the world.
• An expert on all things High Availability, including DRBD and Heartbeat.
• Many years of experience with Huge Data.
• Half of the Waffle Grid team.
• A really nice person!

Yves joins us after a tenure of several years as a senior consultant at Sun/MySQL. Together with Matt Yonkovit, he plans to work on WaffleGrid (but as a new project under a new name, to be determined), and integration with XtraDB. Yves lives in Quebec with his family.

Next is Fernando Ipar. Fernando is our first dedicated Shift Support Captain^[1]. Fernando specializes in MySQL, GNU/Linux, systems administration, and high availability. Fernando has been involved in computer programming since he was 11, and in Open Source since 2001. He loves shade-grown coffee, music, and natural history. He lives in Uruguay with his wife and family. Fernando brightens our IRC channel with his helpful and cheerful presence!

Welcome, Yves and Fernando!

[1] Shift Support Captain is kind of a dispatcher for 24-hour service. We have been doing 24×7 service through an on-call phone number for years, but a few months ago we started literally manning the desk 24×7 — something that we have grown large enough to both need and justify, at our current size of around 30 people. Our customers can now use email, Skype, AOL messenger, or Google Chat (as well as the phone number) to get immediate attention, 24×7, from a technically savvy person.

Our Santa Clara/San Francisco training went great – 100% of survey respondents said they would recommend the same course to a friend.  I’m pleased to announce that such an opportunity exists – our next training location will be New York City on October 30, 2009.

We’ve booked a training venue in the financial district of Manhattan (90 Broad Street New York, NY 10004), and it seems like a great opportunity to switch from using hotels to teaching in real classrooms.  This means that every student will have a (Linux) computer provided, and the instructor will have a whiteboard to be able to scribble.

Some other changes:

• The start time will now be 9:30 AM. Thanks to those who gave feedback – this seemed to be one of the biggest concerns. The finish time will be around 5 PM.
• With the class size going down, we have a little freedom to tweak our format.  One of those changes is that we plan to increase time for exercises in class just a little bit more.

Tickets are $450/student, and we’re continuing our early bird special (a copy of High Performance MySQL 2nd Ed).  Interested in signing up?  Registration is open!