Does the Scheduled Database Maintenance only clean up db if the site is on SG?

  • Resolved painlessseo

    (@painlessseo)


    10 months ago

    Will the Environment -> Scheduled Database Maintenance still work if the site isn’t hosted with SG?

    I have sites with SG and it seems to be working as expected. ON THE CONTRARY, I also have it enabled for a site that isn’t hosted with SG. Although I expected it to clean up the db once a week, I found 5k+ post revisions in the database today and it seems that it never automatically cleaned up the db since I enabled it about a month ago.

    So I’d like to confirm if the automatic cleaning up feature works with sites that ain’t hosted with SG.

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support daniellaivanova

    (@daniellaivanova)

    Hello @painlessseo,

    The feature should work on websites hosted outside of SiteGround as well. This means that the issue is most probably caused by something else. I recommend you check if the cron event responsible for the database optimization is properly added to the cron event list.

    By default, the database maintenance is executed through a cron event scheduled to be performed every week. Once the process is completed the same event gets automatically scheduled to be executed in 7 days.

    You can enlist the scheduled cron events using the following command:

    wp cron event list

    After you list all of the scheduled cron events, search for the siteground_optimizer_database_optimization_cron one, which is responsible for the scheduled database maintenance.

    If you want to force the cron event on demand you can use this command which will run the optimization immediately:

    wp cron event run siteground_optimizer_database_optimization_cron

    Best regards,
    Daniela Ivanova

    Thread Starter painlessseo

    (@painlessseo)

    Thank you @daniellaivanov. I have confirmed that you were correct in every aspect. I really appreciate the support.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Does the Scheduled Database Maintenance only clean up db if the site is on SG?’ is closed to new replies.