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

Thanks,
Vishesh Kumar

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