| 1 |
On 10/30/05, Alexander Skwar <listen@×××××××××××××××.name> wrote: |
| 2 |
> Qian Qiao schrieb: |
| 3 |
> |
| 4 |
> > Ah, I see. I was thinking that the journal is working in a similar |
| 5 |
> > fashion as the transaction logs in DBMS, seems I'm quite wrong. :) |
| 6 |
> |
| 7 |
> Well, but how does it work in a DBMS? Does a transaction |
| 8 |
> log there save you from a 'DELETE FROM table; COMMIT;'? |
| 9 |
> I mean, I suppose you could see - thanks to the transaction |
| 10 |
> log - that a 'DELETE FROM table;' was done, who did it |
| 11 |
> and when it was done. |
| 12 |
> |
| 13 |
|
| 14 |
It does, technically. The way DBMS maintains table consistancy opon |
| 15 |
failure is to re-play transactions logged. These logs are not the logs |
| 16 |
that appear in /var/log, they are maintained internally by the DBMS. |
| 17 |
|
| 18 |
-- Joe |
| 19 |
|
| 20 |
|
| 21 |
-- |
| 22 |
There are 3 kinds of people in the world: |
| 23 |
Those who can count, and those who can't. |
| 24 |
|
| 25 |
-- |
| 26 |
gentoo-user@g.o mailing list |
Archives