547
edits
Longterm DB: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==Description== | ==Description== | ||
The Longterm DB feature (in firmware >= 4.3) uses an attached storage devices to store traffic information of IP addresses with low resolution for a much longer time than the live statistics. | The Longterm DB feature (in firmware >= 4.3) uses an attached storage devices to store traffic information of IP addresses and Layer 7 protocols with low resolution for a much longer time than the live statistics. | ||
The stored data | The elements stored in the longterm DB are as follows, graph data is available in 5 minute resolution: | ||
* IP addresses | |||
*# activity time | |||
*# traffic graph in 5 minute resolution | |||
* Layer 7 protocols | |||
*# traffic graph in 5 minute resolution | |||
The storage is used similar to a swap file mechanism so the longterm data is not kept between restart unless the [[DB persistence]] feature is enabled too, which is recommended when using the longterm feature. To reduce the amount of time to dump/restore, the DB persistence configuration allow to skip storing live data. | The storage is used similar to a swap file mechanism so the longterm data is not kept between restart unless the [[DB persistence]] feature is enabled too, which is recommended when using the longterm feature. To reduce the amount of time to dump/restore, the DB persistence configuration allow to skip storing live data. | ||
| Line 53: | Line 59: | ||
== Limitations == | == Limitations == | ||
# The data in the longterm DB | # The data in the longterm DB is limited to a selected subset of the data in the In-Memory-DB. See above for an exact list of elements available. | ||
# The data is written into the longterm DB in variable intervals depending on traffic and system load. It takes up to 10 minutes (two graph intervals) until the data appears in the graph. Therefore, the last 5-10 minutes appear empty or with less traffic than in live view. | # The data is written into the longterm DB in variable intervals depending on traffic and system load. It takes up to 10 minutes (two graph intervals) until the data appears in the graph. Therefore, the last 5-10 minutes appear empty or with less traffic than in live view. | ||