Shulou(Shulou.com)06/01 Report--

Mysql architecture

Connection processing, authorization authentication, security

In the second layer, most of the core service functions of MySQL are in this layer, query parsing, analysis, optimization, caching and all built-in functions including encryption functions, and all cross-storage engine functions are implemented in this layer: stored procedures, triggers, views, etc.

The third layer contains the storage engine. Storage engine is responsible for the storage and extraction of data in MySQL. Each storage engine has its advantages and disadvantages. The server communicates with the storage engine through API. These interfaces shield the differences between different storage engines and make these differences transparent to the upper query process. The storage engine API contains dozens of underlying functions that users perform operations such as "start a thing" or "extract a row of records based on the primary key". A single storage engine does not parse the SQL, and different storage engines do not communicate with each other, but simply respond to requests from the upper server.

MySQL5.5 provides an api that supports thread pool plug-ins, and a small number of threads in the pool can be used to serve a large number of connections.

Locks: shared and exclusive locks, also known as read and write locks. Read locks are shared, or do not block each other. Multiple customers can read the same resource at the same time without interfering with each other. Write locks are exclusive, which means that one write lock blocks other write and read locks.

Table compression http://www.cnblogs.com/billyxp/p/3342969.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.