MySQL Storage process engine analysis (1/5)

Source: Internet
Author: User
Tags mysql tutorial mysql version

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
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.