… | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics…_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | | | innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0 | Yasufumi…
Post: Improved InnoDB rw_lock patch
October 20, 2008 By 3 Comments
There is patch from Google to improve SMP performance , but for some workloads … did not include InnoDB smp fixes in our build yet. Fortunately we get fixed version of Yasufumu’s rw_locks and you… other workloads new rw_locks show results comparable with Google’s smpfix, so we will include innodb_rw_lock into our next -percona…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… see there is some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is not very… testing as this format will not be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data… is hard to say anything about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics…_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | | | innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0 | Yasufumi…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… patch gives you the opportunity to see those values for a given query. # InnoDB_IO_r_ops: 19 InnoDB_IO_r_bytes: 311296 InnoDB_IO_r_wait: 0.382176 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.067538 # InnoDB_pages_distinct: 20 InnoDB…: 19 InnoDB_IO_r_bytes: 311296 InnoDB_IO_r_wait: 0.382176 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.067538 # InnoDB_pages_distinct…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… 5.1: mtr-helgrind-51.patch For 5.5: mtr-helgrind-55.patch Now let’s see what…-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular…error: lock order violation, thus a potential deadlock. The locks in question are LOCK_global_system_variables and LOCK_system…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… other areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully the patches he has provided… so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches to make Innodb IO scheduling more aggressive which is important for serious IO subsystems. Many Innodb IO settings were…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… has Patches which let you to try it out. Q14: Are there any plans to fix Innodb so it unlocks (or never locks… way InnoDB does the buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s…. Latest patches of Yasufumi Kinoshita attained very nice scaling up to 8 or 16 cores. These patches are not in the official InnoDB…
Comment: Percona build7 with latest patches
December 2, 2008 By 26 Comments
…_patches.patch microslow_innodb.patch userstatv2.patch microsec_process.patch innodb_io_patches.patch mirror_binlog.patch mysqld_safe_syslog.patch innodb_locks_held.patch innodb_show_bp.patch innodb_check_fragmentation.patch innodb_io_pattern.patch innodb_fsync_source.patch innodb_show…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
…-write locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches to… problems in InnoDB rw-lock implementations and in buffer_pool mutex contention, which alredy fixed in percona-patches ( and in XtraDB and InnoDB-plugin…
