List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:July 2 2003 9:10am
Subject:Re: InnoDB logfile question
View as plain text  
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.

> 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


Thread
InnoDB logfile questionNils Valentin2 Jul
Re: InnoDB logfile questionHeikki Tuuri2 Jul
  • Re: InnoDB logfile questionNils Valentin2 Jul
Re: InnoDB logfile questionHeikki Tuuri2 Jul
Re: InnoDB logfile questionNils Valentin3 Jul