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

The architecture diagram is as follows:

connection layer

thought

To solve the problem caused by frequent allocation and release of resources, a "buffer pool" is established for database connections.

principle

Put a certain number of connections in the buffer pool in advance. When you need to establish a database connection, you only need to take one out of the buffer pool and put it back after using it.

role

Perform authentication, thread reuse, connection restrictions, memory checking, data caching; manage user connections, thread processing and other requirements that require caching.

SQL layer

01). Manage Services and Tool Components

Manage databases in terms of security, replication, clustering, management, configuration, migration, and metadata for backup and recovery

02).SQL Interface Component

Operation and management of DML, DDL, stored procedures, views, triggers, etc.; user SQL command interface

03). parser component

Validating and parsing SQL commands

04). Query Optimizer Component

Optimize SQL statement queries

Select, project, and connect

05). Caches and buffers

Consisting of a series of small caches. Such as table cache, record cache, key cache, permission cache, etc.

plug-in storage engine

MySQL's storage engine is plug-in. It is based on an abstract interface of the file access layer provided by MySQL AB.

Customize a file access mechanism called a storage engine

01).MyISAM

It has fast query speed, good index optimization and data compression technology. But it doesn't support transactions.

02).InnoDB

It supports transactions, provides row-level locking, and is widely used.

03).BDB

BDB is no longer supported from the ground up

04).Memory

Suitable for storing temporary data

05).Archive

Suitable for storing historical data

physical file layer

01). supported file types

EXT3、EXT4、NTFS、NFS

02). file content

data file

log file

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.