Not really. If its a deadlock , they all are victims. (E.g. mutex wait) Or a long running query (sending data) might be the guy.
Claudio On May 8, 2012 7:31 PM, "Rick James" <rja...@yahoo-inc.com> wrote: > Also,... If it happens again, do SHOW FULL PROCESSLIST while it is > happening. Usually the non-"Locked" entry is the villain. > > > > -----Original Message----- > > From: Darryle Steplight [mailto:dstepli...@gmail.com] > > Sent: Tuesday, May 08, 2012 7:32 AM > > To: abhishek jain > > Cc: mysql@lists.mysql.com > > Subject: Re: One table gets locked by itself > > > > In your my.conf or configuration file look for an attribute that says > > "LOG_SLOW_QUERIES " , that should point to the path of your slow query > > log. > > > > On Tue, May 8, 2012 at 10:19 AM, abhishek jain > > <abhishek.netj...@gmail.com> wrote: > > > 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 > > >> > > >> > > >> > > > > > > > > > > > -- > > ---------------------------------------------- > > "May the Source be with you." > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
