Traffic Logging into the Database

This allows recording the traffic counters into the database and building a fast and scalable traffic accounting system for your users. To use this feature you should specify:

• Database Connection string
• The name of Database Table for Traffic Logging
• The Traffic Samples parameter

What is the Traffic Samples parameter?

This sets a time interval for a single Traffic Sample. The Traffic Sample is an amount of bytes captured by the specific filter for the time interval started at the specific time.

How does TMeter write the counters into the database?

1. A current value of the "ts" field is derived: 1) from a user-defined Traffic Samples parameter 2) from the current local time. For example, if the current time is 19:49 on August 22, 2003, then
    
   

   User-defined Traffic Samples	Value of ts (in the ymmddhhmi format)
   1 minute	308221949
   5 minutes	308221945
   15 minutes	308221945
   30 minutes	308221930
   1 hours	308221900
   2 hours	308221800
   1 day	308220000

   
    
2. The command "SELECT * FROM traffic_table WHERE ts=308222145" is issued and the database counters stored in the table are retrieved into a temporary counters storage.
3. The counters, unsaved since the last database update are added to the counters stored in the temporary storage.
4. The temporary counter storage is flushed into the database.