Database optimisation cron job causes site issue

  • Resolved gtawebb

    (@gtawebb)


    4 years ago

    Every Wednesday we have been experiencing an issue with the users being logged out the site and unable to login again. The issue lasts for around 20 / 30 mins. Sometimes the website becomes unavailable during this time.

    I have checked the cron jobs and I have found that at this exact time every Wednesday the following process runs..

    siteground_optimizer_database_optimization_cron

    Can support please advise if they are aware of this issue and if they can stop it from occurring?

    I could change the time it runs or disable it, but it would be better to get to the bottom of the issue.

    https://capture.dropbox.com/gPnkVfAEMHLcaPJM

    Please advise.

    Thanks,
    George

Viewing 1 replies (of 1 total)
  • Plugin Support Dimitar Petrov

    (@demiro)

    4 years ago

    Hello @gtawebb,

    The MySQL “OPTIMIZE TABLE” query locks the table for write operation during the prepare phase and the commit phase of the operation. You can also manually run the tables optimization as explained here. If the optimization process is too slow, there could be too large tables or heavy structured ones. In such a case, I would recommend inspecting the database and cleaning unused records. If you need further assistance and the website in question is hosted on our end, you are welcome to open a ticket from your SiteGround User Area so we can check the case further.

    Best Regards,
    Dimitar Petrov

Viewing 1 replies (of 1 total)

The topic ‘Database optimisation cron job causes site issue’ is closed to new replies.