macbre/index-digest

Issues

• Process selected checks when --checks / --skip-checks option is provided

  #54 opened 7 years ago
  0

• Unique vs PK... Not necessarily redundant due to unique constraint

  #49 opened 7 years ago
  4

• Conflicting indexes shouldn't result in a suggestion to remove both...

  #48 opened 7 years ago
  2

• queries_not_using_index: handle no matching row in const table

  #44 opened 7 years ago
  0

• Handle SHOW PROCESSLIST results as an input

  #43 opened 7 years ago
  1

• Suggest InnoDB over MyISAM

  #36 opened 7 years ago
  2

• Support more formatters

  #35 opened 7 years ago
  0

• Check for missing primary or unique keys

  #34 opened 7 years ago
  0

• Report text columns that use non-utf collation

  #32 opened 7 years ago
  0

• Report low cardinality indices

  #31 opened 6 years ago
  2

• Test on TravisCI using MySQL 5.7

  #30 opened 7 years ago
  0

• Check timestamp columns if they contain old data

  #28 opened 7 years ago
  0

• Warn on queries which contain wildcards not at the end of LIKE clauses

  #27 opened 7 years ago
  3

• Report full table scan

  #26 opened 7 years ago
  1

• Improve SQL parsing

  #25 opened 7 years ago
  0

• Report queries that use filesort or temporary file

  #20 opened 7 years ago
  0

• Reports queries that do not use indices

  #19 opened 7 years ago
  0

• redundant_indices - show table schema and table / indices size in the context

  #16 opened 7 years ago
  0

• Suggest VARBINARY for storing IP addresses

  #13 opened 7 years ago
  0

• Introduce Database class abstracting MySQL access

  #8 opened 7 years ago
  0

• Report not used columns and tables

  #6 opened 7 years ago
  0

• Report indices and data size for each table

  #5 opened 7 years ago
  0

• Detect redundant indices

  #4 opened 7 years ago
  0

• Generate score for queries based on their indices usage

  #3 opened 7 years ago
  0

• Report not used indices

  #2 opened 7 years ago
  0

• Set up Travis tests

  #1 opened 7 years ago
  0