“This is the 21st day of my participation in the Gwen Challenge.

MySQL is a piece of the world as we back-end, for the operation of the database is necessary for us, this issue, we can benchmark MySQL in the database we parse;

MySQL is mainly oriented to project storage. It is easy to say that in our current life, all information is to be stored, and the storage place is CALLED DB, database, for example, our commonly used software, meituan, Ali some, the basic is still MySQL, and there may be big data technology. But MySQL is still commonly used.

The structure of the MySQL


These include interfaces, interpreters, parsers, queries, administrators, primary keys, and most importantly, storage engines, and finally tables and logs

In fact, the data display in the table — query is an essential function,

Our daily data is basically a query operation, you get the information is updated, query. MySQL is a select operation for a database;


MySQL storage engine

MySQL storage engines are divided into two types:

It is divided into InnoDB and MyISAM two storage engines

1. The default is InnoDB–> mainly for high concurrency, write operation or read operation performance is different; Benefits: Row locks


InnoDB – > characteristics

Support transactions -> strong consistency

Row level-locking

Support high concurrency –> Lock rows support foreign keys

You can cache data and indexes for data – it takes up a lot of memory

MyISAM features:

Table locks, not suitable for high concurrency,

The main foreign key

Transactions are not supported;


From what has been discussed above

MyISAM is mainly used for read operations, the performance requires fast query, (order lookup -> historical order – (can use MyISAM storage engine)) InnoDB represents high concurrent write operations can read and write operations;

The storage engine

Alibaba or Taobao database storage engine, the basis is MySQL innoDB

Modify query optimizer in xtraDb, data engine, etc.

Luca message

For MySQL storage mechanism, we this period is for the MySQL engine, next period we mainly for MySQL slow query index collation. Give it a thumbs up. Good night, everybody