MySQL如何更快的删除重复记录？

怎么样才能更快的删除重复数据，以下我是已经采取过的方案。
5W多条记录 删除重复记录，保留ID最小的行。
`delete from table

where peopleId in
    (select peopleId from table group by peopleId having count(peopleId) > 1)   
and id not in
    (select min(id) from table group by peopleId having count(peopleId)>1)`

出错：
MariaDB>1093 - You can't specify target table 'table' for update in FROM claus
不能先select出同一表中的某些值，再update这个表(在同一语句中)，
于是，使用子集。
`delete from table

where peopleId in
    (select peopleId from (select tmp.* from table tmp) a 

group by peopleId having count(a.peopleId) > 1)

and id not in
    (select min(id) from (select tmp.* from table tmp) b

group by peopleId having count(b.peopleId)>1)`
运行几十秒后都没结果，没等结果出来，开始优化
子集只需要需要的列
`delete from table

where peopleId in
    (select peopleId from (select tmp.id, from table tmp) a

group by peopleId having count(a.peopleId) > 1)

and id not in
    (select min(id) from (select tmp.id,tmp.peopleId from table tmp) b

group by peopleId having count(b.peopleId)>1)`
30分钟无结果
求教各位大神如何做，是速度加快呢？