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

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

      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.

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

              Created:
              Updated:
              Resolved:

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