Hi Thanks, Where can i find query log for previous one,or i have to do some config in my.ini file, please let me know, Thanks Abhi
-----Original Message----- From: Darryle [mailto:dstepli...@gmail.com] Sent: 08 May 2012 19:42 To: abhishek jain Cc: <mysql@lists.mysql.com> Subject: Re: One table gets locked by itself Chech your query log for queries hitting that tables. Myisam tables dont have row level locking. There is probably a slow query somewhere. Sent from my iPhone On May 8, 2012, at 10:04 AM, "abhishek jain" <abhishek.netj...@gmail.com> wrote: > Hi > > I am facing a strange problem, from the last few days in one of my > projects in production, i find that one of my table fails to retrieve > or insert records, > > I think it gets locked somehow, certainly my code doesn't have code to > do so explicitly. All / rest of tables are fine, only one table creates problem. > All is well after i restart mysqld. > > > > Dont know what to check! > > > > Details are: > > Mysqld version: 5.0.x > > Linux - Centos 5 > > Table : MyISAM > > > > Please help me asap, > > Thanks, > > Abhi > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql