Percona Releases

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 */

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

Sergio, it should be fixed in next build

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

Pedro,

What OS do you use ?

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

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

Pedro,

Can you run BUILD/compile-pentium ?

it may help

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

Hi,

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

thanks, alagar

Hi,

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

thanks, alagar

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

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.

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

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/

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

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?

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

Are there src.rpm packages for 5.0.84?

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

Ruben,

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

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.

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.

Garrett,

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

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

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?

Craig,

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

I dont see the sphinx engine patch…?

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?

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.

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.

Craig,

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

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.

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.

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/

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>

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

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

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

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

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.

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

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/

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

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 -

Michael, Thanks for your contribution! Updated.

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!

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

maatkit + Percona-XtraDB-shared-51 installation on CentOS (HowTo)

rpm -ihv http://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.90-21/RPM/rhel5/i386/Percona-SQL-shared-50-5.0.90-b21.10.rhel5.i386.rpm rpm -ihv http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.45-10.1/RPM/rhel5/i386/Percona-XtraDB-shared-51-5.1.45-10.1.rhel5.i386.rpm –force yum install Percona-XtraDB-client-51 Percona-XtraDB-server-51 perl-DBD-MySQL perl-DBI rpm -ihv http://maatkit.googlecode.com/files/maatkit-6224-1.noarch.rpm