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

Insert starts analyze table caulsing the insert process to be blocked with use_stat_tables = PREFERABLY

    Details

      Description

      We have a loader job that runs inserts into 250GB database which gets blocked by analyze process (I suppose the auto analyze).

      turning off innodb_stats_auto_recalc does not help.

      Is there any other dependent parameter that needs to be changed .

      Looks like a reproducible issue.

      If I change use_stat_tables = NEVER (default) there is no blocking since the analyze does not run with cost based optimization not used.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Viswanathan Ramesh
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: