Dear Community,
Percona Server version 5.1.47-rel11.0 is available for download now.
The changes in this release include:
New features
- Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8.
- XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona’s earlier fast-recovery code.
- Added the –percona_innodb_doublewrite_path option to place the double-write-buffer into its own file (issue #584299). The feature is sponsored by Large Social Network website.
- Added the –suppress_log_warning_1592 option to disable logging of error code 1592.
- Added the –microseconds_in_slow_query_log option to use microsecond precision for the slow query log’s timestamps (issue #358412).
- Added the –use_global_log_slow_control option to control slow-query logging globally without restarting, similar to –use_global_long_query_time.
- Added the –query_cache_strip_comments option to strip comments from query before using it in query cache.
- Added a global Innodb_deadlocks counter to SHOW STATUS, based on a patch by Eric Bergen (issue #569288, issue #590624).
- Added more tests to the MySQL test framework.
Fixed bugs
- #573100 Can’t compile 5.1.46
- #573104 separate name in INNODB_SYS_TABLES table
- #580324 Security bug in upstream
- #586579 Percona Server 11 fails to compile with CFLAGS=-DUNIV_DEBUG
- #569156 CentOS 5: mysql-server conflicts with MySQL-server
- #589639 Recovery process may hang when tablespaces are deleted during the recovery
- #570840 deb package conflicts with libdbd-mysql-perl
The binary packages are available on our website.
Starting from this release there is a uniform naming scheme for Percona binaries for 5.0 and 5.1 based packages. RPM are named as:
Percona-Server-<sub package>-<package suffix>-<mysql version>-<release number>.<revision number>.<os code>.<platform>.rpm
Examples:
1 2 | Percona-Server-server-51-5.1.47-rel11.0.46.rhel5.x86_64.rpm Percona-Server-client-51-5.1.47-rel11.0.46.rhel5.x86_64.rpm |
Here:
- “Percona-Server” is a name of the product.
- “server” or “client” – sub-package
- 51 – suffix, which means the packages are based on 5.1.x versions
Together “Percona-Server-server-51” is the package name.
- 5.1.47 is the MySQL version the package is based on
- rel11.0 is release number
- 46 is BZR revision
- rhel5 is an operating system code
- x86_64 is a platform
Percona Server obsoletes Percona XtraDB both on rhel and debian paltform. To install RPM or DEB package from Percona repository you just have to do “yum install Percona-Server-server-51”. If there is Percona-XtraDB installed it will be replaced by Percona Server. However Percona-Server doesn’t obsolete MySQL, so you have to deinstall it first. Conflicts are inevitable otherwise.
If there are MySQL dependant applications already installed, you might want to install Percona Shared Compat package before installing Percona Server.
The latest source code of Percona Server, including development branch you can find on LaunchPAD.
Please report any bugs found on Bugs in Percona Server.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.
For support, commercial and sponsorship inquiries contact Percona
isn’t it
“percona-server-server-5.1”
?
http://repo.percona.com/apt/dists/lenny/main/binary-x86_64/Packages
Normann,
Yes, it is. The version in the repo should be “5.1.47-11.0-47.lenny”
It’s a pity that you only included InnoDB 1.0.8 without patches. The bug on http://bugs.mysql.com/bug.php?id=54330 was discovered and fixed recently. Fast index creation on XtraDB should come with a warning.
Is there a 32-bit Percona-Shared-Compat anywhere? I only found x86-64 versions at https://www.percona.com/downloads/Percona-Shared-Compat/
Sergio,
Please try this one https://www.percona.com/downloads/Percona-Shared-Compat/Percona-Server-shared-compat-5.1.48-4.i386.rpm
Aleksandr,
Works perfectly, thanks!
Aleksandr, works great, thanks!
I complile Percona server with options CC=“gcc -static-libgcc†CFLAGS=â€-O3 -pipe -m64 -fPIC -fomit-frame-pointer†CXX=“gcc -static-libgcc†CXXFLAGS=â€-O3 -pipe -m64 -fPIC -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti†./configure –prefix=/opt/xtradb –enable-local-infile –enable-thread-safe-client –enable-assembler –with-client-ldflags=-all-static –with-mysqld-ldflags=-all-static –with-unix-socket-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug –with-tcp-port=3306 –with-readline –enable-profiling –disable-shared –enable-static –with-extra-charsets=complex –with-pic –with-fast-mutexes –with-zlib-dir=bundled –with-ssl
my.ini add options
default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1
it work Percona server 10 but can work with 11
I complile Percona server with options CC=“gcc -static-libgcc†CFLAGS=â€-O3 -pipe -m64 -fPIC -fomit-frame-pointer†CXX=“gcc -static-libgcc†CXXFLAGS=â€-O3 -pipe -m64 -fPIC -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti†./configure –prefix=/opt/xtradb –enable-local-infile –enable-thread-safe-client –enable-assembler –with-client-ldflags=-all-static –with-mysqld-ldflags=-all-static –with-unix-socket-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug –with-tcp-port=3306 –with-readline –enable-profiling –disable-shared –enable-static –with-extra-charsets=complex –with-pic –with-fast-mutexes –with-zlib-dir=bundled –with-ssl
my.ini add options
default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1
it work Percona server 10 but can work with 11
how to install
I need your help
You should use forums or mailing lists for help — not comments on this blog.
OK
I post a help topic at
http://forum.percona.com/index.php/m/5874/#msg_5874
Aleksandr, but the version in the repro is “5.1.47-11.1-51.lenny” not “5.1.47-11.0-47.lenny”
Normann,
A maintenance build was released since that time. Please see the changelog at https://www.percona.com/docs/wiki/percona-server:release_notes_51#release_5147-111