Buy Percona ServicesBuy Now!

5.0.83-build17 Percona binaries

 | July 28, 2009 |  Posted In: Percona Software

Dear Community, The build 17 of MySQL with Percona patches is available. New features in the release: MySQL-5.0.83 is taken as the basis The new patch innodb_use_sys_malloc.patch is added The new patch innodb_split_buf_pool_mutex.patch is added This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. […]

Read More

XtraDB storage engine release 1.0.3-6

 | July 20, 2009 |  Posted In: Percona Software

Dear community, Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work. The release includes following new features: MySQL 5.1.36 as a base release New patch

Experimental adaptive checkpoint method estimate innodb_stats – the implementation of the fix forMySQL Bug#30423 expand-import Support of import InnoDB / […]

Read More

Improving InnoDB recovery time

 | July 7, 2009 |  Posted In: Percona Software

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup) In this is simple test, I do crash mysql during in-memory […]

Read More

xtrabackup-0.8

 | July 1, 2009 |  Posted In: Percona Software

Dear community, The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features: New mode of innobackupex –stream=tar4ibd; new command tar4ibd based on libtar-1.2.11 Experimental option –export is added (see Vadim’s post “Impossible – possible, moving InnoDB tables between servers”for details) tar4ibd is made to be sure that […]

Read More

5.0.77 / 5.0.82 -build16 Percona binaries

 | June 11, 2009 |  Posted In: Percona Software

Dear community, We are pleased to announce the build16 of MySQL server® with Percona patches. Since the build13 there was a couple of customer specific releases, which explains cutover in numbering and a pause between the builds. Also we prepared build for both 5.0.77 and 5.0.82 versions. Since that time new patches were added: profiling_slow.patch […]

Read More

xtrabackup-0.7 (RC)

 | May 21, 2009 |  Posted In: Percona Software

We announce next version of our xtrabackup tool and we consider it stable enough to put label RC on it. Changelist includes: – use O_DIRECT by default for handling InnoDB files – use posix fadvise call to disable OS caching of copying files – disable recovery of double buffer Also we added binary builds for […]

Read More

Hint: throttling xtrabackup

 | May 20, 2009 |  Posted In: Percona Software

Using xtrabackup for copying files can really saturate your disks, and that why we made special option

to limit rate of IO per second. But it really works when you do local copy. What about stream backup ? Even you copy just to remote box with

, read may be so intensive so […]

Read More

Global Transaction ID and other patches available!

 | May 13, 2009 |  Posted In: Percona Software

I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on Launchpad (https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids). For me it was a big wall in using these patches that they […]

Read More

Btw xtrabackup is not only backup..

 | May 7, 2009 |  Posted In: Percona Software

It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost non-blocking way […]

Read More