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

CS Install/Upgrade chown mysql:mysql /var/lib/columnstore performance

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None

    Description

      On large customer deployments, the following takes a very long time when using the yum package manager.

      chown mysql:mysql /var/lib/columnstore/
      

      For rpms i have this work around

      # rpm -Uvh MariaDB-columnstore-engine-10.6.7[version].centos.x86_64.rpm --noscripts
          * Edit the file /bin/columnstore-post-install and comment out line 357
          * Manually run the two commands that the install script would normally run automatically:
      # mkdir -p /var/lib/columnstore/local (this may already exist, only run it if need be)
      # columnstore-post-install --rpmmode=install
      

      Ideally columnstore might search for files not own by mysql or count if none skip. Or provide an easy method to skip this check on upgrade. The current brute force method makes upgrading customers production take super long when downtime is most critical and needs to be as fast as possible often.

      Attachments

        Activity

          People

            Unassigned Unassigned
            allen.herrera Allen Herrera
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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