This project is not covered by Drupal’s security advisory policy.

Parse pt-query-digest json output from MySQL slow query logs, identify potential indexes and add them when particular column names or column name combinations are found.

This is designed primarily for tables with simple single table queries with simple FROM, WHERE and ORDER BY clauses. It is helpful primarily if you have many large tables with dynamic schemas that can change over time as well as needing to support fairly arbitrary queries.

If you have either tables that have static schemas, queries that are known in advance or are complex (JOINs, sub-queries, calculated fields etc) you are better off crafting your indexes by hand.

Supporting organizations: 
CivicActions
Initial development
Centers for Medicare and Medicaid Services
Initial development

Project information

  • caution Seeking co-maintainer(s)
    Maintainers are looking for help reviewing issues.
  • Project categories: Performance
  • Created by owen barton on , updated
  • shield alertThis project is not covered by the security advisory policy.
    Use at your own risk! It may have publicly disclosed vulnerabilities.

Releases