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

Messages query still slow

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.9.2
    • Fix Version/s: None
    • Component/s: Messages, Performance
    • Labels:
    • Affected Branches:
      MOODLE_29_STABLE

      Description

      We have very slow page loads for courses/message/index.php?viewing=recentconversations which will pull up the recent conversations screen.

      For a teachers with a high number of messages, that screen consistently pegs the mysqld process at 100% and takes upwards of a minute to load, even after repeated page refreshes. Caching never seems to improve the page performance.

      We have performed a number of steps to troubleshoot, including enabling debug while loading the page (log file attached), rebuilding the individual messages tables in the database, dropping and reloading the entire database, and restarting mysql.

      Server is running cPanel with a Mysql 5.5 build.

        Attachments

        1. explain.csv
          1 kB
        2. slow.txt
          2 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              moorejon Jonathan Moore
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: