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

LP #1626441: ANALYZE TABLE should remove its table from background stat processing queue

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 01-12-2016 08:29:38

      Copy of http://bugs.mysql.com/bug.php?id=71761:

      [18 Feb 2014 15:03] Laurynas Biveinis
      Description:
      1. An InnoDB table receives many updates and is added to the background stats processing queue.
      2. Updates stop, an ANALYZE TABLE request comes, and the table stats are recalculated.
      3. Some time later, the background stats thread picks up this table and recalculates its stats even though they are already up to date.

      How to repeat:
      Run write workload on a table, stop it, ANALYZE TABLE, observe the background stats thread recalculating its stats again.

      Suggested fix:
      One way to fix it is to add dict_stats_recalc_pool_del(ib_table), guarded by dict_mutex_enter/exit_for_mysql(), to ha_innobase::info_low if(is_analyze || innobase_stats_on_metadata).

        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: