Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-8157

Improve performance on view

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 3.9
    • None
    • MOODLE_39_STABLE

    Description

      Add index (courseid) to bigbluebuttonbn_logs

      After running a very busy moodle site with a lot of BBB activities(more than 2000 simultaneous users in conferences) I realized that when users try to join conferences the following SQL query is performed:
      SELECT COUNT from bigbluebuttonbn_logs WHERE courseid ...
      This query consumes a lot of CPU time on the SQL server (MariaDB) making the database to respond very slow. Adding the proposed index (courseid) made a huge difference.

      Partialy covered by PR#235

      Attachments

        Activity

          People

            jfederico Jesus Federico
            jfederico Jesus Federico
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: