Moodle
  1. Moodle
  2. MDL-18241

My Moodle generating 12,000 database queries per pageload

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.4
    • Fix Version/s: 1.9.5
    • Component/s: Performance
    • Labels:
      None
    • Environment:
      mysql
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE
    • Rank:
      31530

      Description

      We had some reports of slowness on one of our moodle sites. It turned out the school had my moodle redirect switched on.

      Upon investigating the performance log I discovered for a single user /my/ page was causing 12401 database queries.

      Here is a perf log line from my dev machine (artificially fast due to front/backend being the same).

      [Tue Feb 10 19:38:55 2009] [error] [client 10.0.0.5] PERF: /my/ time: 5.407977s memory_total: 21916276B (20.9MB) memory_growth: 21626784B (20.6MB) memory_peak: 22259484B (21.2MB) includecount: 80 dbqueries: 12401 ticks: 541 user: 211 sys: 144 cuser: 0 csys: 0 serverload: 0.11 rcache: 0/0

      I want to investigate this and search and destroy whatever is causing it. This obviously cripples a moodle site with my moodle redirection.

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved: