Oh, another issue... If you have your disk partitioned, and the tmpdir is pointing to a "small" partition, you could run out of room for that reason.
I sometimes find a tiny boot partition (not a terrible idea), plus partitions for /tmp, /var /usr, and maybe others. (Or C:, D:, etc, if you are that type of person.) Hence, I _dislike_ splitting disks into separate filesystems. > -----Original Message----- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Wednesday, October 31, 2012 11:56 AM > To: mysql@lists.mysql.com > Subject: Re: what is stored in /var/lib/mysql_log/ ? > > > > Am 31.10.2012 19:47, schrieb walter harms: > > 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 ?) > > because running out of disk space is a condition which is hard to test in > any combination and should never happen