mysql - Column locking in innodb? -

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

  from the select * table where type_id = 1 and updated_at & lt; '2010-03-14' Border 1; Select * from the table where type_id = 3 and updated_at & lt; '2010-03-14' limit 10;  

The first one does not end in a few hours, while the second one is easily accomplished. The only difference is that there is type_id between 2 questions.

A bit of background, the first statement got spoiled, before that I had to kill myself manually.

Thank you in advance for your help - I have an immediate data work, and this problem is driving me crazy

It looks like you have (type_id, updated_at) no index and your table is large.

Indexing should fix the problem:

  Create index type_updated_idx (type_id, updated_at) on the table;  

Assume that you have sufficient permissions to make a data definition statement.