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

mdl_logstore_standard_log - Do not add mobile event (webservice_function_called) to the log table

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Development in progress
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.7
    • Fix Version/s: None
    • Component/s: Logging, Web Services
    • Labels:
      None
    • Testing Instructions:
      Hide
      • Enable the "Disable mobile web services call log" config in "Site Administration / Mobile App / Mobile Settings"
      • Use postman to make webservice calls locally
      • Import the file as an attachment in postman
      • Change the password and username of the url http: //localhost/moodle/login/token.php
      •  Click on Send
      • Retrieve the token in the response and copy it to the url token http://localhost/moodle/webservice/rest/server.php?moodlewsrestformat=json
      • Click on Send
      •  go to the database or in the Moodle interface and check that the webservice type "\core\event\webservice_function_called" is not there
      • Disable config and run the same webservice calls again 
      • This time, check that they are registered in the log table
      • Run unit tests : vendor/bin/phpunit webservice/tests/lib_test.php
      Show
      Enable the "Disable mobile web services call log" config in "Site Administration / Mobile App / Mobile Settings" Use postman to make webservice calls locally Import the file as an attachment in postman Change the password and username of the url http: //localhost/moodle/login/token.php  Click on Send Retrieve the token in the response and copy it to the url token http://localhost/moodle/webservice/rest/server.php?moodlewsrestformat=json Click on Send  go to the database or in the Moodle interface and check that the webservice type "\core\event\webservice_function_called" is not there Disable config and run the same webservice calls again  This time, check that they are registered in the log table Run unit tests : vendor/bin/phpunit webservice/tests/lib_test.php
    • Affected Branches:
      MOODLE_37_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-65874_master

      Description

      We deployed the mobile app and we noticed that the table 'mdl_logstore_standard_log' grow quickly after that.

      We noticed that '\core\event\webservice_function_called' was one of the new event that cause the growth.

      Because of that growth and this event is not relevant, we created a configuration to prevent moodle to write this event in the table.

      In our case, those logs created over 50.000.000 of records in the log table (the table contains 310.000.000 of records).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                lapie002 Lapierre
                Reporter:
                massicos Steve Massicotte
                Participants:
                Component watchers:
                Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Juan Leyva, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 15 minutes
                  15m