Uploaded image for project: 'Moodle Community Sites'
  1. Moodle Community Sites
  2. MDLSITE-3474 META: Upgrade moodle.org to 2.8
  3. MDLSITE-3531

Investigate slow running query locking up access to site

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Deferred
    • Icon: Low Low
    • moodle.org
    • None

      Helen reported 504 gateway timeouts, i looked and saw mysql gobbling a lot of CPU saw this query in 

      | 66067 | moodleorg | 127.0.0.1:34221 | nextmoodleorg | Query   |  298 | Copying to tmp table | SELECT d.forum,d.course,COUNT(p.id) AS count  FROM forum_posts p  JOIN forum_discussions d ON p.disc |

      Seems to course overview block related to MDL-47316?

            Unassigned Unassigned
            poltawski Dan Poltawski
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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