记录一下自己之前总结归纳的MySQL相关术语以及对应的文章,便于以后复习回顾:
- WAL / bin log / redo log(crash safe) / 两阶段提交
- undo log / MVCC / read view
- change buffer / merge
- force index(a)
- flush / innodb_io_capacity / innodb_flush_neighbors / 刷脏页
- row log / online DDL
- sort_buffer / rowid排序
- order by rand()
- 驱动表 、被驱动表
- next-key lock / Gap key
- start slave / relay log
- net_buffer / LRU算法
后续等待更新…