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

Moodle database server is the bottleneck

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Not a bug
    • Minor
    • None
    • 2.3.1
    • Performance
    • None
    • MOODLE_23_STABLE

    Description

      We try to do stress test on Moodle 2.3.1 with 4 web servers and 1 MySQL database server. However, we find that there is a bottleneck in the Moodle MySQL database server. The write IO has reached the peak, thus, we have many long running queries when Moodle acquires a lock on mdl_session. However, running Moodle with 3 web servers has better performance than 4 web servers. May i ask how we can improve the write IO? We are already using Paravirtual SCSI controller on a SAN. Besides, do you think using MySQL clusters with Moodle is a good solution?

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda
              cplau CP Lau
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: