Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5548

Fast index creation doesn't update statistics

        Details

          Description

          Adding an index to innodb table using "fast index creation" doesn't properly update statistics for this index (every index part gets cardinality around 200 for table with > 1000 rows).

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #62516 - Fast index creation does not update index statistics

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Upstream bug http://bugs.mysql.com/bug.php?id=62516.
                  Reproducible on all MariaDB 5.x and on MySQL 5.5 (I disagree with the last comment by Laurynas Biveinis in the MySQL bug report, it seems reproducible just fine to me).
                  Not reproducible on MySQL 5.6.10 and MariaDB 10.0.7, apparently the WLs that Marko Mäkelä mentioned were merged all right into 10.0 tree.

                  Show
                  elenst Elena Stepanova added a comment - Upstream bug http://bugs.mysql.com/bug.php?id=62516 . Reproducible on all MariaDB 5.x and on MySQL 5.5 (I disagree with the last comment by Laurynas Biveinis in the MySQL bug report, it seems reproducible just fine to me). Not reproducible on MySQL 5.6.10 and MariaDB 10.0.7, apparently the WLs that Marko Mäkelä mentioned were merged all right into 10.0 tree.
                  Hide
                  Permalink
                  jplindst Jan Lindström added a comment -

                  In my opinion that change is too big for GA versions.

                  Show
                  jplindst Jan Lindström added a comment - In my opinion that change is too big for GA versions.

                    People

                    • Assignee:
                      jplindst Jan Lindström
                      Reporter:
                      pomyk Patryk Pomykalski
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: