Heap vs TempTable: Brief analysis of internal temporary table.
![](https://mariadb.org/wp-content/uploads/2023/09/Zhou-1024x576.jpg)
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.
![](https://mariadb.org/wp-content/uploads/2023/09/Fest-23-Site-header.jpg)