Plugin slows down WP All Import since April 1

  • Resolved vemman

    (@vemman)


    3 years, 11 months ago

    Hi,
    After April 1, I have seen a huge slowness on our servers. A daily stock update import which usually takes under 10 mins started taking 1hr 30m and more. And we began to see “MySQL server gone away” & memory exhausted messages in the logs.

    I contacted siteground support, who promptly blamed plugins & custom code. But we hadn’t had any code change in that time. I tried profiling locally and nothing seemed odd enough to warrant this sudden increase.

    Finally, yesterday I decided to test and activate plugins one by one. after getting all consistent results. I activated SG Optimizer and boom import got slower and log is full of mysql server gone away messages.

    I contacted SG support again and after running various configurations with them I was told to report here too.

    from the logs
    [07-Apr-2021 00:06:17 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home/customer/www/staging2.imalcowebstore.com/public_html/wp-includes/wp-db.php on line 2056

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Stoyan Georgiev

    (@stoyangeorgiev)

    Hey there @vemman,

    Could you provide the exact steps to replicate the issue?

    Kind regards,
    Stoyan

    Thread Starter vemman

    (@vemman)

    In simple words enabling SG Optimizer is the only method required to replicate this on my site. It slows import immensely and throws memory exhausted & mysql server gone away errors in the logs.

    In detail, how I found it.

    We have a multilingual woocommerce store with WPML, Elementor, Elementor Pro, Kirki framework, yoast etc. around 40 plugins

    We use WP All Import by Soflyy, for updating stock. On our April 3 stock update instead of usual under 10 mins time it took 1hr 30mins + (and more in subsequent runs). The csv is simple with SKU & stock quantity only.

    After not finding any issue on local machine. I contacted SG support and got usual reply of blaming plugins.

    Then I went on with disabling all plugins (except WC, WPML & WP All Import). Then I ran import enabling one plugin at a time and running the same import. And it all gave same sub 10 mins import time. Finally I enabled SG Optimizer and it shot back to 1hr 30mins. I rechecked without SG Optimizer and fell back to usual time.

    SG Support also confirmed this and told me they will escalate it to the developers.

    Plugin Author Stoyan Georgiev

    (@stoyangeorgiev)

    Hey there @vemman,

    Could you provide a test import so we can check this out. Maybe you can create a staging copy, so we can test it there.

    Kind regards,
    Stoyan

    Plugin Author Hristo Pandjarov

    (@hristo-sg)

    SiteGround Representative

    Closing due to no reply.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Plugin slows down WP All Import since April 1’ is closed to new replies.