mysql优化 - MySql架构与存储引擎

MySql逻辑架构

MySql逻辑架构-连接层

MySql逻辑架构-SQL处理层

MySql逻辑架构-SQL处理层

MySql逻辑架构-缓存

SHOW VARIABLES LIKE '%query_cache_type%'

开启方式：

SHOW VARIABLES LIKE '%query_cache_size%'
SET GLOBAL query_cache_size = 134217728;  //设置值必须大于40KB

SELECT * FROM USER

INSERT INTO USER SELECT * FROM USER

SELECT COUNT(1) FROM USER

SELECT * FROM USER WHERE userid ='7'

MySql逻辑架构-解析查询

MySql逻辑架构-解析查询

MySql逻辑架构-优化