Thanks for response .
I didn't set any open_files limit in my.cnf .
For testing i set open_files_limit to 300 but still MySQL crashing after
128.
~Vishesh
On Wed, May 2, 2012 at 4:28 PM, Reindl Harald <h.reindl@stripped>wrote:
>
>
> 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?
>
>
--
http://linuxmantra.com
