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:linuxtovish...@gmail.com] > Sent: Wednesday, May 02, 2012 4:58 AM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: MySQL Crash when Open_files reach 128 > > 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 > <linuxtovish...@gmail.com>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.rei...@thelounge.net>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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
