By "implicit temporary tables" I mean temporary tables created by queries, for example a sub query that needs to create an implicit temporary table, or a query with an ORDER BY clause that cannot use an index. And I am referring to "implicit memory tables" created using MEMORY storage engine and not the on-disk ones.
@Laurynas:
By "implicit temporary tables" I mean temporary tables created by queries, for example a sub query that needs to create an implicit temporary table, or a query with an ORDER BY clause that cannot use an index. And I am referring to "implicit memory tables" created using MEMORY storage engine and not the on-disk ones.