Heap vs TempTable: Brief analysis of internal temporary table.

Date and time

• Wednesday 4 October, 14:45 – 15:25 EET (UTC+3)

Abstract

Analyze the implementation of memory storage engine of MySQL and MariaDB: heap and temptable. Compare the difference of them with different workload. And finally give some suggestions on how to use them.

Jiayu Zhou, Huawei Cloud

HUAWEI CLOUD database kernel engineer.