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.

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

[勘误]mysql基础篇 - 执行一条 select 语句,期间发生了什么? #21

Closed
Issac-v opened this issue Jul 4, 2022 · 2 comments

Comments

@Issac-v
Copy link

Issac-v commented Jul 4, 2022

文章网址: 执行一条 select 语句,期间发生了什么?
具体错误: SQL语法树的构建应该是语法分析阶段的任务, 文中错把其归类到词法分析下

@hcldadi
Copy link

hcldadi commented Aug 1, 2022

我这也补充一个疑问,文中提到Mysql 8.0把查询缓存去掉了,但我看官方内存模型里还是有个buffer pool,也是缓存查询用的,这个是不是有误?https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html

@xiaolincoder
Copy link
Owner

@hcldadi 这里说的查询缓存是 server 层的,也就是 MySQL 8.0 版本移除的是 server 层的查询缓存,并不是 Innodb 存储引擎中的 buffer poll。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants