List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 2 2012 10:58am
Subject:Re: MySQL Crash when Open_files reach 128
View as plain text  

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
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