doing a gaint 3 million row table query with inner join.

I have a giant table of 3 million that query's with another table something like this.

UPDATE table1 t1
INNER JOIN table2 t2
ON 11.now =t2.ind_id
AND t1.cat_mod=t2.kitty_mod
SET t1.mice=t2.mice

Any suggestions or ideas how to speed this up? so far its been running for 4 days now... I don't have any unique or primary or anything like that set..

 

Really? You have not put in anything that will help speed, yet you're suggesting just the things you need to do, more or less. 3million rows isn't that big, however, although if you're running an update on all rows, it will take a while anyway.

 

Thank you.. yea I was just trying to collect ideas first.

 

4 days are too much for just 3 million rows. Index the columns involved in JOIN i.e. 11.now, t2.ind_id, t1.cat_mod, t2.kitty_mod. This will speed up the process.