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

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.7
    • 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

      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).

            Unassigned Unassigned
            massicos Steve Massicotte
            Votes:
            3 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:

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

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