I created an HEAP table and a traditional MyISAM table with the same fields on both of them.
One software writes into the HEAP table, then periodically transfers its content to the MyISAM table.
It works pretty good for a while then I get one error while trying to do a select over both of them using an sql view.
The error is: Incorrect key file for table '/tmp/#sql_6ae0_0.MYI'; try to repair it
To fix I have to drop the table and create it again.
Mysql 5 on Linux.