… engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A… the Drizzle project participates in the conference. Percona runs Percona Performance Conference as a free event going concurrently with the conference…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison…-5.1-falcon for Falcon (Please note this is a first release of Falcon and it is still in alpha stage and performance parameters… to Falcon‘s way of key access Falcon cannot handle LIMIT properly and that is why we see bad performance. We hope the performance…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… index structure for such data distribution but good enough for performance gotcha illustration purposes. The benchmark shows following results for MyISAM… 4 116 8 142 16 164 As you can see Falcon perform extremely poorly when single query executed being 1/3rd of… of threads increase. The interesting thing is it shows best performance at 16 threads, showing 50% gain from 4 threads – which…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… I do, and this can be only checked by comparing performance with your own optimized settings and one database engine would… are great. Huge indexes is where large portion of Innodb performance problems come however. We should however see how “compact” they… ranges with Innodb you will need to perform just couple of page reads, with Falcon if rows were inserted in different times…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
December 22, 2007 By 117 Comments
[...] InnoDB vs MyISAM vs Falcon benchmarks – part 1 Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. [...]
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… would require a lock, which is unthinkable from a performance perspective. So Falcon keeps a cheap (but, alas, inaccurate) tally of record… phase index retrievals is one you identified in your performance study – bad performance in the “limit†case, particularly on indexes… might be a good thing to add, assuming that the performance is acceptable. Only committed changes go to the disk Thereâ…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… because Falcon is in aggressive development. Due to very different concepts both in terms of performance properties and transaction implementation details Falcon is… close architecture and applications may be easy to port if performance will be adequate. Solid also has clustering by primary key…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
… required to fetch/modify row data) which can dramatically improve performance for certain on disk temporary tables (both implicit and explicit… MVCC and row level locks functionally close to Innodb or Falcon. Though many internal architecture decisions are different from either. What… in practice. I will not say anything about performance of Maria because performance is not the main goal of this release and…
Comment: Countless storage engines
May 5, 2007 By 6 Comments
… you don’t need your data clustered you could use Falcon with a large page and row cache and benefit from… many records in memory with falcon than innodb then you could see a large improvement in performance in most common cases where you’re disk bound on reads. At this point really falcon is a…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and graphs. It highlights two things. (1) Falcon… 11 months of work (2) MyISAM toasts InnoDB in read performance is a myth. InnoDB rules for now with low concurrency…
