Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread Todd Lyons
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar wrote: > I am getting following in error log > > > 120502 07:52:05  mysqld started > 120502

RE: MySQL Crash when Open_files reach 128

2012-05-02 Thread Rick James
> Cc: mysql@lists.mysql.com > Subject: Re: MySQL Crash when Open_files reach 128 > > I am getting following in error log > > --- > --- >

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread vishesh kumar
Sever OS is CentOS 5 and limits.conf settings is unlimited for open files . Thanks ~Vishesh On Wed, May 2, 2012 at 5:37 PM, LinuxInfo wrote: > Hello, > > what is the Server OS? I know on my Ubuntu Server i have config the > /etc/limits.conf and the my.cnf > After the modification you have to r

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread LinuxInfo
Hello, what is the Server OS? I know on my Ubuntu Server i have config the /etc/limits.conf and the my.cnf After the modification you have to restart the Server. Am 02.05.2012 um 13:58 schrieb vishesh kumar : > I am getting following in error log > >

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread vishesh kumar
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 1269

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread vishesh kumar
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 wrote: > > > Am 02.05.2012 12:52, schrieb vishesh kumar: > > Hi Members, > > > > I am using My

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread Reindl Harald
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 followin