May 25, 2012

Post: Announcing Percona XtraBackup 1.9.1

… to announce the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are… was 1.6.5 at the time of writing). This beta adds some really exciting features and bug fixes. New features include: Backup and… format is now supported along with the tar format. The new xbstream format works with parallel compression to (without caching) stream…

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not… this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower… than 5.0, and same applies to the new Innodb code. Well newer does not mean more efficient, on the contrary newer features often…

Post: 5.0.87-build20 Percona binaries

… build of MySQL server with Percona patches. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To…/$basearch/ gpgcheck=0 As usual you can download binaries and sources with the patches here http://www.percona.com/mysql/5.0.87-b20…

Post: 5.0.86-build19 Percona binaries

… of MySQL server with Percona patches is available. Comparing to the previous release it has following new features: The build is based on MySQL-5.0… http://www.percona.com/mysql/5.0.86-b19/ There is Debian packages repository available since Build 19. To install MySQL with Percona patches…

Post: What's the recommended MySQL version?

… of a new feature that’s available in the new version, then there shouldn’t really be urgent pressure to upgrade. For new deployments… MySQL 5.0 and are now considering or executing upgrades to MySQL 5.5. So what’s the bottom line? For new applications, I’ve said use MySQL 5.5… even say use MySQL 5.6. For older applications running MySQL 5.0, I’d say upgrade to 5.5 directly, skipping over 5.1. MySQL 5.0 is really old…

Post: MySQL Quality of old and new features

… minor optimization was implemented in MySQL 5.0. Surely Baron is right Bug fixes are not much different from new features in terms of possibility… to be cautions using new features which first came in MySQL 5.0 They are now much better than were when MySQL 5.0 just came out (aka minefield) but still they are not at quality levels of base MySQL features. Plus we…

Post: Upgrading MySQL

… starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5… behavior changes which may impact your application only subtly – some features can stop working or work differently after change. For example…

Post: Percona Server 5.5.10 (Release Candidate)

… that have been made since Percona Server beta release 5.5.8-20.0: New Features Added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ… Import feature, importing .ibd files created on MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) MySQL

Post: Percona Server 5.1.58-12.9

… Fixed: #803270 (Yasufumi Kinoshita). A remaining loop from an unimplemented feature degraded the performance when using compressed tables and has been… Two new collations, utf8_general50_ci and ucs2_general50_ci, have been to improve compatibility for those upgrading from MySQL 5.0 or 5.1…

Post: XtraDB storage engine release 1.0.3-7

… plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37 as a base release speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1.35 crashes with Failing assertion…