From: abhishek jain
Date: May 8 2012 2:04pm
Subject: One table gets locked by itself
List-Archive: http://lists.mysql.com/mysql/227356
Message-Id: <4fa927ff.e586440a.16a9.ffff940e@mx.google.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0174_01CD2D51.9EF37A50"

------=_NextPart_000_0174_01CD2D51.9EF37A50
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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 

 


------=_NextPart_000_0174_01CD2D51.9EF37A50--