Am 31.10.2012 17:31, schrieb Rick James: > 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; >
Hi Rick, thx for your help. I have found the root cause that was not related to immodb. It was that tmpdir was pointing to the same space. This were no problem for a long time then something happended, the system was optimizing and was running out of space causing a table corruption (why can a failed optimisation cause a table corruption ?) re, wh > 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:wha...@bfs.de] >> Sent: Sunday, October 28, 2012 2:05 PM >> To: mysql@lists.mysql.com >> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
