Falcon (storage engine) explained

Falcon
Author:Jim Starkey
Developer:Sun Microsystems
Latest Preview Version:MySQL 6.0.9
Operating System:Cross-platform
Genre:Database engine
License:GNU General Public License

Falcon is a discontinued[1] transactional storage engine being developed for the MySQL relational database management system. Development was stopped after Oracle purchased MySQL.[2] It was based on the Netfrastructure database engine. Falcon was designed to take advantage of Sun's ZFS file system.

Architecture analysis showed an interesting mixture of possible performance properties, while low level benchmarks on the first alpha release in 5.1.14-falcon showed that Falcon performed differently from both InnoDB and MyISAM.[3] [4] It did better in several tests, worse in others, with inefficient support for the MySQL LIMIT operation a limitation. Its biggest advantage though is known to be ease of use; Falcon requires minimum maintenance and designed to reconfigure itself automatically to handle all types of loads efficiently.

See also

Notes and References

  1. Web site: Oracle Discusses MySQL Database Plans .
  2. Web site: Oracle Commits to MySQL with InnoDB. 13 April 2010.
  3. Web site: Falcon Storage Engine Design Review. 2007-01-12.
  4. Web site: InnoDB vs MyISAM vs Falcon benchmarks - part 1. 2007-01-08.