[MDEV-7566] log_queries_not_using_index reduce verbosity Created: 2015-02-09  Updated: 2015-10-29

Status: Open
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: None

Type: Task Priority: Minor
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Blocks
is blocked by MDEV-7567 rename slow queries variables Closed

 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

 Comments   
Comment by Elena Stepanova [ 2015-02-10 ]

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

Comment by Daniel Black [ 2015-03-31 ]

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

Comment by VAROQUI Stephane [ 2015-03-31 ]

Daniel thanks for this useful pointer

Generated at Thu Feb 08 07:20:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.