Sweeping never finishes

  • Resolved Stingraynut

    (@stingraynut)


    5 years, 12 months ago

    I’m trying to clean the Orphaned User Meta which is showing 49%. I click sweep and it shows ‘sweeping’ but it never finishes, even after 24hrs
    The database is 822mb in total.
    WP sweep worked a few months ago when the database was smaller.
    Is the database too large for sweep to work?
    I’ve tried using clean up optimiser and wp-optimise.
    Is there an sql query that could maybe reduce the Orphaned User Meta until it’s small enough for Sweep to clean up?
    or what other options do I have?
    thank you
    Rob

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Lester Chan

    (@gamerz)

    I don’t have it since it is code based. You probably have to manually eyeball and delete it.

    
SELECT user_id, meta_key FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)
    Thread Starter Stingraynut

    (@stingraynut)

    Thanks Lester, I don’t know much about SQL Queries, but have run a few with help from forums
    so SELECT user_id, meta_key FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)
    Say my prefix was ‘prefix’ so Users would be prefix_users, then is this correct –
    SELECT user_id, meta_key FROM prefix_usermeta WHERE user_id NOT IN (SELECT ID FROM prefix_users)
    OR do I need to use prefix anywhere else ie SELECT prefix_user_id etc?
    really appreciate your help
    Rob

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Sweeping never finishes’ is closed to new replies.