Hight CPU usage after upgrading to 1.3.9.5

  • Resolved retrovertigo

    (@retrovertigo)


    3 months ago

    Hi Gabe,

    Wanted to let you know, that I just had to down grade to 1.3.9.4, since the latest version caused a spike in db CPU.

    The following two queries kept running for all admins ([user-id])

    INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES ([user-id], 'wpassetcleanup_user_chosen_for_access_to_assets_manager', '1')
    SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN ([user-id]) ORDER BY umeta_id ASC

    Until I found out what the issue for the increase in CPU usage was, each user had around 60k duplicated entries for wpassetcleanup_user_chosen_for_access_to_assets_manager, which got selected again and again.

    Downgrading stopped there re-insterting, and I deleted all duplicates. That seems to have fixed it.

    Regards

Viewing 1 replies (of 1 total)
  • Plugin Author Gabe Livan

    (@gabelivan)

    @retrovertigo you are right about that! In some WP environments, this can obviously happen. My sincere apologies for this inconvenience! You’ve discovered a bug that I’ve just fixed by releasing a newer version. Please update and let me know if this fixes it!

    PS: Because you reported this bug and saved me time from dealing with other people that might have had the same issue sooner or later, I want to reward you with a Pro license. You can write me privately via https://www.gabelivan.com/contact/ if you will ever be interested in the deal.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.