MySQL Storage process engine analysis (1/5)

MySQL Tutorial Storage Engine Introduction

Falcon Storage Engine

The Falcon storage engine is the storage engine that MySQL had high hopes for, mainly in the face of the Innobase company that Oracle acquired at the time, to replace a InnoDB storage engine. The Falcon engine's main driver was master Jim Starkey, who began developing in 2006 and released a beta version by 2008, and has so far not gone mainstream. In mid-2008, Falcon's main architect, Jim Starkey, announced his resignation from MySQL and joined a start-up company Nimbusdb as CEO to design and develop a tutorial on relational/semantic databases running on cloud computing. According to the current development of NoSQL market in the 2010, his choice is correct, but the result is that Falcon into an absence of leading personnel, resulting in the performance of the poor, Half-dead state.

The Falcon engine is a MySQL AB company based on Netfrastrucure's product development (Netfrastrucure company was acquired by MySQL AB), Falcon's original goal was to embed MySQL 6.0 in place of the InnoDB engine, Basically many function designs are designed according to InnoDB's goal.

Falcon is a multiple-CPU, developed with a modern hardware environment with large memory and database operational characteristics of typical Web applications, the main features include multiple versioning concurrency control, improved acid support, a B + tree index that supports prefix compression, data page compression (stored in compressed form on disk, in memory to Non-compressed form storage), group submissions, etc. In terms of functionality, there is nothing new, and the general implementation of a transaction-type storage engine must have some features (many advanced features such as multiple tablespaces, partitions, etc.), but its architecture has a lot of unique.

Some test results on the Web Falcon performance is still very bad, write speed is MyISAM 1/10 ~ 1/20,select optimization also have problems, added the index feel will also perform a full table scan. So, I finally feel Falcon is a cup of engine.

Falcon Characteristics: http://dev.mysql.com/doc/falcon/en/se-falcon-features.html

Falcon Test: http://blog.gslin.org/archives/2008/02/12/1425/

Falcon Manual: http://dev.mysql.com/doc/falcon/en/

SOLIDDB Storage Engine

The SOLIDDB storage engine is developed by solid information Technology (http://www.soliddb.com), a transactional storage engine that utilizes MVCC for implementation. It supports both pessimistic and optimistic concurrency control, which is not currently supported by other storage engines. The MySQL version of SOLIBDB includes full support for foreign keys. It is very similar in many ways to InnoDB, for example, it uses a clustered index. SOLIDDB also includes an online backup feature with no additional overhead.

Home 1 2 3 4 5 last