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

log_queries_not_using_index reduce verbosity

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • OTHER
    • 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

      Attachments

        Issue Links

          is blocked by

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

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stephane@skysql.com VAROQUI Stephane created issue -
            stephane@skysql.com VAROQUI Stephane made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Affects Version/s 10.0.16 [ 17900 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            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

            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
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            stephane@skysql.com VAROQUI Stephane made changes -
            Description If set to on , should not log queries if
            - 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
               
            		 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
               
            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?

            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?
            stephane@skysql.com VAROQUI Stephane added a comment -

            Daniel thanks for this useful pointer

            stephane@skysql.com VAROQUI Stephane added a comment - Daniel thanks for this useful pointer
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 59605 ] MariaDB v3 [ 62484 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62484 ] MariaDB v4 [ 130311 ]

            People

              Unassigned Unassigned
              stephane@skysql.com VAROQUI Stephane
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.