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
