1 MySQL Overview

Directory:

1. Brief description
2. History
3. Similar Products
4. Advantages and Disadvantages
5. mysql Storage engine
6. mysql Architecture

1. Brief description
MySQL is a relational database management system. Its small size, fast speed, development of source code, the use of low-cost, generally small and medium-sized web site development have chosen MySQL as a site database.
Linux as the operating system, Apache as a Web server, MySQL as a database, PHP as a server-side script interpreter, because these four software are open source, can easily establish a stable, free website system, known as the "LAMP" combination of the industry.
　　
2. History
Sweden MySQL AB Development (AB is the Swedish company abbreviation), 2008 was acquired by Sun, 2009 Sun was acquired by Oracle. MySQL currently belongs to Oracle Corporation.

3. Similar Products
General-Mainstream relational database Mysql,oracle,sql Server, db2,postgresql,sybase

4. Advantages and Disadvantages

Advantages:

1. Data Warehouse supporting 50 million records
2. Adapt to all platforms
3. is open source software, version update faster
4. Excellent performance
5. Low price

Disadvantages:

1. Lack of some storage program functions, such as MyISAM engine support switching function

5. mysql Storage engine

One important feature of MySQL that differs from other database systems is the support for the plug-in storage engine.
The storage engine is how to store the data, how to index the stored data, and how to update and query the data.

The MySQL storage engine mainly includes:

1. MyISAM. The default database engine before Mysql5.0 is most commonly used. Has a higher insert, query speed, but does not support transactions.
2. InnoDB. The preferred engine for transactional databases, supports acid transactions, supports row-level locking, and MySQL 5.5 becomes the default database engine.
3. BDB. (It's good to know that this is the concept)
4. Memory.
5. Merge.
6. Archive.

(After MySQL installation, enter show engines; You can view the storage engine type of the database, which is described in the follow-up guidance for this series. ）

　　　　

6. mysql architecture [2] (current understanding is good)

1. mysql Logic architecture

　　　　

2. mysql Architecture

Reference:
[1] http://blog.sina.com.cn/s/blog_4c646b600100er19.html
[2] http://blog.csdn.net/hguisu/article/details/7106342

1 MySQL Overview