Percona Releases

This page lists current Percona releases, newest first. Patch documentation is also available.

MySQL is a trademark of Sun Microsystems. Percona is an independent firm, not affiliated with Sun Microsystems. All software modified and distributed in accord with the GPL v2 license.

Percona APT repository

Configuration

Debian packages from Percona are signed with a key. Before using the repository the key should be added to APT. To do that run following commands:

# gpg --keyserver  hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
gpg: requesting key CD2EFD2A from hkp server subkeys.pgp.net
gpg: key CD2EFD2A: public key "Percona MySQL Development Team <mysql-dev@percona.com>" imported
gpg: Total number processed: 1
gpg:               imported: 1

# gpg -a --export CD2EFD2A | apt-key add -

Add this to /etc/apt/sources.list

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

Put etch, jaunty, intrepid or hardy instead of lenny depending of your debian distribution.

Do not forget to update the local cache

# apt-get update

Platforms

  • x86_64 aka amd64

OS

  • lenny
  • etch
  • lucid
  • karmic
  • jaunty
  • intrepid
  • hardy

Percona YUM repository

Configuration

Installation Percona repo with RPM

You can install Percona-release RPM. It onfigures YUM to use Percona repo plus installs the key RPM-GPG-KEY-percona used for signing RPMs.

[root@CentOS-5-x86-64 ~]# rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:percona-release        ########################################### [100%]
[root@CentOS-5-x86-64 ~]# 
Manual YUM configuration

:!: Below is described manual configuration of a Percona YUM repository.

Create a file Percona.repo in /etc/yum.repos.d with following content

[percona]
name=CentOS-$releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
gpgcheck=1

make sure packages are downloaded from the repository

[root@CentOS-5-x86-64 ~]# yum list | grep percona
percona-release.x86_64                     0.0-1                       installed
...
Percona-Server-client-51.x86_64            5.1.47-rel11.1.51.rhel5     percona  
Percona-Server-devel-51.x86_64             5.1.47-rel11.1.51.rhel5     percona  
Percona-Server-server-51.x86_64            5.1.47-rel11.1.51.rhel5     percona  
Percona-Server-shared-51.x86_64            5.1.47-rel11.1.51.rhel5     percona  
Percona-Server-test-51.x86_64              5.1.47-rel11.1.51.rhel5     percona  
...
maatkit.noarch                             5240-1                      percona  
xtrabackup.x86_64                          1.2-22.rhel5                percona  

Old packages

Old packages are removed from main repository, however it is still possible to find them.

There is an archive repo percona-attic.

Create a file Percona-attic.repo in /etc/yum.repos.d with following content

[percona-attic]
name=CentOS-$releasever - Percona
baseurl=http://repo.percona.com/centos-attic/$releasever/os/$basearch/
gpgcheck=1

Platforms

  • x86_64
  • i386

OS

  • CentOS 4
  • CentOS 5
Please note that this is NOT a place to ask questions or report bugs. This comment system is only intended for users to share tips and documentation additions concerning particular document.
Please report bugs to https://bugs.launchpad.net/percona-project/+filebug and ask general questions in maillist Percona-discussions

Discussion

sbester, 2009/06/02 01:28

hi!!

you have a syntax error in the microslow patch: http://www.percona.com/mysql/5.0.77-b13/patches/microslow_innodb.patch

this line misses a bracket:

newtime= (GetTickCount() * 1000; /* GetTickCount only returns milliseconds */

pedro, 2009/06/04 12:12

There is a new version (mainly bugfixes) of mysql - 5.0.82. Did you plan to patch it soon?

Vadim Tkachenko, 2009/06/10 21:36

Sergio, it should be fixed in next build

Sergio, 2009/06/11 07:27

Thank you. Only now I'm noticed here wiki syntax used =)

Vadim Tkachenko, 2009/06/12 13:06

Pedro,

What OS do you use ?

pedro, 2009/06/12 13:11

PLD ( http://pld-linux.org/ )

pedro, 2009/06/12 14:23

BTW, just compiled 5.0.77 b16 It's ok on PLD as I see… So the problem is in 5.0.82… :(

Vadim Tkachenko, 2009/06/12 14:37

Pedro,

Can you run BUILD/compile-pentium ?

it may help

sbester, 2009/06/12 21:45

hello, its a windows only problem. but then again, entire source don't compile on windows in any case…

Alagar, 2009/07/08 10:48

Hi,

can you please include 'show client_statistics' in userstats.patch for mysql-5.1.x ?

thanks, alagar

Alagar, 2009/07/08 11:09

Hi,

can you please include 'show client_statistics' in userstats.patch for mysql-5.1.x ?

thanks, alagar

Teodor Milkov, 2009/07/20 12:54

Looks like there's memory leak in the userstats patch. See https://bugs.launchpad.net/ourdelta/+bug/338012

Singer Wang, 2009/07/30 09:18

Do you guys have an scheduled release for the patched 5.1.36? We upgraded to the patched 5.1.34 but had numerous crashes due to a GROUP BY bug in 5.1.34 (the bug is in MySQL code, not the Percona patches) and were forced to upgrade to a un-patched 5.1.36.

Vadim Tkachenko, 2009/07/30 09:28

Singer, We have released 5.1.36-XtraDB6, check in XTraDB releases.

Singer Wang, 2009/07/30 12:32

Vadim:

Okay, waht's the difference between the 5.1.36-XtraDB6 and the Percona-5.1.36?

Eg. What's available here http://www.percona.com/mysql/ vs http://www.percona.com/mysql/xtradb/

Singer Wang, 2009/07/30 12:35

We were using the 'Enhanced and Patched MySQL Servers' for better InnoDB performance, not the XtraDB featurse.

Sheeri Cabral, 2009/08/05 11:14

For people who want the performance patches but not the XtraDB storage engine, will you be creating a 5.1.36 without XtraDB? If not, are new binaries only going to appear in percona.com/mysql/xtradb?

Vadim Tkachenko, 2009/08/05 11:32

Sheeri,

We did not port performance patches for 5.1 with standard InnoDB, and do not have plans to, unless there are special requests.

We do plan only move forward with percona.com/mysql/xtradb

Ruben Kerkhof, 2009/08/11 09:19

Are there src.rpm packages for 5.0.84?

erin oneill, 2009/08/11 16:18

when running the make on this version: mysql-5.1.26-rc-percona-src.tar.gz (yes, I untarr'd it & ran ./configure –prefix=/opt/mysql) make failed.

the error was not clear but it seemed like it was some yacc command. ha! I not only did NOT have yacc/lex but I didn't have bison/flex. I'd already installed other versions of mysql just fine. Installed bison flex & make worked. Would have been nice if configure stopped & told me I needed those ….

Aleksandr Kuzminsky, 2009/08/27 23:54

Ruben,

please find src.rpm in http://www.percona.com/mysql/5.0.84-b18/source/

David Murphy, 2009/09/14 15:21

As a follow up , if you would just build a shared-compat this would fix my issue, it seems php on el5 is built against mysql 5.0 not 5.1 and so there was some missing/renamed so files. installing http://downloads.mysql.com/archives/mysql-5.1/MySQL-shared-compat-5.1.37-0.rhel5.x86_64.rpm corrected the issues.

Garrett Prochnow, 2009/09/23 09:57

Why do you add the build number to the RPM name? Shouldn't that stay in the version field? It forces an uninstall & reinstall of the RPM. Plus, it makes our puppet configuration more complicated.

Vadim Tkachenko, 2009/09/23 10:23

Garrett,

There is no particular preference in our current version name over what you propose. We may reconsider that. Thanks!

Pete Lancashire, 2009/09/30 11:27

Build of the high perf 5.0.84 fails Fedora 11 updated to Sept 30, GCC 4.4.1

ha_innodb.cc: In function ‘bool innodb_I_S_buffer_pool_content(THD*, TABLE_LIST*)’: ha_innodb.cc:6784: error: invalid conversion from ‘const char*’ to ‘char*’

./configure \

  1. -with-gnu-ld \
  2. -without-debug \
  3. -with-berkeley-db \
  4. -with-example-storage-engine \
  5. -with-archive-storage-engine \
  6. -with-blackhole-storage-engine \
  7. -with-ndbcluster \
  8. -with-federated-storage-engine

build of 84 and 86 from mysql.com succeed

Craig, 2009/10/14 06:07

Is there any plans to add the userstats to 5.1.3x-xtradb release? This is probably one of the most useful patches there is for hosting providers and the like, shame to see it missing from the new xtradb releases. Unless I'm blind?

Vadim Tkachenko, 2009/10/14 07:53

Craig,

We have the plan to port userstats to 5.1 but we concentrate on patches and features which are most interested for customers.

Ron Shigeta, 2009/10/14 21:27

I dont see the sphinx engine patch…?

Craig, 2009/10/14 21:59

re: userstats Understood. Just FYI (for your own feedback or anyone else reading this): With a few modifications we can get the userstatsv1 patch from 5.1.29-percona to apply and build cleanly against the xtradb release but I'm a little scared to use that in production. I'm taking it you removed it for a good reason?

Our environment is Opensolaris/amd64 and we're building 64bit binaries with sunstudio12. We can build the xtradb releases without much issue, but the recent 5.0.3x-percona builds don't seem to build at all in this environment, as they seem to depend on gcc (gcc4?):

#ifdef HAVE_ATOMIC_BUILTINS /* This value means NOT_LOCKED */ #define RW_LOCK_BIAS 0×00100000 #else #error HAVE_ATOMIC_BUILTINS is not defined. Do you use enough new GCC or compatibles?

Vadim Tkachenko, 2009/10/14 22:05

Craig,

userstatv1 is not tested really in 5.1, so I can't say how it works…

To compile our builds you need GCC 4.1 at least.

Craig, 2009/10/29 18:45

Is there any issue's that you are aware of with using sunstudio for 64bit/amd64 xtradb builds? From memory, it's what sun recommends for building 64bit MySQL on solaris/opensolaris, and it seems to work fairly well (for xtradb and vanilla mysql)… we havn't run into trouble yet.

GCC has all kinds of issues (there's also no native gcc4 package on these systems).

Have you guy's considered having support for solaris/opensolaris out of the box? Solaris/ZFS is obviously very attractive for new MySQL deployments.

Vadim Tkachenko, 2009/10/29 18:51

Craig,

We see increasing interest to Solaris platform, so most likely releases for Solaris will be available sometime.

pedro, 2009/11/24 14:40

Mmmm…:

wget http://www.percona.com/mysql/5.0.87-b20/source/mysql-5.0.87-percona-b20-src.tar.gz –2009-11-24 23:35:32– http://www.percona.com/mysql/5.0.87-b20/source/mysql-5.0.87-percona-b20-src.tar.gz Resolving www.percona.com… 69.80.205.238 Connecting to www.percona.com|69.80.205.238|:80… connected. HTTP request sent, awaiting response… 404 Not Found 2009-11-24 23:35:33 ERROR 404: Not Found.

wget http://www.percona.com/mysql/5.0.87-b20/source/mysql-5.0.87-percona-highperf-b20-src.tar.gz –2009-11-24 23:35:51– http://www.percona.com/mysql/5.0.87-b20/source/mysql-5.0.87-percona-highperf-b20-src.tar.gz Resolving www.percona.com… 69.80.205.238 Connecting to www.percona.com|69.80.205.238|:80… connected. HTTP request sent, awaiting response… 404 Not Found 2009-11-24 23:35:51 ERROR 404: Not Found.

Gil, 2009/12/12 09:16

Just tried to install via yum but the repository is missing (error 404). The path it uses is http://repo.percona.com/centos/5Server/os/x86_64/repodata/repomd.xml

Does the yum repository only work with CentOS and not RHEL5?

Thanks for creating this awesome set of patches.

Aleksandr Kuzminsky, 2009/12/12 09:28

Gil,

The reason is your system sets $releasever to 5Server while 5 or 4 are expected. Please change baseurl to baseurl=http://repo.percona.com/centos/5/os/$basearch/

Iavor Stoev, 2010/01/13 07:44

Hello,

I'm facing the same problem described from Marcus Herou above, when I try to compile mysql-5.0.89 from source using userstatv2.patch and microslow_innodb.patch. Without Persona’s patches the MySQL compilation is OK. Any help will be appreciated.

Thank you

Iavor Stoev

<pre> gcc -DHAVE_CONFIG_H -I. -I../include -I../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF -MT conf_to_src.o -MD -MP -MF .deps/conf_to_src.Tpo -c -o conf_to_src.o conf_to_src.c mv -f .deps/conf_to_src.Tpo .deps/conf_to_src.Po /bin/sh ../libtool –preserve-dup-deps –tag=CC –mode=link gcc -DDBUG_OFF -O3 -DDBUG_OFF -static -rdynamic -o conf_to_src conf_to_src.o xml.o ctype.o bcmp.o -lpthread -lcrypt -lnsl -lm -lpthread -lrt ../libtool: line 463: CDPATH: command not found ../libtool: line 1141: func_opt_split: command not found libtool: Version mismatch error. This is libtool 2.2.6, but the libtool: definition of this LT_INIT comes from an older release. libtool: You should recreate aclocal.m4 with macros from libtool 2.2.6 libtool: and run autoconf again. make[2]: * [conf_to_src] Error 63 make[2]: Leaving directory `/build/mysql-5.0.89/strings' make[1]: * [all-recursive] Error 1 make[1]: Leaving directory `/build/mysql-5.0.89' make: *** [all] Error 2 </pre>

Iavor Stoev, 2010/01/13 07:47

I forgot to mention that on the same machine mysql-5.0.82 can be compiled without failure with both Percona patches described above.

Carlos, 2010/02/04 11:49

Has anyone found a work around for the errors Marcus Herou or Iavor Stoev listed above? I am getting the same error:

/bin/sh ../libtool –preserve-dup-deps –tag=CC –mode=link gcc -O3 -DDBUG_OFF -static -rdynamic -o conf_to_src conf_to_src.o xml.o ctype.o bcmp.o -lpthread -lcrypt -lnsl -lm -lpthread -lrt ../libtool: line 463: CDPATH: command not found ../libtool: line 1141: func_opt_split: command not found libtool: Version mismatch error. This is libtool 2.2.6, but the libtool: definition of this LT_INIT comes from an older release. libtool: You should recreate aclocal.m4 with macros from libtool 2.2.6 libtool: and run autoconf again. make[2]: *** [conf_to_src] Error 63

This seems to be a problem with the aclocal.m4 version but I don't know how to recreate it with libtool 2.2.6.

Thanks, -Carlos

Manuel de Ruiter, 2010/02/23 23:43

@Carlos, @iavor Stoev:

The solution is already given in the error file. Steps to do: 1. cd Percona MySQL Directory 2. aclocal 3. autoheader 4. autoconf 5. automake 6. ./configure –extra-parameters 7. make install clean

And then it must be installed.

Jason, 2010/03/09 18:19

Why did you change the name to percona-xtradb-* for the Debian packages? What do you recommend for getting around dependencies like this:

# apt-get install percona-xtradb-common The following packages will be REMOVED:

apache2 apache2-mpm-prefork apache2-utils apache2.2-common libapache2-mod-geoip libapache2-mod-php5 libaprutil1 libdbd-mysql-perl
libmysqlclient15off libmysqlclient16 libserf-0-0 libsvn-perl libsvn1 mysql-client-5.1 mysql-common mysql-server mysql-server-5.1 php5 php5-mysql
python-subversion subversion subversion-tools

The following NEW packages will be installed:

percona-xtradb-common
Edward Walker, 2010/03/23 23:45

I downloaded the 5.0.86 “Patched Release” sources and built it a while back. It's worked wonderfully. Thanks so much.

Now I'd like to move up to 5.1.x. I'm confused. Where do I download sources for the 5.1.x Percona binaries? I understand how to install 5.1.x Percona binaries (I'm on CentOS). But I want to build it myself. Are the Percona 5.1.x binaries a stock 5.1.x with innobase replaced with XtraDB? I understand how to obtain the source files for stock 5.1.x and XtraDB.

Greg, 2010/04/03 12:36

I'm getting 403 Forbidden errors accessing the yum repo

Loaded plugins: downloadonly, rhnplugin, security http://repo.percona.com/centos/5Server/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 403: Forbidden Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: percona. Please verify its path and try again

Kevin, 2010/04/10 17:07

I am also getting the same 403 Error as Greg when trying to access http://repo.percona.com/centos/5Server/os/x86_64/repodata/repomd.xml/

Michael Abramowich, 2010/04/11 00:40

Please improve text regarding APT-repo.

That is what you wrote:

Percona APT repository→Configuration

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

# apt-get update

But apt-get fails caused by GPG-key absence. Please add following strings before “apt-get update”:

gpg –keyserver subkeys.pgp.net –recv-keys 1C4CBDCDCD2EFD2A gpg -a –export CD2EFD2A | sudo apt-key add -

Thanks in advance.

Michael Abramowich, 2010/04/11 00:43

oops… my previous message been miswritin'. Please put a carrier return right before second gpg. Like this: gpg –keyserver subkeys.pgp.net –recv-keys 1C4CBDCDCD2EFD2A

gpg -a –export CD2EFD2A | sudo apt-key add -

Aleksandr Kuzminsky, 2010/04/19 08:22

Michael, Thanks for your contribution! Updated.

Sergio Simone, 2010/04/27 10:01

Hi there, i just installed percona-xtradb deb packages and they forced the removal of libdbd-mysql-perl and consequently maatkit and mysql-mmm packages. I suppose this was not an intended outcome :) Do you have any suggestions on how to fix this? thanks!

Aleksandr Kuzminsky, 2010/05/04 07:02

Sergio, this is fixed now, could you please check?

Sergio Simone, 2010/05/05 09:15

Thank you Aleksandr, it's okay now!

Enter your comment (wiki syntax is allowed):
GJRDM
 
release/start.txt · Last modified: 2010/08/27 17:47 by aleksandr.kuzminsky
 
Except where otherwise noted, content on this wiki is licensed under the following license:GNU Free Documentation License 1.2
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki