MySQL Forums
Forum List  »  MyISAM

Re: Deleted table file behavior!
Posted by: Rick James
Date: May 03, 2012 07:06PM

Any database will make heavy use of RAM for caching and other performance reasons.

MyISAM caches index blocks in the key_buffer. Data blocks are left for the OS to cache.

The INDEX(es) are kept in the .MYI file.
Data is kept in the .MYD file.

Are you on Unix? Of so, then a mv (rename) of a file while the file is open does not impact the connection between MySQL or the OS and the file. mv only renames the file. Even rm, while the file is open, is does not fully take effect until the file is closed. You must get your head around those tricky things; they are part of the whole picture.

You have not said what Operating system you are using, nor were you specific on how you "deleted" the file, so I can't be more specific.

Options: ReplyQuote

Written By
May 02, 2012 07:35PM
Re: Deleted table file behavior!
May 03, 2012 07:06PM

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.