# Some info about ib\_logfile0 and ib\_logfile1

**URL:** <https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637>\
**Category:** Percona XtraBackup\
**Created:** [July 24, 2014, 4:15am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637 "2014-07-24T04:15:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andro](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andro](https://forums.percona.com/u/Andro)\
**Post date:** [July 24, 2014, 4:15am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/1 "2014-07-24T04:15:31Z")

</div>

Hello everyone,

I’m new to this backup and sorry if the question is dumb. After executing the backup command:

innobackupex --user=xxxx --password=xxxxxxx /var/lib/mysql\_backup

it ended up with: innobackupex: completed OK!

so far so good, but i looked at the folder’s size and it was 355 MB , but earlier backups are 4,1 GB. When i opened them they had these two files: ib\_logfile0 and ib\_logfile1, which are missing in the new backup folder.

Can you explain me what are these and why are they missing in the new backup folder?

---

<div class="post-metadata">

**Author:** ![alaincraven](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@alaincraven](https://forums.percona.com/u/alaincraven)\
**Post date:** [July 29, 2014, 5:53am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/2 "2014-07-29T05:53:01Z")

</div>

The log files will be missing until you prepare the backup.  
The size still seems very small - do you have very large log files?

---

<div class="post-metadata">

**Author:** ![Andro](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andro](https://forums.percona.com/u/Andro)\
**Post date:** [July 29, 2014, 7:45am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/3 "2014-07-29T07:45:09Z")

</div>

This is what’s in the folder of the previous backup that was created:

4.0K backup-my.cnf  
58M ibdata1  
2.1G ib\_logfile0  
2.1G ib\_logfile1  
1.0M mysql  
212K performance\_schema  
7.1M radius  
27M xbench  
4.0K xtrabackup\_binary  
4.0K xtrabackup\_binlog\_pos\_innodb  
4.0K xtrabackup\_checkpoints  
2.0M xtrabackup\_logfile

And this is the latest:

4.0K backup-my.cnf  
59M ibdata1  
1.1M mysql  
212K performance\_schema  
260M radius  
3.7M radmin  
26M xbench  
4.0K xtrabackup\_binary  
4.0K xtrabackup\_checkpoints  
7.3M xtrabackup\_logfile

So the missing files are ib\_logfile0, ib\_logfile1 and xtrabackup\_binlog\_pos\_innodb. By logfiles, which logs do you mean exactly?  
So after preparing the backup i’ll have ib\_logfiles? But what about xtrabackup\_binlog\_pos\_innodb? In the history command I can’t find how the previous backup was created. It was over a year ago and there is no one working here from that period to ask them.

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [July 29, 2014, 3:11pm UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/4 "2014-07-29T15:11:05Z")

</div>

Percona has an easy to follow guide on taking, preparing, and restoring a full backup:

[url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.2/howtos/recipes_ibkx_local.html%5B/url%5D)

The files you are missing will be created once you run the apply-log step to prepare the backup prior to restore.

---

<div class="post-metadata">

**Author:** ![Andro](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andro](https://forums.percona.com/u/Andro)\
**Post date:** [July 30, 2014, 1:21am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/5 "2014-07-30T01:21:58Z")

</div>

I followed the guide, but it says nothing about these ib\_logfiles or I’ve missed it. Anyway, I understood when and how they are created. Thank you for the help.

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [July 30, 2014, 11:30am UTC](https://forums.percona.com/t/some-info-about-ib-logfile0-and-ib-logfile1/3637/6 "2014-07-30T11:30:34Z")

</div>

The guide is really just meant to show you how to create, prepare,and restore a backup with as little detail / complication as possible to get you going. If you are curious for more details, there is a ton of extra information in the Xtrabackup/Innobackupex documentation you could spend all day reading if interested. But that might put you to sleep at some point. 😉
