You might run out of file desciptors. Check your open file limits, open table limits vars and corresponding syatus values On 8 May 2012 15:05, "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 > > > >