Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL - 索引 | Freedom's Blog #81

Open
fashionzzZ opened this issue Feb 19, 2020 · 0 comments
Open

MySQL - 索引 | Freedom's Blog #81

fashionzzZ opened this issue Feb 19, 2020 · 0 comments
Labels
664fa6f048cac0e148f902ce65f23095 Gitalk

Comments

@fashionzzZ
Copy link
Owner

https://www.ultroncode.com/posts/766372316.html

索引是一种特殊的文件（InnoDB 数据表上的索引是表空间的一个组成部分），它们包含着对数据表里所有记录的引用指针。索引不是万能的，索引可以加快数据检索操作，但会使数据修改操作变慢。每修改数据记录，索引就必须刷新一次。为了在某种程度上弥补这一缺陷，许多 SQL 命令都有一个 DELAY_KEY_WRITE 项。这个选项的作用是暂时制止 MySQL 在该命令每插入一条新记录和每修改一条现有之后立刻对
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
664fa6f048cac0e148f902ce65f23095 Gitalk
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@fashionzzZ