From: walter harms
Date: October 28 2012 9:05pm
Subject: Re: what is stored in /var/lib/mysql_log/ ?
List-Archive: http://lists.mysql.com/mysql/228509
Message-Id: <508D9E06.5090904@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit



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