[ZBX-4072] improvement of index for acknowledgement Created: 2011 Aug 25 Updated: 2017 May 30 Resolved: 2011 Oct 08 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | None |
| Fix Version/s: | 1.8.9, 2.0.0 |
| Type: | Incident report | Priority: | Blocker |
| Reporter: | Kodai Terashima | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | acknowledges, performance | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Zabbix 1.8 |
||
| Issue Links: |
|
||||
| Description |
|
creation of index objectid, value and eventid field on events table improve acknowledge performance |
| Comments |
| Comment by Alexander Vladishev [ 2011 Sep 27 ] |
|
I think a new index for the table 'events' isn't necessary. Tuning existing SQL statements will be enough. Fixed in the development branches |
| Comment by Alexander Vladishev [ 2011 Sep 28 ] |
|
Available in version pre1.8.9, r2212. |
| Comment by richlv [ 2011 Oct 08 ] |
|
reopen to set "fix version" |