Uups must have forgotten to copy the list ;-) Thanks Heikki,
Also I dont fully understand the resulting context yet, I appreciate the reply. Best regards Nils Valentin Tokyo/Japan 2003年 7月 3日 木曜日 00:07、Heikki Tuuri さんは書きました: > Nils, > > at the lower level all mini-transactions always succeed. They all have to > be logged. > > Regards, > > Heikki > > ----- Alkuperäinen viesti ----- > Lähettäjä: "Nils Valentin" <[EMAIL PROTECTED]> > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> > Lähetetty: Wednesday, July 02, 2003 1:39 PM > Aihe: Re: InnoDB logfile question > > > Hi Heikki, > > I trust your info. However, I am currently waiting for > MySQL Transactions and Replication Handbook ISBN: 1861008384 > http://www.amazon.com/exec/obidos/ASIN/1861008384/103-2494567-5987851 > > to be publised, which hopefully contains similar and newer information. > > Wouldn't it make sense not to log unsuccessful requests ? > Isn't that useless overhead ? > > Best regards > > Nils Valentin > Tokyo/Japan > > 2003年 7月 2日 水曜日 19:25、Heikki Tuuri さんは書きました: > > 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" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > 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"" <[EMAIL PROTECTED]> > > > 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: [EMAIL PROTECTED] > > > > URL: http://www.knowd.co.jp > > > > Personal URL: http://www.knowd.co.jp/staff/nils > > > > -- > > --- > > Valentin Nils > > Internet Technology > > > > E-Mail: [EMAIL PROTECTED] > > URL: http://www.knowd.co.jp > > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]