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

Webservice logs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.9.2
    • Fix Version/s: None
    • Component/s: Web Services
    • Labels:
    • Affected Branches:
      MOODLE_39_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

            Assignee:
            jleyva Juan Leyva
            Reporter:
            mdeane Michael Deane
            Participants:
            Component watchers:
            Juan Leyva, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
            Votes:
            6 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: