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

mdl_logstore_standard_log - Delete the logs generated by the load balancer ping

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 3.7
    • Fix Version/s: None
    • Component/s: Logging
    • Labels:
    • Testing Instructions:
      Hide
      • Use the following SQL query to validate that load balancer accesses make logs in mdl_logstore_standard_log

       

      SELECT eventname, FROM_UNIXTIME(timecreated), courseid, userid, ip FROM `mdl_logstore_standard_log` ORDER BY timecreated DESC LIMIT 25 
      
      

      * Install the fix  

      • Validate with the same SQL that there is no more log. 
      • comment on the config.php line

      $CFG->restrictedip = array("XX.XX.XX.XX", "XX.XX.XX.XX");
      

      * Validate with the same SQL query that there are new logs

       

      Show
      Use the following SQL query to validate that load balancer accesses make logs in mdl_logstore_standard_log   SELECT eventname, FROM_UNIXTIME(timecreated), courseid, userid, ip FROM `mdl_logstore_standard_log` ORDER BY timecreated DESC LIMIT 25 * Install the fix   Validate with the same SQL that there is no more log.  comment on the config.php line $CFG->restrictedip = array( "XX.XX.XX.XX" , "XX.XX.XX.XX" ); * Validate with the same SQL query that there are new logs  
    • Affected Branches:
      MOODLE_37_STABLE
    • Pull from Repository:

      Description

      To know which server is up, the load balancer needs to access a page many time per minute. Those access create a lot of useless logs. The goal of this task is to have a way to prevent the system to log in that case. 

       

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

        Attachments

          Activity

            People

            • Assignee:
              lapie002 Lapierre
              Reporter:
              massicos Steve Massicotte
              Peer reviewer:
              Andrew Nicols
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

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