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

log_queries_not_using_index reduce verbosity

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.1
        • Component/s: OTHER
        • Labels:
          None

          Description

          introduce log_slow_queries_not_using_indexes_filter='possible_keys, empty_table, small_table, small_table_first_pos'

          • A possible key is found for the plan but not used
          • Table is empty or less than 1 records
          • Table is alone in the plan and less 1000 records
          • Table is first in the plan less 1000 records and other tables are const or equ_ref

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Task - A task that needs to be done. MDEV-7567 rename slow queries variables

                • Major - Major loss of function.
                • Open

                  Activity

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

                  Also, there is log_throttle_queries_not_using_indexes introduced in 5.6: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_log_throttle_queries_not_using_indexes

                  Show
                  elenst Elena Stepanova added a comment - Also, there is log_throttle_queries_not_using_indexes introduced in 5.6: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_log_throttle_queries_not_using_indexes
                  Hide
                  Permalink
                  danblack Daniel Black added a comment -

                  You have seen min_examined_row_limit applies a filter for the slow query log based on the rows?

                  Show
                  danblack Daniel Black added a comment - You have seen min_examined_row_limit applies a filter for the slow query log based on the rows?
                  Hide
                  Permalink
                  stephane@skysql.com VAROQUI Stephane added a comment -

                  Daniel thanks for this useful pointer

                  Show
                  stephane@skysql.com VAROQUI Stephane added a comment - Daniel thanks for this useful pointer

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      stephane@skysql.com VAROQUI Stephane
                    • Votes:
                      1 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated: