List:General Discussion« Previous MessageNext Message »
From:vishesh kumar Date:May 2 2012 1:03pm
Subject:Re: MySQL Crash when Open_files reach 128
View as plain text  
Sever OS is CentOS 5 and limits.conf settings is unlimited for open files .

Thanks
~Vishesh


On Wed, May 2, 2012 at 5:37 PM, LinuxInfo <linuxinfo11@stripped> wrote:

> Hello,
>
> what is the Server OS? I know on my Ubuntu Server i have config the
> /etc/limits.conf and the my.cnf
> After the modification you have to restart the Server.
>
>
>
> Am 02.05.2012 um 13:58 schrieb vishesh kumar <linuxtovishesh@stripped>:
>
> > 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
>



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