active ip collector is insanely slow
Bug #1103455 reported by
John-Magne Bredal
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Network Administration Visualized |
Fix Released
|
Critical
|
John-Magne Bredal | ||
Bug Description
The active ip collector stores the number of active ip addresses on a prefix every 30 minutes. However the collection of this data is very slow and, depending on the size of the arp table, often takes more than 30 minutes.
Fix the queries so that it has one query for collecting now and one for collecting and filling historic data.
| Changed in nav: | |
| assignee: | nobody → John-Magne Bredal (john-m-bredal) |
| importance: | Undecided → Critical |
| status: | New → Fix Committed |
| milestone: | none → 3.12.5 |
| milestone: | 3.12.5 → 3.13.0 |
Revision history for this message
| John-Magne Bredal (john-m-bredal) wrote | #1 |
Revision history for this message
| John-Magne Bredal (john-m-bredal) wrote | #2 |
| Changed in nav: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Two things done:
- A separate query for collecting historic data and one for collecting updates
- After some trial and error it seems that putting some kind of constraint on the ip field in the arp table (without limiting the result set) radically speeds up the execution. Unknown reason, but implemented anyway.