List:General Discussion« Previous MessageNext Message »
From:vishesh kumar Date:May 2 2012 11:24am
Subject:Re: MySQL Crash when Open_files reach 128
View as plain text  
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

Thread
MySQL Crash when Open_files reach 128vishesh kumar2 May
  • Re: MySQL Crash when Open_files reach 128Reindl Harald2 May
    • Re: MySQL Crash when Open_files reach 128vishesh kumar2 May
      • Re: MySQL Crash when Open_files reach 128vishesh kumar2 May
        • Re: MySQL Crash when Open_files reach 128LinuxInfo2 May
          • Re: MySQL Crash when Open_files reach 128vishesh kumar2 May
        • RE: MySQL Crash when Open_files reach 128Rick James2 May
        • Re: MySQL Crash when Open_files reach 128Todd Lyons2 May