[ZBXNEXT-2495] Index by value and lastchange in trigger table Created: 2014 Oct 06 Updated: 2019 Mar 26 Resolved: 2015 Apr 21 |
|
| Status: | Closed |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Installation (I) |
| Affects Version/s: | 2.2.7 |
| Fix Version/s: | 2.5.0 |
| Type: | Change Request | Priority: | Major |
| Reporter: | Oleg Egorov (Inactive) | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | improvements, index, performance, trigger | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
In trigger table now exist index by value (triggers_2) But if change it to value and lastchange. Performance in maps will be improved up to 10 times. As example see |
| Comments |
| Comment by Alexander Vladishev [ 2015 Apr 13 ] |
|
Available in the development branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-2495 |
| Comment by Igors Homjakovs (Inactive) [ 2015 Apr 17 ] |
|
Successfully tested. |
| Comment by Alexander Vladishev [ 2015 Apr 21 ] |
|
Available in pre-2.5.0 r53275. |
| Comment by Oleksii Zagorskyi [ 2017 Feb 08 ] |
|
The index change was earlier requested in |