PlanetMysql.ru — информация о СУБД MySQL

Percona Server version 5.1.52-rel11.6 is now available for download.

The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

Functionality Added or Changed

•  Percona Server 5.1.52-rel11.6 is now based on MySQL 5.1.52.
•  New Features Added: None
•  Other Changes: None

Bugs Fixed

• Bug #671764 – innochecksum wasn’t distributed with RPM and .DEB packages. (Aleksandr Kuzminsky)
• Bug #673426 – Use of some system variables as command-line options caused a crash or undefined behavior. (Oleg Tsarev)
• Bug #673929 – Query cache misses were being reported for some queries when hits were actually occurring. (Oleg Tsarev)
• Bug #676146 – The development environment test of log_slow_verbosity=innodb on a slave for row-based replication was not working correctly. (Oleg Tsarev)
• Bug #676147 – The development environment test of option log_slow_slave_statements for row-based replication was not working correctly. (Oleg Tsarev)
• Bug #676148 – Similar to Bug #676147. A check is now made for the replication type to test. (Oleg Tsarev)
• Bug #676158 – Setting the query cache size to 512M caused test failure on low memory systems. (Aleksandr Kuzminsky)

Release Notes for this and previous releases can be found in our Wiki.

The latest downloads are available on our website. The latest source code for Percona Server, including the development branch, can be found on Launchpad.

Please report any bugs found at Bugs in Percona Server.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Fred Linhoss | No comment

Add to: | | | |

Percona XtraBackup 1.4 is now available for download.

Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release.

Functionality Added or Changed

• Incremental backups have changed and now allow the restoration of full backups containing certain rollback transactions that previously caused problems. Please see Preparing the Backups and the --apply-log-only option. (From innobackupex, the --redo-only option should be used). (Yasufumi Kinoshita)
• The XtraBackup Test Suite was implemented and is now a standard part of each distribution. (Aleksandr Kuzminsky)
• Other New Features:
  • The --prepare option now reports xtrabackup_binlog_pos_innodb if the information exists. (Yasufumi Kinoshita)
  • When --prepare is used to restore a partical backup, the data dictionary is now cleaned and contains only tables that exist in the backup. (Yasufumi Kinoshita))
  • The --table option was extended to accept several regular expression arguments, separated by commas. (Yasufumi Kinoshita)
• Other Changes:
  • Ported to the Percona Server 5.1.47-11 code base. (Yasufumi Kinoshita)
  • XtraBackup now uses the memory allocators of the host operating system, rather than the built-in InnoDB allocators (see Using Operating System Memory Allocators). (Yasufumi Kinoshita)

Bugs Fixed

• Bug #595770 – Binaries are stripped by rpmbuild, so __os_install_post is redefined to change the default behaviour. (Aleksandr Kuzminsky)
• Bug #589639 – Fixed a problem of hanging when tablespaces were deleted during the recovery process. (Yasufumi Kinoshita)
• Bug #611960 – Fixed a segmentation fault in “xtrabackup”. (Yasufumi Kinoshita)
• Miscellaneous important fixes related to incremental backups.

Release Notes for this and previous releases of Percona Xtrabackup can be found in our Wiki.

The latest downloads are available on our website. The latest source code can be found on Launchpad.

Please report any bugs found at Bugs in Percona XtraBackup.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Fred Linhoss | No comment

Add to: | | | |

Percona Community,

Percona Server version 5.1.51-rel11.5 is now available for download.

The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

Functionality Added or Changed

•  Percona Server 5.1.51-rel11.5 is now based on MySQL 5.1.51.
•  New Features Added: None
•  Other Changes: None

Bugs Fixed

•  Bug #661354 – Fixed a problem compiling query_cach_with comments for 5.1.51-rel11.5. (Oleg Tsarev)
•  Bug #661844 – Fixed a problem with server variables failing test for 5.1.51-rel11.5. (Oleg Tsarev)

The Release Notes for this and previous releases can be found in our Wiki. 

The binary packages are available on our website.
The latest source code for Percona Server, including the development branch, can be found on LaunchPAD.

Please report any bugs found at Bugs in Percona Server.
For general questions, use our Pecona-discussions group, and for development questions our Percona-dev group.
For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Fred Linhoss | No comment

Add to: | | | |

Dear Community,

Percona Server version 5.1.50-rel12.1 RC is now available for download.

Functionality Added or Changed

• Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50.
• New Features Added:
  • innodb_lru_dump_restore – Implemented automatic dumping of the buffer pool at specified intervals.
  • innodb_buffer_pool_shm – Implemented option ”innodb_buffer_pool_shm_checksum”; when enabled, shared memory buffer pool is checksum validated. This change also fixed these bugs: #643724, #649408, and #649393. (Yasufumi Kinoshita)
  • innodb_expand_import – Implemented more exact checking to avoid corruption of the ”.ibd” file using ”innodb_expand_export”. (Yasufumi Kinoshita)
  • remove_eol_carret – Implemented a MySQL client option to handle end-of-line in BLOB fields differently. This change also fixed bug #625066. (Sasha Pachev)
  • response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev)

Bugs Fixed

The binary packages are available on our website.
The Release Notes for this and previous releases can be found in our Wiki.

The latest source code for Percona Server, including the development branch, can be found on LaunchPAD.

Please report any bugs found at Bugs in Percona Server.
For general questions, use our Pecona-discussions group, and for development questions our Percona-dev group.

For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Fred Linhoss | No comment

Add to: | | | |

Dear Community,

Starting this release we introduce new release model of Percona Server. We will have Stable and Release Candidate releases. Release Candidates introduce new features not available in stable releases.

Our new 5.1.49-12.0 RC along with new features contains couple patches from Facebook-MySQL tree https://launchpad.net/mysqlatfacebook , especially worth to note
better integration with FlashCache.

We also introduce the very interesting new feature (sponsored by Well Known Social Network site) “Permanent InnoDB Buffer Pool” which allows to keep InnoDB buffer pool in memory between restarts of MySQL servers.
It allows to significantly increase warmup time after MySQL restarts.

Starting this release we also provide special builds optimized for Cisco UCS B250/C250 servers, which comes with a lot of
memory ( up to 384GB ) and “Permanent InnoDB Buffer Pool” is especially interesting for servers with 128GB+ memory sizes, as it may take hours to warm empty InnoDB buffer pool on these boxes.

Percona Server version 5.1.49-rel12.0 RC is available for download now.

The changes in this release include:

New features

Fixed bugs

The binary packages are available on our website.
The Release Notes to this and previous releases can be found in our Wiki.

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

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon.

This release contains long waited features from 5.0:

• extended slow.log
• USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS

Extended slow.log is now even more extended, there is additional information for each query:

That is you can see how many bytes was returned by query, was temporary table used,
was it disk table or in-memory, and how big was temporary table.

Also you can profile each individual query from stored procedures, so now you should not
guess what took so long in stored procedure.

What we are working on right now is:

• InnoDB pagesize, so you will be able to specify 4K, 8K, 16K pagesize when you created database
• InnoDB fast checksums, idea and implementation was taken from Facebook patches
• InnoDB big log files ( bigger 4GB). As our benchmarks on FusionIO shows, you may need
  4GB+ log files to get more performance on fast storage systems
• SHOW TEMPORARY FILES, patch from Venu Anuganti
• INFORMATION_SCHEMA.SYS_TABLES and SYS_INDEXES to show internal InnoDB data dictionary

Full list of XtraDB engine features (what makes it different from InnoDB-plugin) on the state as it is right now:

Performance improvements

• Improved buffer_pool scalability
• Fast recovery
• Improved IO path
• Improved rollback segment scalability
• Separate purge thread
• Limited size of data dictionary in memory
• Increased number of concurrent write transactions (undo slots) ( up to 4000 )
• Fast checksums ( in release process )
• Support of different pagesizes ( 4K, 8K, 16K) ( in release process )

Usability / operations

• Show content of buffer_pool
• Import / export of dedicated tables
• Import / export of buffer_pool
• Transactional replication
• Show internal InnoDB data dictionary
• Show InnoDB locking/io profiling in slow.log

I hope you enjoy our work!

Entry posted by Vadim | No comment

Add to: | | | |

Dear Community,

As of today release 0.9.5rc is available.

In this release there are following changes:
Changelog:

• Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your
  tables are InnoDB and you DO NOT CARE about binary log
  position of backup
• XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported. We thank a well known Social Network site for the sponsorship.
  
• Windows conscious change more
• Impoved error messages in innobackupex
• Windows conscious experimental change
• Suppress purge when –stats
• Build number in RPM name. For instance, in the name xtrabackup-0.9.5rc-50.rhel5.x86_64.rpm 50 is the build number.
• Suppress master_thread ibuf operations for –stats
• Suppress ibuf operations for –stats
• fFx fatal bug at –backup when added –stats
• New option –stats to gather index stats
• Fixed some bugs for a 32bit platform

Fixed bugs:

• Bug #435634 in Percona-XtraBackup: “xtrabackup can’t write to a file on windows”
• Bug #437788 in Percona-XtraBackup: “xtrabackup.exe can’t write to a file”
• Bug #386535 in Percona-XtraBackup: “ibbackup_binlog_marker bug still persists”
• Bug #402884 in Percona-XtraBackup: “tries to create temporary tables in relative ./tmp directory”
• Bug #417178 in Percona-XtraBackup: “can’t backup tables with $ in name”

The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/.

The Debian package is also available via APT. Just add these lines  in /etc/apt/sources.list

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

Update the local database

# apt-get update

And install xtrabackup

# apt-get install xtrabackup

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |