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

Investigate potential usage of MYSQLI_STORE_RESULT_COPY_DATA mode in get_recordset_sql()

    XMLWordPrintable

Details

    • Task
    • Resolution: Won't Do
    • Minor
    • None
    • 3.1.2
    • Database SQL/XMLDB
    • None
    • MOODLE_31_STABLE

    Description

      In the issue MDL-55987 it was confirmed that the current MYSQLI_STORE_RESULT mode of mysqli query can really lead to memory issues as the inline comments predict.

      Recent versions of the mysql driver (available with mysqlnd only, since PHP 5.6.0) offer new mode MYSQLI_STORE_RESULT_COPY_DATA that does not seem to be fully documented yet, but it expresses better behaviour in terms of memory management (with the trade off of the perceived performance but we do not have any stats figures at this moment).

      See the whole story in MDL-55987 comments.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mudrd8mz David Mudrák (@mudrd8mz)
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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