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

Fix table selectivity by sampling some probably very selective predicates

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          There are some predicates like 'table.field LIKE %WORD' which probably very selective but it is impossible judge about them by index or other statistics we collect now.

          We can just check the predicate against some rows in the table.

          In the beginning it will be first N rows of the table.

            Gliffy Diagrams

              Attachments

                Issue Links

                includes

                Task - A task that needs to be done. MDEV-4343 Find selectivity of conditions by reading N first rows of its table

                • Major - Major loss of function.
                • Closed
                relates to

                Task - A task that needs to be done. MDEV-4552 Testing for MDEV-4345 (sampling probably selective predicates)

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  pushed to lp:~maria-captains/maria/maria-10.0-mwl253

                  Show
                  sanja Oleksandr Byelkin added a comment - pushed to lp:~maria-captains/maria/maria-10.0-mwl253
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  It was implemented in 10.0.3 (cannot set the 'Fix version' field because 10.0.3 is archived).

                  Show
                  elenst Elena Stepanova added a comment - It was implemented in 10.0.3 (cannot set the 'Fix version' field because 10.0.3 is archived).

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      sanja Oleksandr Byelkin
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: