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 can… And for other workloads new rw_locks show results comparable with Google’s smpfix, so we will include innodb_rw_lock into our next -percona…
Post: Percona build7 with latest patches
November 14, 2008 By 26 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…_mutex_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 Kinoshita…
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…_mutex_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 Kinoshita…
Post: 5.0.87-build20 Percona binaries
November 18, 2009 By 3 Comments
… 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 be compatible with RedHat…-dev group. For support, commercial and sponsorship inquiries contact Percona. innodb_rw_lock.patch
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_hashed_memory.patch split_buf_pool_mutex_fixed_optimistic_safe.patch innodb_rw_lock.patch
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 also…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…. We have not included all the InnoDB patches available. For example Google’s well-known InnoDB patch set is omitted (at least …InnoDB RW-lock fixes Improvements to scalability for systems with 8+ cores. documentation Buffer pool fixes Improvements of buffer_pool scalability. documentation innodb_…
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… it is hard to say anything about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while…
Comment: Improved InnoDB rw_lock patch
November 19, 2008 By 3 Comments
… Yasufumi for his innodb_rw_lock patch. I was close to loosing my trust in FreeBSD before applying the patch. Running our 7G InnoDB database on… 8core Box we had severe context-switching problems without the patch. After applying it it works like a charm. Close to…
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…pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular…array_reserve_cell (sync0arr.c:366) ==9090== by 0x6BC917F: rw_lock_s_lock_spin (sync0rw.c:415) ==9090== by 0x6B6905A:…
