Query never ends

[Alejandro Alfonso]

Hi, I'm new using MySql and have this problem.

I have 2 tables, TableA with 17.000.000 records and TableB with 5.000.000. Both have only one column with phone numbers. What I need to do is scrub the numbers on TableA, from the numbers on TableB, so my query is this

Select TableB.phones
from TableB left outer join TableA on TableB.phones = TableA.phones
where isnull(TableA.phones)

The query start running but never ends... it's been 8 hours. I'm using SQLyog and MONyog, it seems to be running but I checked windows process monitor doesn't seems to take any CPU usage or memory. Is it dead? Or it will take 2 days to end? Do I need to change any config to be able to work with this large DBs?

I'm running MySql 5.1.30 on Win XP Pro SP2, Core2Duo and 2GB RAM

Thanks.



Edited 1 time(s). Last edit at 02/03/2009 04:08AM by Alejandro Alfonso.