逻辑架构
逻辑结构剖析
MySQL服务器处理客户端请求
Connectors:
MySQL服务器之外的 客户端程序;
Management Service & Utilities:
基础服务组件;
Connection Pool:
连接池(提供多个用于客户端与MySQL服务器交互的线程)
SQL Interface:
SQL接口(接收SQL指令、返回执行结果)
Parser:
SQL解析器(语法解析、语义解析、生成语法树)
Optimizer:
SQL优化器(核心组件)
Caches & Buffers:
缓存(以k-v缓存查询结果,如果执行的SQL与之前的完全一样,直接返回缓存数据)
Pluggable Storage Engines:
插件式存储引擎(与OS的文件系统交互)
File System:
File & Logs:
MySQL日志文件;
处理客户端请求流程
Connectors -> Connection Pool -> SQL Interface -> Caches & Buffers => 有缓存 -> SQL Interface -> Connection Pool -> Connectors
=> 无缓存 -> Parser -> Optimizer -> Pluggable Storage Engines -> File System
-> Pluggable Storage Engines -> Caches & Buffers
-> SQL Interface -> Connection Pool -> Connectors
Connectors
![](/i/l/?n=22&i=blog/1248432/202211/1248432-20221103151903022-121593363.png)
逻辑架构3层-连接层
逻辑架构3层-服务层
逻辑结构3层-引擎层
存储层
标签:逻辑,架构,MySQL,---,Connectors,SQL,Interface,Pool From: https://www.cnblogs.com/anpeiyong/p/16854748.html