… Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params: Falcon: libexec/mysqld –no-defaults –user=root –falcon_min_record_memory=1G –falcon_max_record_memory=2GB –falcon_page_cache…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… applications which are done specially for Falcon you might find those aspects positive. [-] No Spinlocks Falcon does not use Spinlocks. It has… – users mailbox, clustered by (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods, for example using… handling optimizations Jim loves BLOBs as his own child, so Falcon is optimized in Blob handling for example having direct blob…
Post: Will Falcon fly?
June 22, 2008 By 11 Comments
… Jim Starkey’s personal decision, I expected some comments about Falcon future development from MySQL / Sun side. Jim was not just… now MySQL’s calm seems stunned or indifferent to Falcon‘s destiny. Falcon has being developed for about 2.5 years, and…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… to take a time and see may be brand new Falcon (significantly updated in 6.0.2 release) handles this query… 4 116 8 142 16 164 As you can see Falcon perform extremely poorly when single query executed being 1/3rd… with 4 Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… understand implications and design choices you made. This however lives Falcon in very interesting position. For small data sets when data… memory and 10GB Innodb database which will be 7GB in Falcon (for example) and we assume working set matches database size… ie 20GB in Innodb and 14GB in falcon or 30GB in Innodb and 21GB in Falcon we can see the difference but…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… a lock, which is unthinkable from a performance perspective. So Falcon keeps a cheap (but, alas, inaccurate) tally of record space… in MVCC imposes different behaviors with regard to update conflicts. Falcon was designed to support the possibility that I could be… storage segment. The huge different from other storage engines that Falcon doesn’t materialize blobs unless the blob is referenced and…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
Interesting result of Falcon and between MyISAM and InnoDB. However I still think Falcon is helpful, since this test is carried out… in memory, so the advantage of Falcon‘s record cache will not show. BTW: Why Falcon needs an access to data beside… access in the READ_KEY_POINT_NO_DATA. I know Falcon use private in-memory caches to hold modified index entries…
Comment: Falcon Storage Engine Design Review
September 24, 2007 By 19 Comments
… trouble or be forced to rewrite them to commit often. Falcon is obviously derived from previous Jim’s work on Groton…. Guess something alike will work fine for most application over Falcon engine. BTW, one known drawback about Firebird/Interbase is its… step-way 
If found true, i think anyone experimenting with Falcon engine is better to keep an eye on Firebird/Interbase…
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… you could fit twice as many records in memory with falcon than innodb then you could see a large improvement in… you’re disk bound on reads. At this point really falcon is a good year or two out before I would…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… Commit and for sake of Repeatable Reads isolation mode. 2) Falcon. It is worth to note MySQL official marketing never position… too early to migrate and too early to say because Falcon is in aggressive development. Due to very different concepts both in terms of performance properties and transaction implementation details Falcon is unlikely to be easy drop-in replacement for Innodb…
