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

Question Posted / amith

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

Answer / amith

MySQL config variable max_heap_table_size.

Is This Answer Correct ?

12 Yes

0 No

More MySQL Interview Questions

How do I exit mysql?

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

What is the difference between timestamp and datetime in mysql?

How do I backup mysql database on linux?

How do I copy a table in mysql?

What does mysql flush tables do?

Which storage engine is best in mysql?

How to decrement dates by 1 in mysql?

What language does mysql use?

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

Write a query to fetch common records between two tables using mysql?

In which language mysql has been written?

For more MySQL Interview Questions Click Here