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

MySQL config variable max_heap_table_size.

You can control the max size of a heap table in mysql using:

MySQL config variable max_heap_table_size control the max size of a heap table in MySQL. Here is sample usage:- SET max_heap_table_size =M .

Source: https://www.onlineinterviewquestions.com/mysql-interview-questions/