From: Darryle (dsteplightgmail.com)
Date: Tue May 08 2012 - 09:12:05 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]