From: Reindl Harald
Date: October 31 2012 9:24pm
Subject: Re: what is stored in /var/lib/mysql_log/ ?
List-Archive: http://lists.mysql.com/mysql/228556
Message-Id: <50919712.8090103@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig6AE5692AA7AF7EB6649A3AFB"

--------------enig6AE5692AA7AF7EB6649A3AFB
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

personally i use ONLY vmware-guests for any production
servers because HA/Failover and unified managmenent and
a really easy way to resize drives for /var/log, /vbar/cache, /tmp
and hwatever mountpoint holds data - all seperated from /boot and rootfs

so it is no problem to use a own DISk for /tmp or
configure the mysql-temp-fodler to a folder on a large
enough disk

it is really simple to calculate - largest table + 50% for mysqltemp

running out of disk space is simply the result of a config mistake
or missing to watch growing data

Am 31.10.2012 22:13, schrieb Rick James:
> Oh, another issue...
>=20
> If you have your disk partitioned, and the tmpdir is pointing to a "sma=
ll" partition, you could run out of room for that reason.
>=20
> I sometimes find a tiny boot partition (not a terrible idea), plus part=
itions for /tmp, /var /usr, and maybe others.  (Or C:, D:, etc, if you ar=
e that type of person.)
>=20
> Hence, I _dislike_ splitting disks into separate filesystems.
>=20
>> -----Original Message-----
>> From: Reindl Harald [mailto:h.reindl@stripped]
>> Sent: Wednesday, October 31, 2012 11:56 AM
>> To: mysql@stripped
>> 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 t=
o
>> 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


--------------enig6AE5692AA7AF7EB6649A3AFB
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlCRlxMACgkQhmBjz394AnnAbgCdFxpn+x2u3sHsKv/8xRQXB4VT
caAAn27yA5/78U3GU0L3Yf8cJXKAKVMM
=35SV
-----END PGP SIGNATURE-----

--------------enig6AE5692AA7AF7EB6649A3AFB--