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

add support for mysqli persistent connections

    XMLWordPrintable

Details

    • MOODLE_24_STABLE
    • MOODLE_25_STABLE
    • w03_MDL-36809_m25_mysqlipers
    • 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

    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

            skodak Petr Skoda
            skodak Petr Skoda
            Dan Poltawski Dan Poltawski
            Ankit Agarwal Ankit Agarwal
            David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              14/May/13