… XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based… Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: Percona…of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc…
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 there… – 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 customers using multi-… 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
… it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main… the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement…. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores… crashed with full 32GB buffer_pool. There is reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0… also http://www.mysqlperformanceblog.com/2006/11/21/opening-tables-scalability/. Partially it can be fixed by recent patches by enabling…
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 … InnoDB both performs much better in this case (not surprisingly as there is a lot of primary key lookups) but its scalability…. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention…
Post: Bug fix of InnoDB scalability problem
November 14, 2006 By 13 Comments
… (I hope), but I can’t miss bug fix of my favorite bug 15815. I wrote about this problem before … 29 sec 39 sec 41 sec Great improvement! But scalablity factor is not such perfect as I’d expect, … executes 1.4 times slower. So I’d want InnoDB team continue to work on performance improvement. Anyway I …
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite… with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump… and Ken which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin…
Comment: Where to get recent MySQL version ?
January 3, 2007 By 86 Comments
… though. Now regarding what is recent – it is about of bugs fixes what defines how recent release it. Take a look…’ll see what I mean. Not to mention very serious Innodb scalability bug which was improved in this version.
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 53 Comments
… did a benchmark a while back (2 years ago using INNODB of course) under concurrency the trend of using SQL_CALC… then again this finding may have been tainted by the INNODB scalability bug you found.
