Bayt.com

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 ?

MySQL SQL
user-image
Question added by Khaled Maayeh , Senior Software Automation Engineer , Q-pros
Date Posted: 2015/09/02
Upvote (0) Views (5) Followers (3) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
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.

Sharad Jaiswal

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/

Write Your Answer
More Questions Like This