Few more things. You can't have a deadlock on Mylsam table. You can check status of your tables in use with: SHOW OPEN TABLES WHERE IN_USE !=0 you might check mysqld error log ad well On 8 May 2012 18:42, "nixofortune" <nixofort...@gmail.com> wrote:
> 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 >> >> >> >>