Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  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.

        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:

                Smart Checklist