You probably need to increase max_execution time to maybe 5 mins and php limit to probably 1GB. You and to try and tweak the values. It is safe to keep running the sweep.
That didn’t work. I set it to no limit and left the window that I hit “Sweep” on open all night. Nothing changed. Is there an alternate way to do this?
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM wp_comments)
This is the query to run. But not sure if your database will timeout as well.
(@salromano)
9 years, 10 months ago
Deleting Orphaned Comment Meta seems to not want to work for me.
I have 2,155,504 Orphaned Comment Meta, so it’s quite the amount.
My PHP memory limit is 512mb. I hit sweep and leave the page open for a little. It never finishes, and if I open the WP-Sweep page again, the number remains the same, meaning it deleted nothing.
All of my Orphaned Comment Meta seem to be repeats of:
dsq_parent_post_id
dsq_post_id
Any suggestions, Lester Chan?
https://wordpress.org/plugins/wp-sweep/