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
    • Pull Master Diff URL:

      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

            Assignee:
            skodak Petr Skoda
            Reporter:
            skodak Petr Skoda
            Integrator:
            Dan Poltawski Dan Poltawski
            Tester:
            Ankit Agarwal Ankit Agarwal
            Participants:
            Component watchers:
            Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

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