July 16, 2008

Percona builds with Percona patchsets

Posted by Vadim |

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:
http://www.mysqlperformanceblog.com/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:
http://www.mysqlperformanceblog.com/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.

Posted by Vadim @ 9:08 pm :: percona, production  
Print This Post Print This Post book mark Percona builds with Percona patchsets in del.icio.usdel.icio.us :: submit Percona builds with Percona patchsets to digg.comdigg  
Comment RSS  
Related posts: :Mirrored Binlogs patch::Debian / Ubuntu Percona builds::The patches are going to Launchpad:
 

33 Comments »

  1. 1. Mark Atwood

    Have you considered putting your tree up on Launchpad?

    Comment :: July 16, 2008 @ 10:09 pm

  2. 2. John Laur

    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?

    Comment :: July 16, 2008 @ 10:28 pm

  3. 3. Vadim

    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.

    Comment :: July 16, 2008 @ 10:41 pm

  4. 4. Vadim

    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.

    Comment :: July 16, 2008 @ 10:44 pm

  5. 5. Ronald Bradford

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

    Comment :: July 16, 2008 @ 11:31 pm

  6. 6. Marki

    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.

    Comment :: July 17, 2008 @ 1:08 am

  7. 7. Roland Bouman

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

    PBXT, Sphinx ?

    Comment :: July 17, 2008 @ 1:09 am

  8. 8. pabloj

    Any plans for a windows binary?

    Comment :: July 17, 2008 @ 1:45 am

  9. 9. R. Iqbal

    Another vote for Debian packages :-)

    Comment :: July 17, 2008 @ 2:42 am

  10. 10. Gregory Haase

    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.

    Comment :: July 17, 2008 @ 5:50 am

  11. 11. Vadim

    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.

    Comment :: July 17, 2008 @ 11:51 am

  12. 12. Jeremy Zawodny

    Excellent.

    Comment :: July 17, 2008 @ 8:35 pm

  13. 13. Pablo Pernot

    Very interesting.

    another vote for debian btw…

    Comment :: July 18, 2008 @ 12:15 am

  14. 14. Chris

    Nice!

    .. and another Debian vote ;)

    Comment :: July 18, 2008 @ 6:43 am

  15. 15. Mark Callaghan

    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?

    Comment :: July 18, 2008 @ 8:22 am

  16. 16. Vadim

    Mark,

    Yes, it contains
    SHOW USER_STATISTICS / INDEX_STATISTICS / TABLE_STATISTICS.

    We are going to make this info available via INFORMATION_SCHEMA.

    Comment :: July 18, 2008 @ 9:23 am

  17. 17. Ernesto Vargas

    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.

    Comment :: July 18, 2008 @ 5:47 pm

  18. 18. Michael Myles

    I am SERIOUSLY requesting Windows binaries :-) You guys are great!

    Comment :: July 21, 2008 @ 7:05 am

  19. 19. Cyril Scetbon

    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 ?

    Comment :: July 23, 2008 @ 3:10 am

  20. 20. Gogo

    Thanks Cyril. Can’t wait to see the debian package ;-)

    Comment :: July 23, 2008 @ 7:09 am

  21. 21. Gogo

    @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.

    Comment :: July 23, 2008 @ 7:10 am

  22. 22. Gogo

    And yes, I vote for another Debian package :-)

    Comment :: July 23, 2008 @ 7:11 am

  23. 23. Ricardo Cescon

    Debian package vote ;)

    Comment :: July 29, 2008 @ 2:43 am

  24. 24. Christoph

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

    Comment :: July 30, 2008 @ 1:25 am

  25. 25. Kevin Burton

    Sweet…..

    Consider this a debian vote.

    Comment :: August 1, 2008 @ 8:34 pm

  26. 26. Joe

    Vote for debian package.

    Comment :: September 22, 2008 @ 11:20 am

  27. 27. Alex

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

    Comment :: September 24, 2008 @ 4:40 pm

  28. 28. Alexander Mikhailian

    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.

    Comment :: February 3, 2009 @ 8:30 am

  29. 29. Vadim

    Alexander,

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

    Comment :: February 3, 2009 @ 9:03 am

  30. 30. Rob

    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 =]

    Comment :: February 26, 2009 @ 5:29 am

  31. 31. banque d'image

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

    Comment :: May 26, 2009 @ 7:57 am

  32. 32. JSmith

    What about Solaris package? Is it possible?

    Comment :: June 22, 2009 @ 2:33 am

  33. 33. Nano

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

    Comment :: November 2, 2009 @ 10:50 am

 

Subscribe without commenting

Trackbacks/Pingbacks