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

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              valerii Valerii Kravchuk
            • Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

              • Created:
                Updated: