MySQL 6.0 is in alpha version and is available for testing. MySQL 6.0 supplies more reliability, performance, and ease-of-use enhancements, starting with the new Falcon transactional storage engine. The main features of Falcon are crash recovery, user-defined tablespaces, high-speed data caches, performance/diagnostic monitoring tables, simplified configuration, and many more.
The following features have been or are expected to be added to MySQL 6.0:
Falcontransactional storage engine.
utf32, and 4-byte
utf8. These character sets support supplementary Unicode characters; that is, characters outside the Basic Multilingual Plane (BMP).
RESTOREstatements for backup and restore operations.
INFORMATION_SCHEMAdatabase, with the addition of the
INFORMATION_SCHEMA.PARAMETERStable, and new columns added to
RESET SLAVEno longer changes replication connection parameters; previously, it reset them to the values specified on the command line.
LOCK TABLESstatement has been extended to support transactional table locks that do not commit transactions automatically. Following
LOCK TABLES ... IN SHARE MODEor
LOCK TABLES ... IN EXCLUSIVE MODE, you can access tables not mentioned in the
LOCK TABLESstatement. You can also issue
LOCK TABLESstatements that acquire transactional locks many times in succession, adding additional tables to the locked set, and without unlocking any tables that were locked previously. When using
IN SHARE MODEor
IN EXCLUSIVE MODE, tables are not unlocked until the transaction ends.Transactional locks acquired with
LOCK TABLESare released when the transaction ends, either explicitly with
ROLLBACK, or implicitly due to a statement that causes implicit commit or because the connection ends.The behavior of
LOCK TABLESremains unchanged for
WRITElocks (that is, when not using
IN SHARE MODEor
IN EXCLUSIVE MODE).
Falcon combines the world’s most popular open source database with a modern transactional engine designed especially for high-traffic, online, transactional applications and systems storing information such as pictures and scanned documents.
Falcon in MySQL Server 6.0 is a next-generation engine designed to make optimal use of modern large-memory multi-CPU/multi-core hardware. It is fully ACID, MVCC-compliant, and supports online parameters, tablespaces, automatic file extension/space reclamation, and distributed transactions.
Once a week or so we send an email with our best content. We never bug you, we just send you our latest piece of content.
If you found any value in this post, agree, disagree, or have anything to add - please do. I use comments as my #1 signal for what to write about. Read our comment policy before commenting! Comments such as "Thank you!", "Awesome!", "You're the man!" are either marked as spam or stripped from URL.