Nils,
InnoDB writes to ib_logfiles all tablespace modifying operations (=
mini-transactions), whether they belong to a successful or an unsuccessful
transaction. In crash recovery we redo everything, then roll back based on
undo logs inside the tablespace.
The best reference is Gray and Reuter: Transaction Processing, published
around 1992.
Regards,
Heikki
----- Original Message -----
From: "Nils Valentin" <nils@stripped>
To: "Heikki Tuuri" <Heikki.Tuuri@stripped>; <mysql@stripped>
Sent: Wednesday, July 02, 2003 12:34 PM
Subject: Re: InnoDB logfile question
Hi Heikki,
2003年 7月 2日 水曜日 18:10、Heikki Tuuri さんは書きました:
> Nils,
>
> ----- Original Message -----
> From: ""Nils Valentin"" <nils@stripped>
> Newsgroups: mailing.database.mysql
> Sent: Wednesday, July 02, 2003 12:04 PM
> Subject: InnoDB logfile question
>
> > Hello Heikki & other Mysql Fans ;-);
> >
> > Does anybody know which requests or data the below logfils actually keep
>
> ??
>
> > If I understood correct than they are all in binary format (not readable
>
> in a
>
> > text editor.
> >
> > log.0000000001
>
> this is a BDB log I think.
>
> > ib_arch_log_0000000000
>
> InnoDB archived log which is produced in log file creation. Not needed for
> anything, just a relic from the past.
>
> > ib_logfile0
> > ib_logfile1
>
> These are the InnoDB redo logs it uses in crash recovery. It writes
> circularly to these files.
Do I assume correctly that it writes into this files
a) all successful transactions (requests, status A and B - before ad after
the
request)
b) nothing else ??
Best regards
Nils Valentin
Tokyo/Japan
>
> > Unfortunately I was unable to to find sufficient info here
> > http://www.innodb.com/ibman.html.
> >
> > Best regards
> >
> > --
> > ---
> > Valentin Nils
>
> Regards,
>
> Heikki
>
> > Internet Technology
> >
> > E-Mail: nils@stripped
> > URL: http://www.knowd.co.jp
> > Personal URL: http://www.knowd.co.jp/staff/nils
--
---
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
