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

Webservice logs

    XMLWordPrintable

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 3.9.2, 3.11.3, 4.0
    • None
    • Web Services
    • MOODLE_311_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE

    Description

      We use webservices extensively and this causes the mdl_log table to grow proportionally larger. If there was an option to disable logging for webservice calls it would minimise the growth of our log table.

      This would help to manage the size of our database and have a positive effect on running reports that involve the mdl_log table.

      e.g. Our mdl_log table since 2018 has 270M records of which 210M are webservice related.

      This translates to mdl_log size of 56GB versus 11GB.

      I should also add that the current table mdl_logstore_standard_log is similarly affected.

      Attachments

        Activity

          People

            jleyva Juan Leyva
            mdeane Michael Deane
            Juan Leyva, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            12 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated: