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

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

MySQL config variable max_heap_table_size.

(Continued on next question...)

Other Job Interview Questions

• What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
• On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?
• How do you change a password for an existing user via mysqladmin?
• Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP.
• On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?
• How do you control the max size of a HEAP table?
• MySQL - Replication Implementation Overview
• General Information About MySQL
• MySQL - Speed of INSERT Queries
• What does tee command do in MySQL?
• More...