1200 UPDATE queries / page after updating to 9.0.1

  • Resolved xberg

    (@xberg)


    7 years, 10 months ago

    Hi Jeff,
    Since I updated to 9.0.1 mysql has gone crazy with high query levels. After investigation I found out that Plugin Organiser was generating 1200+ UPDATE queries on each page view.
    For instance:
    UPDATE wp__po_plugins
    SET dir_count = ‘3’
    WHERE pl_id = ‘153’

    The integer after the pl_id changes for each query.
    This has been happening for the last 10 hours and generating an increase on 1000% of mysql activity ??
    Not quite the goal of plugin organiser ??
    Good luck Jeff!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter xberg

    (@xberg)

    Tracking the function responsible for this:
    PluginOrganizer->activate()
    wp-content/plugins/plugin-organizer/lib/PluginOrganizer.class.php:402
    –
    PluginOrganizer->check_version()
    wp-content/plugins/plugin-organizer/lib/PluginOrganizer.class.php:115
    PluginOrganizer->init()
    wp-content/plugins/plugin-organizer/lib/PluginOrganizer.class.php:125
    do_action(‘init’)
    wp-includes/plugin.php:453

    Thread Starter xberg

    (@xberg)

    OK: I fixed the problem ??

    PO had a problem activating obviously. So I:
    – disabled Redis Object Cache
    – deactivated Plugin Organiser
    – re-activated PO
    – re-activate selective plugin loading in PO
    – re-activated Redis Object Cache

    All good.
    So while Redis Object Cache was turned on PO was have a hard time migrating from 8.x to 9.0.1.
    In case some of your other users face the same problem ??

    Plugin Author Jeff Sterup

    (@foomagoo)

    I was going to suggest it was a caching problem. It must have cached the version number so it was trying to upgrade to the new version on every page load.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘1200 UPDATE queries / page after updating to 9.0.1’ is closed to new replies.