Percona rocks! I am thrilled that you switched to the Google rw-lock patch because that is in the InnoDB plugin and you can add value elsewhere. Is XtraDB derived from the InnoDB plugin?
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… DBQP. For 5.1: mtr-helgrind-51.patch For 5.5: mtr-helgrind-55.patch Now let’s see what kind of…: 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…
Comment: Returning to InnoDB scalability
August 10, 2006 By 42 Comments
… it, but just incase I’ll recompile with your patch. ………… | &(block->blockmutex) | buf0buf.c | 32388 | 0 | 0 | 0 | 0 | … 207890633 | 619535690 | 235717 | 196481 | 0 | | &rw_lock_list_mutex | sync0sync.c | 131581 | 0 | 0 | 0 | 0 | 0 | | rw_lock_mutexes | | 40258012646 | 50506378 | 140215245 | …
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… have not included all the InnoDB patches available. For example Google’s well-known InnoDB patch set is omitted (at least for…-ahead control, control io capacity and adaptive checkpointing. documentation InnoDB RW-lock fixes Improvements to scalability for systems with 8+ cores. documentation…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M… heap is disabled 120619 13:21:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120619 13:21:17 InnoDB: Compressed… load balancer. You can work this around using T-Proxy patches and some iptables magic for the backwards connections. However in…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… additional scalability fixes for buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M…_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size… quite better, I guess this is mostly because fixes to rw_locks and to buffer_pool mutex (in rel2). Conclusion: As read…
Comment: Yasufumi Kinoshita joins Percona
November 3, 2008 By 8 Comments
… written several patches to improve InnoDB’s scalability and has tracked down a serious bug in InnoDB-5.0.30 rw-lock implementation… creation. We are also working with Google engineers on scalability patches to InnoDB. Best regards, Heikki Tuuri Innobase Oy Oracle Corp…
Post: Development plans
September 8, 2008 By 5 Comments
… challenging. Probably next one patch we want to integrate is Google’s smp-fix or Yasufumi’s rw-locks (we are going to….html you can find links to our current binaries and patches.
Comment: XtraDB storage engine release 1.0.3-4 codename Sakura
April 15, 2009 By 9 Comments
Dimitri, Could you please try the patch lp:~percona-dev/percona-xtradb/rw-lock-fix-trial? Regards, Evgeniy
Comment: Another scalability fix in XtraDB
January 26, 2009 By 13 Comments
Vadim, Baron, thank you for noticing this. We studied the page hash mutex protection when merging the Google scalability patches. A question is if an rw-lock is better than splitting the mutex into several mutexes. Marko is studying this today. Best regards, Heikki
