Some DB queries are reported slow as no indices are used
Bug #1505664 reported by
Moshe Elisha
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mistral |
Fix Released
|
High
|
Winson Chan |
Bug Description
When enabling slow SQL log in MariaDB with "log_queries_
Attached is a log of such a setup that has an empty Mistral DB and no work is being done on Mistral.
Taking this log on a setup where Mistral is in active use - might result in more schema / queries that should be improved.
Indexes to add:
class Definition
* is_system
class ActionDefinition
* action_class
class Execution
* type
* project_id
* state
* updated_at
class Environment
* name
class DelayedCall
* execution_time
* processing
class CronTrigger
* workflow_name
* next_execution_time
Changed in mistral: | |
importance: | Undecided → High |
status: | New → Confirmed |
assignee: | nobody → Renat Akhmerov (rakhmerov) |
assignee: | Renat Akhmerov (rakhmerov) → Winson Chan (winson-c-chan) |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
Changed in mistral: | |
milestone: | mitaka-1 → 2.0.0 |
To post a comment you must log in.
TODO(rakhmerov): Add all needed info about what indexes need to be created.