DBA面试题

当前位置: 面试问题网 > DBA面试题 > 一些关于MySql加速和优化的面试题

一些关于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?

【一些关于MySql加速和优化的面试题】相关文章

1. 一些关于MySql加速和优化的面试题

2. mysql_pconnect()和mysql_connect()有什么区别

3. 介绍一下如何优化MySql

4. 简单叙述一下MYSQL的优化

5. 介绍一下MYSQL常用的优化技巧

6. 几个MySql的面试题

7. 遇到的Mysql的面试题

8. MySQL面试题

9. MySQL面试题目集锦

10. 十一个高级MySql面试题

本文来源:https://www.mianshiwenti.com/a13454.html

点击展开全部

《一些关于MySql加速和优化的面试题》

将本文的Word文档下载到电脑,方便收藏和打印

推荐程度:

进入下载页面

﹝一些关于MySql加速和优化的面试题﹞相关内容

「一些关于MySql加速和优化的面试题」相关专题

其它栏目

也许您还喜欢