Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-570

The default value for max_allowed_packet in my.cnf is too small (1M)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.0.7
    • Icebox
    • MariaDB Server
    • None

    Description

      Build tested: 1.0.7-1

      By default, the max_allowed_packet is setup 1M, which allows up to about 7384 rows of lineitem to be included in the value. This affects both ColumnStore and InnoDB tables. Since we target for data warehousing, We should increase the default value to 4M or higher.

      After increasing the value to 4M, I was able to insert 4x the number of rows.

      I created an Autopilot test (autopilot.systemTest.largeInsert) for this test.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.