Re: Deleted table file behavior!
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.
Subject
Views
Written By
Posted
3667
May 01, 2012 11:17PM
1503
May 02, 2012 07:35PM
1606
May 02, 2012 10:25PM
Re: Deleted table file behavior!
1804
May 03, 2012 07:06PM
1578
May 03, 2012 10:00PM
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.