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

Review indexes in standard log table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.7
    • 2.6.2
    • Logging
    • MOODLE_26_STABLE
    • MOODLE_27_STABLE
    • wip-MDL-44998-master
    • Hide

      Testing requires issues MDL-45087, MDL-41283 and MDL-41286 integrated. If one of them is not integrated, these instructions for that report need to be moved into the report issue.

      1. Make sure standard log is enabled and you have some student and teacher activity in the course
      2. Enable logging of db queries by setting in config.php $CFG->dboptions('logall' => true)
      3. View report_log, report_loglive, outline and participation reports for some course, outline and participation report for particular user in the course.
      4. Select from table [mdl_]log_queries all queries from table [mdl_]logstore_standard_log, run them in your db using 'explain plan' and make sure they use indexes.
      Show
      Testing requires issues MDL-45087 , MDL-41283 and MDL-41286 integrated. If one of them is not integrated, these instructions for that report need to be moved into the report issue. Make sure standard log is enabled and you have some student and teacher activity in the course Enable logging of db queries by setting in config.php $CFG->dboptions('logall' => true) View report_log, report_loglive, outline and participation reports for some course, outline and participation report for particular user in the course. Select from table [mdl_] log_queries all queries from table [mdl_] logstore_standard_log, run them in your db using 'explain plan' and make sure they use indexes.

      All our reports should use good indexed queries

            marina Marina Glancy
            marina Marina Glancy
            Petr Skoda Petr Skoda (Inactive)
            Sam Hemelryk Sam Hemelryk
            Jason Fowler Jason Fowler
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.