MySQL Forums
Forum List  »  MyISAM

MySQL Internal Temporary Tables
Posted by: Michel Ávila
Date: May 27, 2010 11:39AM

Hi.

I've been doing a lot of "alter table" operations on very large MyISAM tables (more than 50.000.000 rows).
Such operations are based on internal temporary tables automaticaly generated by MySQL. It seems that the entire table is rebuild, including the modifications, and when its done successfully, the original table is replaced by the temporary one.

My question is: is there a way to know the original table of a temporary table, considering that the names are very weird and aparently not related?

I mean, right now i'm altering just one table, and its internal temporary table is "#sql-e011_51d.MYD". Is this name generated randomly or there is a rule based on the name of the original one?

Thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Internal Temporary Tables
3467
May 27, 2010 11:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.