Re: InnoDB logfile question
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.01 this is a BDB log I think. ib_arch_log_00 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. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB logfile question
Hi Heikki, 2003 7 2 18:10Heikki 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.01 this is a BDB log I think. ib_arch_log_00 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]
Re: InnoDB logfile question
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:10Heikki 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.01 this is a BDB log I think. ib_arch_log_00 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]
Re: InnoDB logfile question
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:07Heikki Tuuri : Nils, at the lower level all mini-transactions always succeed. They all have to be logged. Regards, Heikki - Alkuperinen viesti - Lhettj: Nils Valentin [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lhetetty: 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:25Heikki 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:10Heikki 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.01 this is a BDB log I think. ib_arch_log_00 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]