59
【MySQL】【翻译】 MySQL 5.7 的内部临时表新特性-对唔住，我喺渣人
source link: http://blog.51cto.com/l0vesql/2087514
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
内部InnoDB临时表（可能仅仅因为是SELECT查询导致）被保存在InnoDB的ibtmp文件中，在大部分情况下，会加速临时表或者查询的速度，但是会影响到原本InnoDB内存的占用情况和原本临时表处理的逻辑
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK