Error-"Converting HEAP to MyIsam"

[jonethen]

Hi folks,
Executing a query on an InnoDB table and follow it with MySQLAdministrator, I see a message "Converting HEAP to MyIsam". What is the reason for MySql to convert "Heap to MyIsam" table?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

It seems like MySQL creates a temporary table for intermediate results of the query, and temporary table would grow too big to be kept in memory. Ensure with SHOW CREATE TABLE that the table actually is in InnoDB format. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --