How do you control the max size of a HEAP table?

Maximum size of HEAP table can be controlled by MySQL config variable called max_heap_table_size.

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 .