Column locking in innodb?

Posted by mingyeow on Server Fault See other posts from Server Fault or by mingyeow
Published on 2010-05-17T00:42:12Z Indexed on 2010/05/17 0:50 UTC
Read the original article Hit count: 469

Filed under:

mysql

|

innodb

|

locking

|

database-adminstration

|

database

I know this sounds weird, but apparently one of my columns is locked.

select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1;

select * from table where type_id = 3 and updated_at < '2010-03-14' limit 10;

the first one would not finish running, while the second one completes smoothly. the only difference is the type_id

Thanks in advance for your help - i have an urgent data job to finish, and this problem is driving me crazy

Column locking in innodb?

Posted by ming yeow on Stack Overflow See other posts from Stack Overflow or by ming yeow
Published on 2010-05-17T00:50:51Z Indexed on 2010/05/17 1:00 UTC
Read the original article Hit count: 469

Filed under:

mysql

|

innodb

|

database-administration

|

locking

I know this sounds weird, but apparently one of my columns is locked.

select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1;

select * from table where type_id = 3 and updated_at < '2010-03-14' limit 10;

the first one would not finish running even in a few hours, while the second one completes smoothly. the only difference is the type_id between the 2 queries.

a bit of background, the first statement screwed up before which i had to kill manually.

Thanks in advance for your help - i have an urgent data job to finish, and this problem is driving me crazy

Developer IT