Mysql query takes forever

Question

I want to delete rows with some duplicate feilds.
I run this command but it takes too long.

DELETE t1 FROM users t1 INNER JOIN users t2 on t1.user_email = t2.user_email;

+Table is pretty big

Answer 1

Optimizing queries is the first thing to do for more speed.
Configuring your mysql server.
Updating your hardware.

Its no surprise a big database takes time with regular hardware

Answer 2

It's not my hardware.
I'm running it on my personal computer which has ok specs I think