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?
signature.asc
Description: OpenPGP digital signature