Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-16709

Statistics generation does not run at the right time

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.2
    • Fix Version/s: 1.9.3
    • Component/s: Performance
    • Labels:
      None
    • Environment:
      Linux
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      I have been fighting performance problems on a fairly large installation which I have narrowed down to the stats generation query "INSERT INTO mdl_stats_daily (stattype, timeend, courseid, roleid, stat1, stat2) SELECT 'enrolments', timeend, courseid, roleid, COUNT(DISTINCT...." that is run by the stats generation routines. According to the admin UI, it should be running at 2AM, but I am finding it running in the early evenings (6-8PM) during out peak usage times and it brings the system grinding to a halt. If I kill the query, performance returns to normal. I don't know yet if it's not honoring the schedule at all and is running everytime the cron job runs, or if it's just offset incorrectly. As I discover more I will update this report.

      For the time being, I've disabled statistics gathering on this system in the hopes that it will stop running and the system will remain usable. We'll see if that is the case tonight.

      A discussion on this has been opened in the forums here: http://moodle.org/mod/forum/post.php?reply=458555

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  15/Oct/08