… also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard InnoDBGoogle smpfixYasufumi rw_lock 19700.2810601.969432.44… 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: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… of InnoDB IO subsystem, such as multiple read and write threads, read-ahead control, control io capacity and adaptive checkpointing. documentation InnoDB RW-lock fixes Improvements to scalability for systems with 8+ cores. documentation Buffer pool fixes Improvements of buffer_pool scalability. documentation innodb_buffer…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular reason except…: sync_array_reserve_cell (sync0arr.c:366) ==9090== by 0x6BC917F: rw_lock_s_lock_spin (sync0rw.c:415) ==9090== by 0x6B6905A: log_checkpoint…:4504) The RW lock spin stats join the company of the buffer pool and I/O stats. ==9090== Thread #18: lock order “0xF14460…
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…_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: 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…_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: 5.0.87-build20 Percona binaries
November 18, 2009 By 3 Comments
… build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with…-dev group. For support, commercial and sponsorship inquiries contact Percona. innodb_rw_lock.patch
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read… that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because fixes to rw_locks…
Comment: Percona build7 with latest patches
December 2, 2008 By 26 Comments
…_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: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
….5, there are still workloads in which case mutex (or rw-lock) contention is a performance limiting factor, helped by ever growing… time with context switching because Innodb is not spinning too much, thus you can consider increasing innodb_sync_spin_loops to a higher number. It is worth to note fine tuning Innodb Contention with number of spin locks…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… policies. Important fixes are: – InnoDB IO threads – Adaptive checkpointing – Buffer pool mutex split – Reimplemented read-write locks Diagnostic patches. – We provide much… problems in InnoDB rw-lock implementations and in buffer_pool mutex contention, which alredy fixed in percona-patches ( and in XtraDB and InnoDB-plugin…
