Where can I see the queries used to run the \core\task\ jobs?

Where can I see the queries used to run the \core\task\ jobs?

by Jerry Lau -
Number of replies: 2

Still having the slowness issue...

I think it maybe the time of day certain heavy cron jobs are taking place.

Where can I get a list of all the queries used under the Scheduled Tasks "\core\task\.." when the cron is run?

We currently have automated course back up to run (*****) everytime the cron is called .. every minute! which may impact users taking quizzes that makes moodle not usable.. our mdl_standard_log is very large at over 6.6 GB

Average of ratings: -
In reply to Jerry Lau

Re: Where can I see the queries used to run the \core\task\ jobs?

by Séverin Terrier -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Testers Picture of Translators

Hi,

If your cron is configured to run each minute, Tasks are launched when defined in the Scheduled tasks admin screen.

Perhaps you could try to disable automated backups temporarily, to see if it's change things.

Séverin

Average of ratings: -
In reply to Séverin Terrier

Re: Where can I see the queries used to run the \core\task\ jobs?

by Jerry Lau -

May not be an issue even though its 50 ****  and further settings say its only on a saturday... so maybe it's never completed... and just piles everything on

Average of ratings: -