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

Stop ANALYZE TABLE from flushing table definition cache

    XMLWordPrintable

Details

    Description

      It is well known that in concurrent environment running ANALYZE TABLE could lead to situation when hundreds of threads are in state "Waiting for table flush".

      Percona had resolved this problem recently so that ANALYZE TABLE stops flushing affected tables from the table definition cache, see https://bugs.launchpad.net/percona-server/+bug/1704195 , https://github.com/percona/percona-server/pull/1977 etc for more details.

      This is a request to implement the same/similar approach in MariaDB, maybe even 10.1+, but at least 10.3+.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              valerii Valerii Kravchuk
              Votes:
              7 Vote for this issue
              Watchers:
              21 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.