List:General Discussion« Previous MessageNext Message »
From:vishesh kumar Date:May 2 2012 11:58am
Subject:Re: MySQL Crash when Open_files reach 128
View as plain text  
I am getting following in error log

----------------------------------------------------------------------------------------------------------------------------------------------------------------
120502 07:52:05  mysqld started
120502  7:52:05 [Warning] Asked for 196608 thread stack, but got 126976
120502  7:52:05  InnoDB: Started; log sequence number 0 479249
120502  7:52:05 [Note] /usr/local/mysql-5.0.67/bin/mysqld: ready for
connecti.
Version: '5.0.67-community'  socket: '/tmp/mysql.sock'  port: 3306  MySQL
Comity Edition (GPL)
120502  7:56:01 [Note] /usr/local/mysql-5.0.67/bin/mysqld: Normal shutdown

120502  7:56:03  InnoDB: Starting shutdown...
120502  7:56:04  InnoDB: Shutdown completed; log sequence number 0 479249
120502  7:56:04 [Note] /usr/local/mysql-5.0.67/bin/mysqld: Shutdown complete
120502 07:56:04  mysqld ended
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks
~Vishesh

On Wed, May 2, 2012 at 4:54 PM, vishesh kumar <linuxtovishesh@stripped>wrote:

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



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