What are HEAP tables in MySQL?

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

(Continued from previous question...)

What are HEAP tables in MySQL?

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

(Continued on next question...)

Other Job Interview Questions

• MySQL - Drawbacks to Creating Large Numbers of Tables in the Same Database
• If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
• How MySQL Stores Its Row Data and Index Data?
• What does myisamchk do?
• MySQL - Optimization Overview
• What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
• How do you offload the time/date handling to MySQL?
• How MySQL uses DNS
• What are HEAP tables in MySQL?
• Adding New User Privileges to MySQL
• More...