Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Khaled Maayeh , Senior Software Automation Engineer , Q-pros
Date Posted: 2015/09/02
Milos Nesic
by Milos Nesic , developer , freeland

SET max_heap_table_size = /number*number

Eranna PK
by Eranna PK , Java Developer , UBQ Technologies pvt ltd

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/

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.