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

Add "time spent waiting for the database" value to the performance info

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.7
    • Component/s: Performance
    • Labels:
    • Testing Instructions:
      Hide
      1. Ensure perfdebug admin setting is disabled
      2. Ensure MDL_PERF* vars are not defined in your config.php
      3. Go to your CFG->wwwroot
      4. You SHOULD NOT see the performance info shown in the footer
      5. Set MDL_PERF vars in config.php (http://docs.moodle.org/23/en/Debugging#Performance_info)
      6. Go to your CFG->wwwroot
      7. You SHOULD see the performance info shown in the footer
      8. You SHOULD see a new var named DB queries time with a value in seconds
      Show
      Ensure perfdebug admin setting is disabled Ensure MDL_PERF* vars are not defined in your config.php Go to your CFG->wwwroot You SHOULD NOT see the performance info shown in the footer Set MDL_PERF vars in config.php ( http://docs.moodle.org/23/en/Debugging#Performance_info ) Go to your CFG->wwwroot You SHOULD see the performance info shown in the footer You SHOULD see a new var named DB queries time with a value in seconds
    • Affected Branches:
      MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-43758_master

      Description

      With MDL_PERF constants enabled we display data like the number of db reads, db writes... There is already a moodle_database::print_debug_time() method, we can refactor the code a bit and add a new performance var with the time spent to finish the query (between query_start() and query_end())

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/May/14