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

add support for mysqli persistent connections

XMLWordPrintable

    • 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

      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.

            skodak Petr Skoda
            skodak Petr Skoda
            Dan Poltawski Dan Poltawski
            Ankit Agarwal Ankit Agarwal
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.