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

add support for mysqli persistent connections

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      0/ obviously setup your test server to use mysqli [$CFG->dbtype = 'mysqli';]
      1/ enable $CFG->dboptions = array('dbpersist' => 1); in config.php
      2/ ensure database sessions are used.
      3/ try logging in with 4 different user accounts at the same time (using different browsers)
      4/ look for any weird session problems - such as switched accounts, timeouts, logouts

      Show
      0/ obviously setup your test server to use mysqli [$CFG->dbtype = 'mysqli';] 1/ enable $CFG->dboptions = array('dbpersist' => 1); in config.php 2/ ensure database sessions are used. 3/ try logging in with 4 different user accounts at the same time (using different browsers) 4/ look for any weird session problems - such as switched accounts, timeouts, logouts
    • Affected Branches:
      MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w03_MDL-36809_m25_mysqlipers

      Description

      It looks like mysqli in PHP 5.3 supports reliable persistent connections - see http://php.net/manual/en/mysqli.persistconns.php

      This new feature might significantly improve performance, it would be great if somebody could measure it on Moodle server where database is located on different computer.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/May/13