…look on InnoDB mutex (schematic for simplification): spin_loop: for (i=0; i< innodb_spin_locks;i++) if (mutex_try_lock()) return; // success // we are here if spin loop…array. We have reports from partners that this patch increase scalability on Solaris/Opteron boxes dramatically – so you can test it…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…24 threads, which is almost perfect scalability. So there are workloads where the…array_wait_event,rw_lock_s_lock_spin,pfs_rw_lock_s_lock_fu nc,btr_…event,mutex_spin_wait,mutex_enter_func,pfs_mute x_enter_func,buf_page_get_mutex…lot worse in this workload and innodb_adaptive_hash_index_partitions=16 …
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… thus showing a bit better scalability. MySQL 5.1 plugin (compiled … be recognized by older Innodb versions. Note: These are … CPU efficiency. The RW-Lock patch is best in …2 cases when waiting on mutexes and other synchronization objects -…you may be waiting by spinning on the spinlock wasting …
