Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread vishesh kumar
ion 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
:56:04 mysqld ended - Thanks ~Vishesh On Wed, May 2, 2012 at 4:54 PM, vishesh kumar wrote: > Thanks for response . > > I didn't set any open_files limit

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

Re: Mysql Trigger

2011-07-10 Thread vishesh kumar
Thanks for reply , but i want to do only for certain record that i will put using IF On Sun, Jul 10, 2011 at 2:42 PM, Reindl Harald wrote: > > > Am 10.07.2011 10:32, schrieb vishesh kumar: > > Hi Members > > > > Whats wrong i am doing in following create trigger

Mysql Trigger

2011-07-10 Thread vishesh kumar
Hi Members Whats wrong i am doing in following create trigger statement Create trigger test before insert on user for each row begin set New.host=upper(new.host) end Above statement giving error check sql syntax , please guide me. I want to put host field value in uppercase in