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 的一些问题 #82

Open

JianmingXia opened this issue Mar 3, 2020 · 0 comments

JianmingXia commented Mar 3, 2020

count rows：记录行数 MyISAM 只在没有 where 条件下才快，因为总行数在 MyISAM 被保存了一份，有筛选条件下差不太多
MySQL 5.6 起 InnoDB 已支持全文索引了

在无特殊情况下还是使用 InnoDB 比较合适，毕竟 MySQL 5.5 起默认引擎已经是 InnoDB 了。有特殊需求时，我想以开发者的能力，应该能选择合适的引擎。😊

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment