Ideas, releases, practical guides, and perspectives from the people building with MySQL.
In our last 5.5 series release of Percona Server, we included a regression in the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic upgrading was configured on machines with running database servers.
We’ve now fixed it and re-released to …
[Read more]Percona Server for MySQL version 5.1.68-14.6
Percona is glad to announce the release of Percona Server 5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is now the current stable release in the 5.1 series. All …
[Read more]
Today’s blog post diving into the waters of the MySQL buffer
pool is a cross-post from Groupon’s engineering blog, and is Part 1 of
2. Thank you to Kyle Oppenheim at Groupon for contributing to
this project and post. We’ll be posting Part 2 on Thursday. I’ll
be at the Percona Live MySQL Conference and Expo next
week in Santa Clara, California so look for me there – I’d love
to connect and talk more about MySQL buffer pools or anything
else that’s on your mind!
There …
[Read more]The Percona Live MySQL Conference and Expo begins next Monday and runs April 22-25, 2013. Attendees will see great keynotes from leaders in the industry including representatives from Oracle, Amazon Web Services, HP, Continuent, and Percona. They can also participate in thought provoking Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and entertaining with the presentation of the Community Awards and the Lightning Talks.
If you cannot attend the entire Percona Live MySQL Conference but want to take advantage of the keynotes, BOFs, and Community Networking …
[Read more]
In addition to the problem with trx_list scan we discussed in
Friday’s post, there is another issue in
InnoDB transaction processing that notably affects MySQL
performance – for every transaction InnoDB creates a read view and allocates memory for this
structure from heap. The problem is that the heap for that
allocation is destroyed on each commit and thus the read view
memory is reallocated on the next transaction.
There are two aspects of this problem:
1) memory allocation is an costly operation and if memory …
[Read more]
We just released our first alpha of Percona XtraBackup 2.1 for
MySQL and with it we included the ability to encrypt backups
on the fly (full documentation here). This feature is
different than simply piping the backup stream through the
openssl or gpg binaries, which is what some people have used in
the past. A big benefit of using the built-in encryption is
that multiple CPU cores can be used for encryption (with
the --encrypt-threads option). You can
also combine compression and encryption, each using multiple CPU
cores.
One advantage of …
[Read more]Facebook is a major user of MySQL and has pushed the performance limits of the technology. Their MySQL experts have deep, hands on knowledge of the technology. I’m pleased to welcome Mark Callaghan, Software Engineer for Database Infrastructure at Facebook, back again this year to the Percona Live MySQL Conference & Expo to share his expertise. Mark was a keynote speaker at last year’s conference and will appear this year with a group of Facebook MySQL experts:
[Read more]Percona Server for MySQL version 5.1.68-14.5
Percona is glad to announce the release of Percona Server for MySQL 5.1.68 -14.5 on March 15, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68 -14.5 is now the current stable release in the 5.1 series. All of Percona‘s software is open source and free, all the details of the release can be found …
[Read more]I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Percona Live MySQL Conference and Expo. The conference takes place April 22-25, 2013 at the Santa Clara Convention Center and Hyatt Santa Clara.
Tomas Ulin, VP, MySQL Engineering for Oracle, will present an invited keynote talk on “Driving MySQL Innovation” during the Tuesday morning opening keynotes. With the recent release of MySQL 5.6, conference attendees will hear about the latest developments of this major MySQL release.
In addition to Tomas, Oracle MySQL technologists will also lead three breakout …
[Read more]Percona Server for MySQL version 5.1.67-14.4
Percona is glad to announce the release of Percona Server for MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.4 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be …
[Read more]
