“finish update” overloads MySQL server

  • Resolved fneumeier

    (@fneumeier)


    9 years, 3 months ago

    Hi,

    after updating to AdRotate 4.4 Pro, clicking the “finish update” button overloads my MySQL server. It runs on a managed server, so there is lots of ressources available. According to my hosting provider’s support the AdRotate script starts a massive database query which causes the issue.

    update: I’ve just recognized that there are more than 400.000 (!) database entries _transient_timeout_adrotate_impression_[…] and _transient_adrotate_impression_[…] in the options table. When I understand correctly, vesion 4.4 is not using transients anymore – hence “finish update” supposedly is trying t delete all these entries which might explain the overload.

    Now: How do I solve this?

    And is there a way to revert to a previous version of AdRotate meanwhile?

    Thanks and kind regards
    Franz

    • This topic was modified 9 years, 3 months ago by fneumeier.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter fneumeier

    (@fneumeier)

    9 years, 3 months ago

    issue solved after manually deleting the transients in the database

    Plugin Author Arnan

    (@adegans)

    9 years, 3 months ago

    I’ve updated the query to be a bit more lightweight, but given how transients (don’t) work there isn’t much I can do to fix any overloading during cleanup 🙁

    Manually deleting the stuff is probably the best way for now.

    Thread Starter fneumeier

    (@fneumeier)

    9 years, 3 months ago

    Okay, thanks. I was just wondering whether it might be possible to do the clean-up in batches, i.e. delete 500 transients, check whether there are still some left, then start a new process to clean the next 500 transients and so on until the job is done …

    Anyway, I’ve solved my issue by deleting it manually, though not being a MySL expert at all (like probably most users of this plugin), it took me several hours to a) find the resaon for the issue and b) to figure out how to delete these transients manually.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘“finish update” overloads MySQL server’ is closed to new replies.