Falcon
has been specially developed for systems
that are able to support larger memory architectures and
multi-threaded or multi-core CPU environments. Most 64-bit
architectures are ideal platforms for the Falcon
engine, where there is a larger available memory space and 2-, 4- or
8-core CPUs available. It can also be deployed within a standard
32-bit environment.
The Falcon
storage engine is designed to work
within high-traffic transactional applications. It supports a number
of key features that make this possible:
Multi Version Concurrency Control (MVCC) enables records and tables to be updated without the overhead associated with row-level locking mechanisms. The MVCC implementation does not use two-phase locking and virtually eliminates the need to lock tables or rows during the update process.
Flexible locking, including flexible locking levels and smart deadlock detection keep data protected and transactions and operations flowing at full speed.
Optimized for modern CPUs and environments to support multiple threads allowing multiple transactions and fast transaction handling.
Transaction-safe (fully ACID-compliant) and able to handle multiple concurrent transactions.
Serial Log provides high performance and recovery capabilities without sacrificing performance.
Advanced B-Tree indexes.
Data compression stores the information on disk in a compressed format, compressing and decompressing data on the fly. The result is in smaller and more efficient physical data sizes.
Intelligent disk management automatically manages data files and extensions. Space within log and data files is automatically reclaimed and reused.
Data and index caching provides quick access to data without the requirement to load index data from disk.
Implicit savepoints ensure data integrity during transactions.
You can test out the Falcon
storage engine using
the MySQL Query Browser.