… (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…
Comment: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
“Investigating Innodb Scalability Limits“, is one of the areas that I was thinking of submitting a talk on, for the people it affects, it’s a pretty big issue.
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… the values of accessed column is stored in key. Interesting InnoDB scalability is pretty bad for this query. The result with 4…_id FROM $tableName WHERE country_id = %d LIMIT 5 The previous query but with LIMIT. READ_PK_POINT_INDEX Query: SELECT id… is too hard for InnoDB even with all scalability fixes exist in 5.1.16 tree. I think InnoDB team should solve this…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… Starkey’s comments in Part 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is…. We hope the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by… WHERE country_id = %d LIMIT 5 The previous query but with LIMIT. Again the LIMIT is bad for Falcon. InnoDB is better than MyISAM…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will be optimal – will allow to get maximum compression while limiting amount of pages which do not fit in compressed space… most interesting: Further Scalability improvements Yasufumi Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which… I still see Innodb having serious scalability problems in some environments with 4+ cores so it is still important. IO Scalability patches Mark…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key lookups queries… played with queries SELECT name FROM sbtest WHERE country_id = ? LIMIT 5 against table CREATE TABLE IF NOT EXISTS sbtest ( id…:autoextend \ –innodb_buffer_pool_size=6GM \ –innodb_additional_mem_pool_size=20M \ –innodb_log_file_size=128M \ –innodb_log_files_in_group=2 \ –innodb_log…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… might end up sleeping waiting to enter the queue. The scalability problems with multiple CPUs is well known bug 15815 so… even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of threads which can be active inside Innodb…
Post: Opening Tables scalability
November 21, 2006 By 27 Comments
…serialized. Do not think however it is only Innodb problem. I’ve seen similar problems with MyISAM -… IO or network operation if you care about scalability. MySQL has same problem with key buffer but…to worry about) and also worry about possible limited performance while table cache is being warmed up…
