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

    • Improvement
    • Status: Development in progress
    • Minor
    • Resolution: Unresolved
    • 3.7
    • None
    • Logging, Web Services
    • None
    • MOODLE_37_STABLE
    • MDL-65874_master
    • 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

    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

              lapie002 Lapierre
              massicos Steve Massicotte
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Juan Leyva, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              2 Vote for this issue
              Watchers:
              9 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