MySQL Forums
Forum List  »  Newbie

What are these files? #sql-XXXX_YY.MYD
Posted by: jsjensen
Date: March 15, 2005 11:24PM

I am creating an index (the only active thread) on a moderately large myisam table. I get the following `extra' files: From the looks of it, it is copying my 4 gib table and then performing an index build on a copy of the data? As to not affect reads on the original table?

What are these files \#sql-* ??


-rw-rw---- 1 8790 Mar 15 11:27 scans.frm
-rw-rw---- 1 4161631212 Mar 15 13:56 scans.MYD
-rw-rw---- 1 1864836096 Mar 15 15:05 scans.MYI
-rw-rw---- 1 8790 Mar 15 16:49 #sql-1581_11.frm
-rw-rw---- 1 4161631212 Mar 15 17:23 #sql-1581_11.MYD
-rw-rw---- 1 1832666112 Mar 15 22:21 #sql-1581_11.MYI
-rw-rw---- 1 1631846400 Mar 15 22:21 #sql-1581_11.TMD

Options: ReplyQuote


Subject
Written By
Posted
What are these files? #sql-XXXX_YY.MYD
March 15, 2005 11:24PM


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.