From: Rick James
Date: May 2 2012 3:16pm
Subject: RE: MySQL Crash when Open_files reach 128
List-Archive: http://lists.mysql.com/mysql/227288
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1485A7DFFF@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thread_stack_size should be at least 256K  (maybe more?)

Other memory issues to check on:
   http://mysql.rjweb.org/doc.php/memory

> -----Original Message-----
> From: vishesh kumar [mailto:linuxtovishesh@stripped]
> Sent: Wednesday, May 02, 2012 4:58 AM
> To: Reindl Harald
> Cc: mysql@stripped
> Subject: Re: MySQL Crash when Open_files reach 128
>=20
> I am getting following in error log
>=20
> -----------------------------------------------------------------------
> -----------------------------------------------------------------------
> ------------------
> 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
>=20
> 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
> -----------------------------------------------------------------------
> -----------------------------------------------------------------------
> -------------------------------
>=20
> Thanks
> ~Vishesh
>=20
> On Wed, May 2, 2012 at 4:54 PM, vishesh kumar
> <linuxtovishesh@stripped>wrote:
>=20
> > 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
> >
>=20
>=20
>=20
> --
> http://linuxmantra.com