Open Bug 1387509 Opened 7 years ago Updated 2 years ago

Enable logging of queries that aren't using indexes to the MySQL slow query log

Categories

(Tree Management :: Treeherder, enhancement, P4)

Product:
Tree Management
Component:
Treeherder
Type:
enhancement

Tracking

(Not tracked)

People

(Reporter: emorley, Unassigned)

References

Details

By default the MySQL slow query log only logs queries that are already using indexes. This will give us more to work with for bug 1387508.

We'll likely need to also set `log_throttle_queries_not_using_indexes` to ensure the slow query log isn't overwhelmed by the number of queries.

See:
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_queries_not_using_indexes
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Assignee: emorley → nobody
Status: ASSIGNED → NEW
Priority: P2 → P3
Component: Treeherder: Infrastructure → Database
Priority: P3 → P4
Component: Database → TreeHerder
You need to log in before you can comment on or make changes to this bug.