List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 8 2012 5:34pm
Subject:RE: One table gets locked by itself
View as plain text  
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" <rjames@stripped> 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:dsteplight@stripped]
> > Sent: Tuesday, May 08, 2012 7:32 AM
> > To: abhishek jain
> > Cc: mysql@stripped
> > 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.netjain@stripped> 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:dsteplight@stripped]
> > > Sent: 08 May 2012 19:42
> > > To: abhishek jain
> > > Cc: <mysql@stripped>
> > > 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.netjain@stripped>
> > > 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
>
>

Thread
One table gets locked by itselfabhishek jain8 May
  • Re: One table gets locked by itselfDarryle8 May
    • RE: One table gets locked by itselfabhishek jain8 May
      • Re: One table gets locked by itselfDarryle Steplight8 May
        • RE: One table gets locked by itselfRick James8 May
          • RE: One table gets locked by itselfClaudio Nanni8 May
  • Re: One table gets locked by itselfnixofortune8 May
    • Re: One table gets locked by itselfDarryle Steplight8 May
    • Re: One table gets locked by itselfnixofortune8 May
      • Re: One table gets locked by itselfClaudio Nanni8 May
      • Re: One table gets locked by itselfJohan De Meersman9 May
        • Re: One table gets locked by itselfClaudio Nanni9 May
          • Re: One table gets locked by itselfJohan De Meersman9 May
            • Re: One table gets locked by itselfShawn Green9 May