Am 02.05.2012 12:52, schrieb vishesh kumar:
> Hi Members,
>
> 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)
>
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Can anyone guide me how can get out of this serious problem .
>
> 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?
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
