From: Reindl Harald
Date: May 2 2012 10:58am
Subject: Re: MySQL Crash when Open_files reach 128
List-Archive: http://lists.mysql.com/mysql/227279
Message-Id: <4FA11363.7070606@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigC2C83EE4D455BA80102813D1"

--------------enigC2C83EE4D455BA80102813D1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 02.05.2012 12:52, schrieb vishesh kumar:
> Hi Members,
>=20
> I am using MySQL  5.0.67 . I am facing the problem of MySQL crashing
> problem . MySQL Crash after every a few minutes . On investigation i
> noticed that when the  Open_files status variable reach 128 MySQL Crash=
 and
> i get following error message
> -----------------------------------------------------------------------=
-------------------------------------------------------------------------=
-----------------------------------------
> ERROR 2006 (HY000): MySQL server has gone away
> No connection. Trying to reconnect...
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> -----------------------------------------------------------------------=
-------------------------------------------------------------------------=
--------------------------------------------
>=20
> Can  anyone guide me how can get out of this serious problem .
>=20
> Note : I checked OS open file limit via ulimit command and its saying
> Unlimited

did you adjust "open-files-limit" in /etc/my.cnf?
what OS which has a really old mysql-version?


--------------enigC2C83EE4D455BA80102813D1
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://enigmail.mozdev.org/

iEYEARECAAYFAk+hE2MACgkQhmBjz394AnlfpQCfQtMqf1czh0HopRUiPPwjIusT
wUEAnjFbOxrRt0VWUaBGSrtbCuJ/upi5
=G1tE
-----END PGP SIGNATURE-----

--------------enigC2C83EE4D455BA80102813D1--