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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]