mysql left join limit_在MySQL中使用LEFT JOIN和LIMIT进行DELETE

我正在尝试删除数据库中的孤立帖子并创建了此查询：

DELETE post.*

FROM foro_post AS post

LEFT JOIN foro_thread AS thread USING(threadid)

WHERE thread.threadid IS NULL

问题是我想限制,因为我的表有超过7,000,000条记录.

由于我无法使用LIMIT查询,我尝试了这个并且实际上有效,但我不确定它是否是一个有效的解决方案,或者它是否可以做得更好.

DELETE post.*

FROM foro_post AS post

LEFT JOIN foro_thread AS thread USING(threadid)

WHERE thread.threadid IS NULL

AND post.postid < 500

// Where < 500 should be increasing as I delete records

我怎样才能更有效地做到这一点？