Re: One table gets locked by itself

[nixofortune]

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.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
>
>
>
>