On 10/30/05, Alexander Skwar <[EMAIL PROTECTED]> wrote: > Qian Qiao schrieb: > > > Ah, I see. I was thinking that the journal is working in a similar > > fashion as the transaction logs in DBMS, seems I'm quite wrong. :) > > Well, but how does it work in a DBMS? Does a transaction > log there save you from a 'DELETE FROM table; COMMIT;'? > I mean, I suppose you could see - thanks to the transaction > log - that a 'DELETE FROM table;' was done, who did it > and when it was done. >
It does, technically. The way DBMS maintains table consistancy opon failure is to re-play transactions logged. These logs are not the logs that appear in /var/log, they are maintained internally by the DBMS. -- Joe -- There are 3 kinds of people in the world: Those who can count, and those who can't. -- [email protected] mailing list
