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