Maximum size of HEAP table can be controlled by MySQL config variable called max_heap_table_size.
Tag: Heap
What are the different types of tables in MySQL?
Total 5 types of tables are present in mysql as per following.
- MyISAM
- Heap
- Merge
- InnoDB
- ISAM
MyISAM is the default storage engine as of MySQL .