mysql_query hangs

[wekion]

i am doing a SELECT on a table with 2,000,000 rows, but it seems that PHP hangs on the mysql_query statement. when the execution starts, i noticed that the "mysqld" started running. about 40 seconds later, it stops. but the statement does not return, like it is still waiting for mysql.

help, anyone....

[[deleted]]

Is there anything in your mysql error logs? Can you run this query directly against the database?

Have you thought about better indexing?

[wekion]

the query runs fine in the mysql client.

when i run mysql_unbuffered_query with this query, it seems to retrieve correctly, but hangs after retrieving the last row, at mysql_fetch_array, instead of returning null.

very strange...