Percona builds with Percona patchsets

Percona builds with Percona patchsets

PREVIOUS POST
NEXT POST

Percona has a strong team of MySQL developers and consultants on board, so we decided to prepare builds with our patches and third-party patches which we think are very useful. We actually use these internally and for our customers.

Current releases include:

  • microslow patch (enables microsecond resolution in slow logs)
  • execution plan (show info about query execution in slow log)
  • InnoDB statistic (show extended InnoDB usage during query execution in slow log)
  • Google’s patches with user statistics, and statistics about tables and indexes usage

You can find more info about some of our patches here:
https://www.percona.com/blog/2008/04/20/updated-msl-microslow-patch-installation-walk-through/
Some features were sponsored by customers and we are allowed to publish them under GPL and some we developed for internal needs.

We prepared 5.0.62 release (based on MySQL Enterprise 5.0.62 source, taken from http://mirror.provenscaling.com/mysql/enterprise/source/5.0/) and 5.1.26-rc release, and they are currently available only as source .tar.gz, but we will provide public access to our YUM repository with binaries, RedHat/CentOS and Suse RPMS / SRPMS when they’re available. Here are links to the source releases:

mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff
mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82

You can find the individual patches here:
https://www.percona.com/blog/mysql-patches/

Besides standard 5.1, we are going to make releases with the InnoDB plugin version compiled in (not as a plugin), as the current system with independent InnoDB binaries does not seem handy for us.

We have couple of ideas what else we can develop and include in our releases, but also your comments are very welcome.

We are still investigating Launchpad features, there is our -percona branch, but it is outdated at this moment. Probably our next releases will be based on Launchpad branches, we still need to decide how it fits into our development model.

Disclaimer: Although we use tested releases as best as we can, and use them internally, we do not claim they are bug-free, and you should use them only if you know what you are doing.

PREVIOUS POST
NEXT POST

Share this post

Comments (35)

  • Riaan Reply

    Hi Another vote for windows Pleaaaasseee !!!

    July 16, 2008 at 12:00 am
  • Mark Atwood Reply

    Have you considered putting your tree up on Launchpad?

    July 16, 2008 at 10:09 pm
  • John Laur Reply

    Thanks for this! It’s a nice to have access to a patchset that someone can vet far more thoroughly than I can.

    Do you ever build deb/deb-src packages?

    July 16, 2008 at 10:28 pm
  • Vadim Reply

    Mark,

    As I mentioned, we are looking into Launchpad, but our developers use mercurial queues to manage patches, so we think how we can use Launchpad.

    July 16, 2008 at 10:41 pm
  • Vadim Reply

    John,

    We do not have debian servers, and debian also is rarely used by our customers, so we have no plans to build deb right now, but may reconsider that if there will be many requests for.

    July 16, 2008 at 10:44 pm
  • Ronald Bradford Reply

    Good stuff, I’ll certainly be looking at your builds, I’ll wait for the binaries. CentOS 5 64 bit for me.

    July 16, 2008 at 11:31 pm
  • Marki Reply

    Hi,
    I would also vote for Debian packages 🙂 I have created/modified some small packages myself, but mysql is too complex for me to do it.

    July 17, 2008 at 1:08 am
  • Roland Bouman Reply

    “We have couple of ideas what else we can develop and include in our releases, but also your comments are very welcome.”

    PBXT, Sphinx ?

    July 17, 2008 at 1:09 am
  • pabloj Reply

    Any plans for a windows binary?

    July 17, 2008 at 1:45 am
  • R. Iqbal Reply

    Another vote for Debian packages 🙂

    July 17, 2008 at 2:42 am
  • Gregory Haase Reply

    This is excellent news.

    I’ll put in another vote for 64-bit RHEL/CentOS 5.

    I understand that you can’t have every hardware platform and ever Distro/OS for testing available. For Debian, et all, maybe you can find someone willing to make the packages based on your source and ship them back in.

    July 17, 2008 at 5:50 am
  • Vadim Reply

    We do not plan Windows binaries at all unless we have serious requests for.

    As for Debian probably we can cooperate with contributors. Our patches also will be available via hg queue so it will not be hard to extract them and prepare deb-src.

    July 17, 2008 at 11:51 am
  • Jeremy Zawodny Reply

    Excellent.

    July 17, 2008 at 8:35 pm
  • Pablo Pernot Reply

    Very interesting.

    another vote for debian btw…

    July 18, 2008 at 12:15 am
  • Chris Reply

    Nice!

    .. and another Debian vote 😉

    July 18, 2008 at 6:43 am
  • Mark Callaghan Reply

    This is excellent news and great for users who want performance critical features but don’t want to patch and build MySQL. SHOW USER_STATISTICS is my favorite patch so far, does this include it?

    July 18, 2008 at 8:22 am
  • Vadim Reply

    Mark,

    Yes, it contains
    SHOW USER_STATISTICS / INDEX_STATISTICS / TABLE_STATISTICS.

    We are going to make this info available via INFORMATION_SCHEMA.

    July 18, 2008 at 9:23 am
  • Ernesto Vargas Reply

    I am recompiling for CentOS 5.2, using centos.org specs files from mysql-5.0.45-7.el5.src. If everything goes well I will do it for 64-bit currently on 32-bit.

    July 18, 2008 at 5:47 pm
  • Michael Myles Reply

    I am SERIOUSLY requesting Windows binaries 🙂 You guys are great!

    July 21, 2008 at 7:05 am
  • Cyril Scetbon Reply

    If guys want debian packages 5.1.26-rc with theses patches I can provide them.
    Simple question : Is there any documentation about innodb_stat patch ? How do we use it ?

    July 23, 2008 at 3:10 am
  • Gogo Reply

    Thanks Cyril. Can’t wait to see the debian package 😉

    July 23, 2008 at 7:09 am
  • Gogo Reply

    @Michael -> I don’t think they’re going to make windows binaries for free. If you do need windows binaries, call them and buy their commercial consulting service.

    July 23, 2008 at 7:10 am
  • Gogo Reply

    And yes, I vote for another Debian package 🙂

    July 23, 2008 at 7:11 am
  • Ricardo Cescon Reply

    Debian package vote 😉

    July 29, 2008 at 2:43 am
  • Christoph Reply

    Thx a million for this patched version. It makes it a lot easier to find the mysql turbo switch for your custom application.

    July 30, 2008 at 1:25 am
  • Kevin Burton Reply

    Sweet…..

    Consider this a debian vote.

    August 1, 2008 at 8:34 pm
  • Joe Reply

    Vote for debian package.

    September 22, 2008 at 11:20 am
  • Alex Reply

    Another bump for Debian please 😉 In contrast to you folks, we exclusively run Debian and about 90% of customers do too!

    September 24, 2008 at 4:40 pm
  • Alexander Mikhailian Reply

    As a developer and a Debian and/or Ubuntu user, I am primarily interested in Percona patches because of the easier database optimization (microslow, anyone?).

    I am too lazy to build mysql with the Percona patchset, for the little value it provides for me, but I would gratefully install it if it was readily available.

    Debian users like me are probably a fraction of your customers, but they are the likely those who advise your customers on the choice of technology and suppliers. It’s an important market, guys.

    February 3, 2009 at 8:30 am
  • Vadim Reply

    Alexander,

    We hear you, thank you for feedback. We are working on our build farm and we will build Debian binaries.

    February 3, 2009 at 9:03 am
  • Rob Reply

    Tossing in another vote for deb packages.

    These patches are swell, but I have little to no experience in building mysql from source. A .deb package would be great!

    Keep up the great work btw =]

    February 26, 2009 at 5:29 am
  • banque d'image Reply

    Debian package voooootte !!!
    it has change my life ^^

    May 26, 2009 at 7:57 am
  • JSmith Reply

    What about Solaris package? Is it possible?

    June 22, 2009 at 2:33 am
  • Nano Reply

    I really want test this in Windows. Please port for Windows!

    November 2, 2009 at 10:50 am
  • Robert Reply

    Another vote for *.deb packages.

    December 6, 2009 at 4:52 pm

Leave a Reply