| Falcon | |
|---|---|
| Design by | Jim Starkey |
| Developed by | Sun Microsystems |
| Preview release | MySQL 6. Software design is a process of problem-solving and planning for a Software solution Jim Starkey is a database architect who developed InterBase, the first relational database to support multi-versioning, the blob column type (see The true story of A software developer is a person or organization concerned with facets of the software development process wider than design and coding a somewhat broader scope of Sun Microsystems Inc ( is a multinational vendor of Computers computer components Computer software, and Information technology services A software release is the distribution whether public or private of an initial or new and upgraded version of a Computer software product 0. 4 / February 12, 2008 |
| OS | Cross-platform |
| Genre | Database engine |
| License | GNU General Public License |
| Website | http://www.mysql.com/mysql60/ |
Falcon is a new transactional storage engine for the MySQL relational database management system. Events 1429 - English Forces under Sir John Fastolf defend a supply convoy carrying rations to the army besieging Orleans from attack by the 2008 ( MMVIII) is the current year in accordance with the Gregorian calendar, a Leap year that started on Tuesday of the Common An operating system (commonly abbreviated OS and O/S) is the software component of a Computer system that is responsible for the management and coordination In computing cross-platform (also known as multi-platform) is a term used to refer to Computer software or computing methods and concepts that are implemented Computer software can be organized into categories based on common function type or field of use A database engine is the underlying software component that a Database management system (DBMS uses to create retrieve update and delete (see CRUD (acronym A software license (or software licence in commonwealth usage is a Legal instrument governing the usage or redistribution of copyright protected software A website (alternatively web site or Web site, a back-construction from the Proper noun World Wide Web) is a collection of Web pages A database transaction is a unit of work performed against a Database management system or similar system that is treated in a coherent and reliable way independent of other A database engine is the underlying software component that a Database management system (DBMS uses to create retrieve update and delete (see CRUD (acronym MySQL is a Relational database management system (RDBMS which has more than 11 million installations A Relational database management system (RDBMS is a Database management system (DBMS that is based on the Relational model as introduced by E It is currently in the beta stage of development, being worked at in a development tree based on the MySQL 5. A software release is the distribution whether public or private of an initial or new and upgraded version of a Computer software product 2 release, called MySQL 6. 0. It is based on the Netfrastructure database engine. Netfrastructure is both a web application development and Database tool for Java and the name of the company which produces it
Architecture analysis shows 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 (supplied by Oracle) and MyISAM. InnoDB is a storage engine for MySQL, included as standard in all current Binaries distributed by MySQL AB. MyISAM is the default Storage engine for the MySQL Relational database management system. 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 efficiently all types of loads.
Architecture
The architecture of the Falcon engine consists of seven basic components:
- User tablespaces: contains the actual user data and indexes stored in a Falcon database.
- Falcon serial log: contains recently committed data changes, index changes, and transactional information. The log also handles crash recovery activities for a database.
- Page cache: memory region that holds database pages being read or written.
- System metadata: Falcon's system tablespace that holds internal information.
- Record cache: memory region that holds copies of active and uncommitted records.
- System cache: memory region that contains transaction context information, index accelerators, and system metadata.
- Worker threads: moves data from the Falcon Log into the database page cache, from the page cache to disk, and performs BLOB management. A binary large object, also known as a blob, is a collection of Binary data stored as a single entity in a Database management system.
See also
External links
- MySQL Documentation on the Falcon storage engine
- Presentation by Jim Starkey on Falcon
- Text summary of Starkey's presentation
- Slashdot news item of the open source announcement
- InnoDB vs MyISAM vs Falcon
- Falcon Design Review
- Understanding the Falcon Transaction Storage Engine - Part 1
- Understanding the Falcon Transaction Storage Engine - Part 2
Dapyx Software network: MP3 Explorer | Ebook Manager | Zenithic