Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size. Post navigation What does myisamchk do? What is the difference between MyISAM Static and MyISAM Dynamic?