… joins Thread pooling and a segmented key cache for improved scalability That’s really just a sampling. A good starting point….5 release. This should help MariaDB be faster and more scalable, as well as adding a lot of nice features like…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… to let them know the fix is now out for Innodb scalability bug and they can rerun the test to see if… – version gap is too large to only map it to Innodb scalability patch. 2) Speedup for 5.0.32 for large number… tps. 4) The bad news are – we still have massive scalability drop with increasing concurrency – going from 10 to 20 concurrent…
Post: Returning to InnoDB scalability
July 28, 2006 By 42 Comments
I’m again returning to InnoDB scalability and related bug #15815 as it hurts many users and … with “buffer pool” mutex, which protects innodb_buffer_pool. In details, for each scanned row InnoDB calls block_get / block_release functions… 240/11 ~= 21 times, and if before we had negative scalability, currently scalabilty factor is 2.9 (the result with 4…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of them are Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes in…. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM … in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we figured… InnoDB both performs much better in this case (not surprisingly as there is a lot of primary key lookups) but its scalability…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as the…. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… do you assess current state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in my opinion is ‘mediocre… specific thoughts here? INNODB was originally written on single core CPUs. HT: Users have reported lots of InnoDB scalability problems from multicore CPU…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates…_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_extra_rsegments…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… very well, while with even just two Quad Core CPUs scalability issues can be observed on many workloads. Though this depends… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… on a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual…
