June 19, 2013

Post: Bug fix of InnoDB scalability problem

…’t miss bug fix of my favorite bug 15815. I wrote about this problem before and also investigated in my presentation. Finally bug fix was… thread executes 1.4 times slower. So I’d want InnoDB team continue to work on performance improvement. Anyway I think…

Post: Magic Innodb Recovery self healing

… with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug… course we still hoped new MySQL release will have this Innodb bug fixed) until today we got MySQL to crash during recovery process… this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and load them…

Post: Percona XtraBackup 1.6.4

… Server 5.5.16-22.0 and get all the InnoDB bug fixes each of these releases contain. Using xtrabackup to back up… is held. See the rsync for non-innodb files blueprint for technical implementation details. Bugs Fixed innobackupex assumed that /usr/bin/perl was… the dropped table. With this bug fix, innobackupexnow safely ignores file not found errors for non-InnoDB tables. Bug Fixed: #859546 (Lachlan Mulcahy) When the…

Post: Announcing Percona XtraBackup 2.0.4

… values were not normalized to the values used inside InnoDB. Bug fixed #1062684 (Sergei Glushchenko). Bug fix for #932623 introduced the regression in XtraBackup 2…. Bug fixed #1068470 (Sergei Glushchenko). XtraBackup now accepts the –innodb=force option, previously it would throw an error if the option was set. Bug fixed

Post: InnoDB benchmarks

… compare overall performance of InnoDB in 5.0 and 5.1 before and after fixes. Problems in InnoDB that were fixed: Thread trashing issues… and was fixed in 5.1.12 (more info about InnoDB mutexes) Scalabilty issue, the well know bug 15815, that was fixed in 5… Dec 2006) – with 15815 bug fix 5.1.12 with fix of thread trashing 5.1.14 with all fixes 5.0.30 just…

Post: How quickly you should expect to see bugs fixed

bugs are fixed (This is actually Innodb one, so Innobase/Oracle is responsible for fixing it not MySQL/Sun but there are MySQL bugs not fixed for years too). Look for workarounds or ways to fix things yourself. In particular case workaround was rather easy – reducing Innodb

Post: Interested to learn about New Innodb Plugin Performance ?

… see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite. We… were impressed in quality (we found only one crash bug which was fixed in less than 24 hours) as well as performance… with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump…

Post: Improved InnoDB rw_lock patch

… are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard InnoDBGoogle smpfixYasufumi rw_lock 19700… reason why we did not include InnoDB smp fixes in our build yet. Fortunately we get fixed version of Yasufumu’s rw_locks… results comparable with Google’s smpfix, so we will include innodb_rw_lock into our next -percona-highperf release

Post: Announcing Percona Server for MySQL version 5.1.67-14.4

… Biveinis). Fixed the regression introduced with the fix for bug #1083058 which caused unnecessary mutex reacquisitions in adaptive flushing. Bug fixed #1117067 (Laurynas Biveinis). InnoDB and…. Bug fixed #730173 (Laurynas Biveinis). Fixed the regular expressions used for filtering the InnoDB stats that were causing sporadic extraneous lines in mysqldumpslow output. Bug fixed

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

…. Bugs Fixed: Ported a fix from MariaDB for the upstream bug #67974, which caused server crash on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS. Bug fixed…, resulting in start up errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Time…