- 博客(6)
- 收藏
- 关注
RSS订阅原创 InnoDB 体系结构
InnoDB ArchitectureThe following diagram shows in-memory and on-disk structures that comprise the InnoDB storage engine architecture.Figure InnoDB ArchitectureReferencehttps://dev.mysql.com/doc/r...
2019-06-04 15:45:20
398
转载 innodb_flush_log_at_trx_commit
innodb_flush_log_at_trx_commitPropertyValueCommand-Line Format–innodb-flush-log-at-trx-commit=#System Variableinnodb_flush_log_at_trx_commitScopeGlobalDynamicYesSET_VAR Hint...
2019-06-04 15:39:36
291
转载 GRANT General Overview
GRANT General OverviewThe GRANT statement enables system administrators to grant privileges and roles, which can be granted to user accounts and roles. These syntax restrictions apply: GRANT cann...
2019-06-02 17:53:19
134
转载 Innodb Insert Buffer
insert buffer 是innodb里面一个非常有用的特性，看名字像是内存里面的某一块区域，实际上它是磁盘上面物理页的组成部分。insert buffer 插入过程：1、判断插入的聚集索引是否在内存中，如果有，就直接插入；2、若不存在，就先放入一个insert buffer对象中；3、以一定的频率和情况进行insert buffer和辅助索引叶子节点的merge操作；insert ...
2019-04-27 12:35:15
611
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人