[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 |