[ZBXNEXT-3075] Add more indexes to host_discovery table Created: 2015 Dec 15 Updated: 2021 Nov 10 |
|
| Status: | Open |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Installation (I) |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Change Request | Priority: | Trivial |
| Reporter: | Andris Zeila | Assignee: | Zabbix Development Team |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | dbpatches, index, schema | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
The parent_itemid and parent_hostid fields of host_discovery table are used to find host prototypes and discovered hosts respectively. To improve related SQL selects we should add new indexes to host_discovery table: INDEX |1 |parent_hostid INDEX |2 |parent_itemid |