Re: chronological order of data insert
As long as you don't delete rows, the .MYD file is written in chronological order as well.
When you delete rows, their places in the .MYD file might be reused for later inserts (or updates, if these enlarge the record).
MySQL also knows a couple of log files, which log the exact sequence of commands, if they are enabled.
And there are things like AUTO_INCREMENT or TIMESTAMP, which could track the sequence of inserts, if they are used in the table definition.
There might be other things which could affect the "traceability" of commands. I just mentioned, what jumped into my mind.
Subject
Views
Written By
Posted
5027
June 24, 2005 06:23AM
2747
June 24, 2005 06:42AM
2541
June 24, 2005 06:54AM
Re: chronological order of data insert
2874
June 24, 2005 07:21AM
2707
June 24, 2005 07:41AM
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.