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

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

    XMLWordPrintable

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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.