Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • February 4, 2020 at 2:59 pm #1181290
    edgold

    Hi,

    I upgraded to Enfold 4.7.2 from 3.8.5 late January. A few days later my website started timing out. I raise a ticket with my hosts who told me:

    “We have noticed an unsustainable high MySQL usage from your site that seems to be taking down your whole Hosting Service and neighboring sites. Currently it seems like that there is a background task that generates gigabytes of data every second which might be connected to a cronjob or a plugin. Due to the severity of the usage we have temporarily deactivated script execution as the usage has raised around 100x times for the past couple of hours.”

    Then a few hours later they said:

    ” I have managed to find the source of the unusual usage that seems to be the theme ‘enfold’. For some reason it constantly starts an extremely heavy SQL query or enters an endless loop that maxes out the MySQL usage of the Hosting Service which also results in catastrophic damages to the server.
    The unusual usage seemed to start on January 26th and has started to rapidly increase on February 1st”

    I’ve now rolled back to Enfold 3.8.5 and the site is stable… but I wondered what advice you might have to allow me to use the current version of enfold, or investigate the root cause further? 

    February 4, 2020 at 3:12 pm #1181295
    Yigit

    Hi,

    Did you have merging of files enabled in Enfold theme options > Performance tab?

    Could you please create a testing environment and update Enfold there and check if disabling merging helps?

    Best regards,
    Yigit

    February 5, 2020 at 11:06 am #1181705
    edgold

    Hi Yigit,

    Just had this back from my hosting company:

    > I have tested this with all merging disabled on a test environment that I
    > have set [grab attached] but unfortunately the issue was still
    > persisted.
    >
    > It is possible that the issue might be related to the way that the site
    > and menus or data is managed by the theme but unfortunately we cannot debug
    > this because when we are logging the queries we just get an enormous logs.

    February 10, 2020 at 8:04 am #1182957
    Ismael

    Hi,

    Thank you for the update.

    They should at least check which database queries are causing the spike by enabling the mysql general logs. The SQL statements in the log should give hints which scripts or functions are executed during the spike.

    // https://dev.mysql.com/doc/refman/5.7/en/query-log.html

    It’s possible that another plugin or a custom script is causing it instead of the theme.

    Best regards,
    Ismael

    February 11, 2020 at 2:43 pm #1183513
    edgold

    thanks for the response. My hosting company say:

    Unfortunately we do not support this option. We can only check the ETA usage and log most of the queries via mysqladmin – https://mariadb.com/kb/en/mysqladmin/ but when we do we do not see anything else.

    February 12, 2020 at 3:55 am #1183732
    Ismael

    Hi!

    Thank you for following up.

    What is the name of your hosting provider? Is the site on a shared hosting plan? MariaDB same as MySQL should have a general query log option. It can be enabled via the command line or in the database configuration file.

    // https://mariadb.com/kb/en/general-query-log/

    Did you enable Performance > File Compression settings? Please disable it temporarily and check if there are a lot of merged scripts and stylesheets in the wp-content > uploads > dynamic_avia. If there are multiple copies of the merged files, then it’s possible that the compression is causing the spike.

    Cheers!
    Ismael

    February 14, 2020 at 12:53 pm #1184470
    edgold

    Hi,

    I’m with WPX hosting on a shared hosting plan.

    Their response to your Qs is:

    We do not support any kind of query logs directly via MariaDB on production servers.

    We can only partially log them for a specific user.

    I am not sure if we can help with the debugging of the case in any way, unless there are a few similar cases from which we can distinguish the similar causes.

    February 17, 2020 at 4:26 am #1185066
    Ismael

    Hi,

    Thank you for the info.

    Can we access the dashboard? Maybe we’ll be able to pinpoint the issue using the Query Monitor plugin.

    Best regards,
    Ismael

    November 14, 2020 at 8:12 pm #1260518
    datahelps

    First I would like to say I love this theme, BUT!!
    I read numerous articles about sites spiking using it and mine is doing the same.this is definitely an Enfold issue as i have 2 dozen websites with the same plugins being used and my Enfold site is the only problem.
    Have you found a solution to your software???

    November 16, 2020 at 6:50 am #1260646
    Ismael

    Hi,

    Did you enable the database or server logging as suggested above? Is the site on a shared hosting? Please keep in touch with your hosting provider to properly monitor the site for unexpected usage in the CPU or huge queries to the database.

    If the issue persists, please do not hesitate to open a new thread with the site details so that we could check it properly. We will close this one for now.

    Have a nice day.

    Best regards,
    Ismael

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)
  • The topic ‘Enfold 4.7.2 causing massive SQL usage’ is closed to new replies.