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
