Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13195

Connect Engine: INSERT FROM SELECT (or CREATE TABLE AS SELECT) memory leak

    Details

      Description

      Scenario:

      Bash console (it's mandatory to execute from the bash):

      1) mysql -h 127.0.0.1 --port=3306 -u user -ppassword db -e 'DROP TABLE IF EXISTS c1;'
      2) mysql -h 127.0.0.1 --port=3306 -u user -ppassword db -e 'CREATE TABLE c1 ENGINE=CONNECT TABLE_TYPE=MYSQL DBNAME='\''information_schema'\'' OPTION_LIST='\''host=127.0.0.1,port=33235,user=user,password=password'\'' `tabname`='\''tables'\'''
      3) mysql -h 127.0.0.1 --port=3306 -u user -ppassword db -e 'CREATE TABLE t1 AS SELECT * FROM c1'

      This scenario leads to spending an additional 500 MB (equal to value of "connect_work_size" variable) of virtual memory for each repetition. This memory is not released until you restart the mysql process. Remote database name and a table - can be any.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bertrandop Olivier Bertrand
                Reporter:
                Sergey.Antonyuk Sergey Antonyuk
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: