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

    XMLWordPrintable

    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: