Bug #18110
closed
Unused index on table Ruddersysevents
Added by Nicolas CHARLES over 4 years ago.
Updated almost 4 years ago.
Category:
Performance and scalability
Description
We have an index on keyvalue, dating from when we searched on keyvalue for compliance (pre 5.0)
0 query use it, we can safely remove it
It saves about 10%-20% of table ruddersysevent
- Status changed from New to In progress
- Assignee set to Nicolas CHARLES
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to François ARMAND
- Pull Request set to https://github.com/Normation/rudder/pull/3172
- Pull Request changed from https://github.com/Normation/rudder/pull/3172 to https://github.com/Normation/rudder/pull/3199
- Status changed from Pending technical review to Pending release
This bug has been fixed in Rudder 6.2.0~beta1 which was released today.
- Fix check changed from To do to Checked
- Related to Bug #18111: create migration script to remove index on keyvalue added
- Status changed from Pending release to Released
Also available in: Atom
PDF