Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-976

Improve use of pipelining when allowLocalInfile is enable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.0.6
    • batch
    • None

    Description

      since allowLocalInfile is enable by default (https://jira.mariadb.org/browse/CONJ-961), different performance optimisation using pipelining are now disable by default.

      'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. To avoid performance regression, driver can do a poor man parsing, to ensure that batching doesn't contain LOAD LOCAL commands, permitting then the use of pipelining (and bulk).

      Attachments

        Activity

          diego dupin Diego Dupin created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Fix Version/s 3.0.6 [ 28200 ]
          diego dupin Diego Dupin made changes -
          Description since allowLocalInfile is enable by default, optimisation using pipelining are most of the time disable.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. A very basic parse to ensure that there is no LOAD LOCAL commands will permit the use of pipelining, permitting better performance results.
          *strong text*since allowLocalInfile is enable by default, optimisation using pipelining are most of the time disable.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. A very basic parse to ensure that there is no LOAD LOCAL commands will permit the use of pipelining, permitting better performance results.
          diego dupin Diego Dupin made changes -
          Description *strong text*since allowLocalInfile is enable by default, optimisation using pipelining are most of the time disable.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. A very basic parse to ensure that there is no LOAD LOCAL commands will permit the use of pipelining, permitting better performance results.
          *strong text*since allowLocalInfile is enable by default (https://jira.mariadb.org/browse/CONJ-961), different performance optimisation using pipelining are now disable by default.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. To avoid performance regression, driver can do a poor man parsing, to ensure that batching doesn't contain LOAD LOCAL commands, permitting then the use of pipelining (and bulk).
          diego dupin Diego Dupin made changes -
          issue.field.resolutiondate 2022-06-02 07:50:03.0 2022-06-02 07:50:03.832
          diego dupin Diego Dupin made changes -
          Component/s batch [ 14105 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Description *strong text*since allowLocalInfile is enable by default (https://jira.mariadb.org/browse/CONJ-961), different performance optimisation using pipelining are now disable by default.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. To avoid performance regression, driver can do a poor man parsing, to ensure that batching doesn't contain LOAD LOCAL commands, permitting then the use of pipelining (and bulk).
          since allowLocalInfile is enable by default (https://jira.mariadb.org/browse/CONJ-961), different performance optimisation using pipelining are now disable by default.

          'LOAD LOCAL INFILE' commands are very unlikly to be used in batch. To avoid performance regression, driver can do a poor man parsing, to ensure that batching doesn't contain LOAD LOCAL commands, permitting then the use of pipelining (and bulk).

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.