… with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump… or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide to… and Ken which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin performance…
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… 1,2 may solve your thrashing problem but also will limit innodb to be able to use only couple of CPUs efficiently… specific thoughts here? INNODB was originally written on single core CPUs. HT: Users have reported lots of InnoDB scalability problems from multicore CPU…
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 … = t1.id AND t1.stat=1 AND t2.val = 5 LIMIT 1206,18\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table… InnoDB both performs much better in this case (not surprisingly as there is a lot of primary key lookups) but its scalability…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…any performance testing going on to quantify what are the limits of different operations for different levels of concurrency, specifically around… I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… to work together to produce better talk instead. Hidden Innodb Tuning Options Innodb Storage Engine has a lot of tuning options hardcoded… you can get any additional performance. Investigating Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and some of these were…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 69 Comments
… very well, while with even just two Quad Core CPUs scalability issues can be observed on many workloads. Though this depends… a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number may…
Post: Bug fix of InnoDB scalability problem
November 14, 2006 By 13 Comments
…(without bugfix): select sql_calc_found_rows * from b limit 5; executes for 20 sec (table b contains ~…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 …
Post: Meet MySQL Performance Blog guys on MySQL Users Conference
April 14, 2008 By Leave a Comment
… (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability Limits (Peter,Vadim) And we’ll have slides for these published…
Post: Big Iron for tests anyone ?
March 20, 2008 By 10 Comments
… Users Conference is coming and with it my presentation about Innodb Scalability limits. We did bunch of tests but we surely could get…
Post: Speaking on MySQL Users Conference 2008
February 3, 2008 By 2 Comments
…. According to session schedule I’ll have one talk about Innodb Scalability Limits and another one together with Andrew Aksenoff about Sphinx. Looking…
