List:General Discussion« Previous MessageNext Message »
From:Rick James Date:October 31 2012 4:31pm
Subject:RE: what is stored in /var/lib/mysql_log/ ?
View as plain text  
The 2 (possibly more) iblog files are necessary for the inner workings of InnoDB.  They do not change in size.  They should not (normally) be removed or otherwise tampered with.  No useable data is stored there -- that is, they cannot be used for any form of disaster recovery.

Tunable things for InnoDB can be found in my.cnf (my.ini).  They can be viewed (mostly) via
SHOW VARIABLES LIKE 'innodb%';
Current status:
SHOW GLOBAL STATUS LIKE 'Innodb%';
SHOW ENGINE INNODB STATUS;

All of MySQL (not just InnoDB) needs "tmp" space for _some_ queries.  It is normally not be this same directory, but it is probably harmless if it is.

> -----Original Message-----
> From: walter harms [mailto:wharms@stripped]
> Sent: Sunday, October 28, 2012 2:05 PM
> To: mysql@stripped
> Subject: Re: what is stored in /var/lib/mysql_log/ ?
> 
> 
> 
> Am 28.10.2012 21:50, schrieb Reindl Harald:
> >
> >
> > Am 28.10.2012 21:29, schrieb walter harms:
> >> hi list,
> >>
> >> on my system this this directory contains ib_logfile0/ib_logfile1,
> so far no problem.
> >>
> >> From the documentation i had the impression that this is everything
> >> and the files size should not change.
> >>
> >> but it seems that immodb also uses this space for temp space, do
> they
> >> make a copy of ib_logfile here ?
> >
> > please provide a directory listing so that anybody get a clue what
> you
> > are speaking about!
> >
> 
> 
> sorry, I tend to forget that no everyone has the same configuration :(
> on my system /var/lib/mysql_log
> 
> -rw-rw---- 1 mysql mysql 268435456 Oct 28 19:20 ib_logfile0
> -rw-rw---- 1 mysql mysql 268435456 Oct 19 23:03 ib_logfile1
> 
> but i guess  i just found what is going on:
> 
>   innodb_log_group_home_dir=/var/lib/mysql_log
>  tmpdir=/var/lib/mysql_log
> 
> I was always looking for innodb related configuration/problems but i
> guess the strange files that appeared (and related problems) where
> perhaps caused by tmpdir :)
> 
> ntl, thx
> 
> re,
>  wh
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
what is stored in /var/lib/mysql_log/ ?walter harms28 Oct
  • Re: what is stored in /var/lib/mysql_log/ ?Reindl Harald28 Oct
    • Re: what is stored in /var/lib/mysql_log/ ?walter harms28 Oct
      • RE: what is stored in /var/lib/mysql_log/ ?Rick James31 Oct
        • Re: what is stored in /var/lib/mysql_log/ ?walter harms31 Oct
          • Re: what is stored in /var/lib/mysql_log/ ?Reindl Harald31 Oct
            • RE: what is stored in /var/lib/mysql_log/ ?Rick James31 Oct
              • Re: what is stored in /var/lib/mysql_log/ ?Reindl Harald31 Oct