Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-2503

LP #1704195: Release lock on table statistics after query plan created | Stop ANALYZE TABLE from flushing table definition cache

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Sveta Smirnova last update 17-11-2017 11:00:23

      Description:
      Under concurrent environment running ANALYZE TABLE could lead to situation when hundreds of tables are in state "Waiting for table flush".

      How to repeat:
      Read https://www.percona.com/blog/2013/02/27/mysql-optimizer-analyze-table-and-waiting-for-tabl...

      Suggested fix:
      Implement new type of lock which holds statistics only and release it immediately after Optimizer creates execution plan.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: