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

LP #625045: INDEX_STATISTICS can not STATISTICS partition table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by limohao last update 30-03-2016 12:11:33

      using script.txt create table and proc

      table part_date3 is a partitioning table

      table part_date3 is a normal table

      then load data

      call load_data3()
      call load_data4()

      open user statistics

      set global userstat_running =1

      then run

      SELECT * FROM part_date3 p;

      and

      SELECT * FROM part_date4 p;

      output information_schema.INDEX_STATISTICS

      SELECT * FROM information_schema.INDEX_STATISTICS I;

      'test', 'part_date4', 'PRIMARY', 12999
      'mysql', 'proc', 'PRIMARY', 4

      part_date3 index has not STATISTIC.

        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: