一些关于MySql加速和优化的面试题
1. Which will be faster out of these two queries – one with OR or one with IN?
2. Where does MyISAM cache table records?
3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
4. Is InnoDB faster/better than MyISAM?
5. Is CHAR faster than VARCHAR?
6. Is VARCHAR(80) faster than VARCHAR(255)?
7. Are there performance issues when joining tables from different storage engines?
8. If I change a derived table to a view, will performance increase?
9. If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
10. Is it possible to do a FULL OUTER JOIN in MySQL?
2. Where does MyISAM cache table records?
3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
4. Is InnoDB faster/better than MyISAM?
5. Is CHAR faster than VARCHAR?
6. Is VARCHAR(80) faster than VARCHAR(255)?
7. Are there performance issues when joining tables from different storage engines?
8. If I change a derived table to a view, will performance increase?
9. If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
10. Is it possible to do a FULL OUTER JOIN in MySQL?
【一些关于MySql加速和优化的面试题】相关文章
2. mysql_pconnect()和mysql_connect()有什么区别
6. 几个MySql的面试题
7. 遇到的Mysql的面试题
8. MySQL面试题
9. MySQL面试题目集锦
10. 十一个高级MySql面试题
本文来源:https://www.mianshiwenti.com/a13454.html
进入下载页面
上一篇:遇到的Mysql的面试题
下一篇:腾讯公司的一个sql题
﹝一些关于MySql加速和优化的面试题﹞相关内容
- MYSQL基础面试题
- Tomcat Mysql datasource数据源配置
- mysql的最长数据库名,表名,字段名可以是多长
- PHP如何调用MYSQL存储过程
- PHP如何与mysql建立链接
- 说一下mysql, oracle等常见数据库的分页实现方案
- 如何写出高质量、高性能的MySQL查询
- 介绍一下Mysql的存储引擎
- 如何提高MySql的安全性
- MYSQL支持事务吗