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

Title index

Trace back to the cause

Software structure

Document classification

Summary and analysis

Trace back to the cause

The mention of the data system makes people think about it for a long time: "the reason why we cannot know the true face of Mount Lushan is because we are in the middle of this mountain." if you look at this mountain, you may be able to see the majestic appearance of that mountain. In order to understand the database mountain, look at one step at a time and climb that mountain.

Software structure

The database system software system calls itself an ecosystem of data storage, so it is similar to a complete operating system, with complete ecosystem nodes such as different engines, connection interfaces, management systems, threads, and so on. For details, please refer to the following official structure diagram:

Figure 1-1 mysql database system structure diagram

It can be seen from the diagram that the data system is mainly composed of Connectors, Connection pool, Management Services, Utillties, SQL interface, Parser, Optimizer, Caches&Buffers and Pluggable Storage Engines.

Connectors: it is a component to connect to the database. Different development languages and different application scenarios use different database connection management tools. Its main purpose is to connect to the login management database.

Connection Pool: as can be seen from the figure, there are various sub-functions in the components of the thread pool, as shown below:

Authentication: client authentication function

Thread Reuse: thread reuse function. When a thread finishes processing a request, it will not destroy the thread, but will transfer it to the idle thread pool for processing other requests.

Connetion limits: connection limit, which is determined by the number of threads in the thread pool

Check Memory: memory resource detection.

Management Services & Utillties: server management such as backup, backup recovery, cluster configuration and other related configuration files

SQL interface:

Interface function of SQL statements such as DML,DDL,Stored Procedures Views,Triggers

Parser: parser, the SQL statement queries the authorized permissions in the interpreter

Optimizer: optimize the SQL statement to query the path

Storage Engines: different storage engines, inconsistent storage methods and storage structures

File system: the file system in which the file is stored

File & logs: information about file storage and log files, such as Redo, Undo, Data, Index, Binary, Error, Query and Slow

Document classification

Data files are basically divided into two categories: data files and log files.

Data files: database files and index files

Log files: redo log, undo log, binary log, error log, query log, slow query log and relay log

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.