Massive database value

  • ResolvedModerator Jose Castaneda

    (@jcastaneda)


    THEME COFFEE MONKEY

    4 years, 10 months ago

    Hi there!

    Earlier today we had a site go down because there was a database query that was running for some time. Part of that was because the query being run was

    UPDATE wp_optionsSEToption_value= 'MASSIVE BLOB OF TEXT' WHEREoption_name= 'cron'

    When I went to look at the current value, the array had 26,076 entries attached so I can see why things would be super slow. I wanted to expand it but Sequel Pro halted when I tried to select it ??.

    What I'm wondering is how is that db value being fully utilized and what are some steps that can be taken to reduce this down the line?

    Thanks!

    • This topic was modified 4 years, 10 months ago by Jose Castaneda. Reason: fix code
Viewing 5 replies - 1 through 5 (of 5 total)

  • Dear @jcastaneda,

    We do have crons in our plugin, but as it’s general for other plugins as well, we would like to make sure those records refer to our plugin or not.

    We are just wondering if you have the latest (3.59) version of our plugin?

    Can you send us the massive log so we can see if there are any records related to our plugin?

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    It is the latest version and this was the screenshot I was able to get; it does show that the sgpbGetNotificaions event was being created many times over

    https://www.dropbox.com/s/7kxvv4n1pahx9hg/image.png?dl=0

    It was super strange to see that and I have no idea what could have really caused that to behave that way either.

    Dear @jcastaneda,

    We used to have problems with crons in the past, but we have fixed them in our latest versions. And if you’re using the latest version of our plugin as well, the issue should have been fixed for you as well.

    Please, deactivate/reactivate the Popup Builder plugin on your side then check via Sequel Pro if our plugin crons are cleared. There should be only one left with this name: “sgpbGetNotifications”.
    This should solve your issue.

    If these steps don’t solve the issue, please, download the WP Crontrol plugin. It will show the active crons on your site.
    If our crons show, you can delete them (‘sgpbGetNotifications’).

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    Ah, good to know.

    They wound up switching to a different solution.

    Again, not sure what really could have caused this to spring up like that. There had been no changes in code in nearly a week.

    Appreciate the helpful replies to this ??

    Dear @jcastaneda,

    We are always happy to assist! ??

    Feel free in case of any questions in future.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Massive database value’ is closed to new replies.