I'm fairly certain I know the answer to this, but any ideas would be extremely helpful...
First of all, this is MySQL 5.1.32-community. I have a large table (millions of rows, can't reduce the size - that is the reduced size) and the pertinent fields are two datetime fields. We'll call it date1 and date2. I need to run a select query that returns all rows (a actually UUID varchar(40) where date1 > date2.
SELECT id FROM table1 WHERE date1 > date2;
Have you run a count to see if there just is really so much data being returned that it will take that long to return it all?
select count(ID) from table1 WHERE date1 > date2;
The query seems simple enough and your data volume might just be the problem.