mysql架构

SQL Interface（DDL、DML，stored procedures、View、Trigger）

Archive

merge

Optimizer（Access Paths、statistics）

Parser（Query Translation、Object Privilege）

management service & utilities（Backup & Recovery ，security，replication，cluster，administration，Configuration，migration，metadata）

Connector（连接）navicat api、jdbc、.net、php、python、Perl、Rubby、Cobol

Federated

myIsam

connection poolauthentication- thread reuse- connection limits- check memory- caches

custom

memory

File System Files&LogsNTFS-NFS Redo undo Data Index Binary SAN NAS Error Query slow

bdb

cluster

Pluggable Storage Enginesmemory index & storage management

Caches & Buffer（global and engine specific caches && buffer）

InnoDb