InfluxDB Schema

An InfluxDB schema refers to the structure of a time-series database. Below is a list of some examples of the time-series schemas contained in ntopng. Each table below contains four columns:

Schema: Represents the unique identifier of the schema
Tags: Lists relevant identifiers or attributes associated with the schema
Step: Indicates the time interval (in seconds) at which the metric is measured
Metrics: Details the specific data points or measurements tracked, such as counts, traffic volume, or packet details.
Description: Describes the schema In ntopng, there are five classifications based on the length of the step for the time-series data.

List of schemas with a step of 1 second: scripts/lua/modules/timeseries/schemas/ts_second.lua +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | Schema | Tags | Step | Metrics | Description | +============================================+===========================+================+=======================================+=================================================================================+ | iface:traffic | ifid | 1 | bytes | Total traffic in bytes per interface | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | iface:traffic_rxtx | ifid | 1 | bytes_sent, bytes_rcvd | Bytes sent and received per interface | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | iface:traffic_ip | ifid | 1 | bytes_ipv4, bytes_ipv6 | IPv4 and IPv6 traffic per interface | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+

List of schemas with a step of 5 seconds: scripts/lua/modules/timeseries/schemas/ts_5sec.lua +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | Schema | Tags | Step | Metrics | Description | +============================================+===========================+================+=======================================+=================================================================================+ | system:cpu_states | ifid | 5 | iowait_pct, active_pct, idle_pct | System CPU states | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | system:cpu_load | ifid | 5 | load_percentage | System CPU load | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | iface:ts_queue_length | ifid | 5 | num_ts | Timeseries write queue length | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+

List of schemas with a step of 1 minute: scripts/lua/modules/timeseries/schemas/ts_minute.lua +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | Schema | Tags | Step | Metrics | Description | +============================================+===========================+================+=======================================+=================================================================================+ | periodic_script:duration | ifid, periodic_script | 60 | num_ms_last | Duration in milliseconds for the last execution of the periodic script | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | periodic_script:timeseries_writes | ifid, periodic_script | 60 | writes, drops | Number of successful writes and drops for timeseries | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+ | ht:state | ifid, hash_table | 60 | num_idle, num_active | State of the hash table (idle and active entries) | +--------------------------------------------+---------------------------+----------------+---------------------------------------+---------------------------------------------------------------------------------+

List of schemas with a step of 5 minutes: scripts/lua/modules/timeseries/schemas/ts_5min.lua +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | Schema | Tags | Step | Metrics | Description | +============================================+===========================+================+=======================================+===================================================================================+ | mac:traffic | ifid, mac | 300 | bytes_sent, bytes_rcvd | Sent and received bytes for a specific MAC address | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | mac:arp_rqst_sent_rcvd_rpls | ifid, mac | 300 | request_pkts_sent, reply_pkts_rcvd | ARP requests sent and replies received for a specific MAC address | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | country:score | ifid, country | 300 | score, scoreAsClient, scoreAsServer | Scores for a specific country, both as a client and server | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+

List of schemas with a step of 1 hour: scripts/lua/modules/timeseries/schemas/ts_hour.lua +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | Schema | Tags | Step | Metrics | Description | +============================================+===========================+================+=======================================+===================================================================================+ | am_host:val_hour | ifid, host, metric | 3600 | value | Hourly active monitoring measurements related to a host | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | am_host:http_stats_hour | ifid, host, metric | 3600 | lookup_ms, other_ms | Hourly active monitoring of HTTP measurements related to a host | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+ | am_host:https_stats_hour | ifid, host, metric | 3600 | lookup_ms, connect_ms, other_ms | Hourly active monitoring of HTTPS measurements related to a host | +--------------------------------------------+---------------------------+----------------+---------------------------------------+-----------------------------------------------------------------------------------+