mysql - long execution time on what I think is a simple query
This query is stumping me. It's taking 19 seconds on a quad core server and I can't seem to figure out why!

select * from data where status=2  order by id desc limit 3

The id column is an int(11) primary index with auto_increment, the status is a tinyint(1) which with a regular index (tinyint(1) because this field only has a 0,1,2,3,4 values).

I do have over 2 million records but this isn't a complex query so I would assume it would take less than 1 sec to execute.

Can someone help me figure out what I'm doing wrong with this?
mysql - long execution time on what I think is a simple query
===

This query is stumping me. It's taking 19 seconds on a quad core server and I can't seem to figure out why!

select * from data where status=2  order by id desc limit 3

The id column is an int(11) primary index with auto_increment, the status is a tinyint(1) which with a regular index (tinyint(1) because this field only has a 0,1,2,3,4 values).

I do have over 2 million records but this isn't a complex query so I would assume it would take less than 1 sec to execute.

Can someone help me figure out what I'm doing wrong with this?