wiki:Tutorials/c0WiFi/Tutorial5

WiSHFUL Tutorial: WiFi QoS Management

Table of Contents

  1. WiFi Tutorials
    1. Using Noise Generator in Experiments
    1. WiFi Tutorial: Access point with multiple clients
      1. Prerequisites
      2. About This Experiment
      3. Experiment Script
      4. Dissecting the Experiment
      5. Executing the Experiment Script
      6. Retrieving Results
      7. Troubleshooting
      8. Final Observations
    1. Wifi Tutorial: Data logging with OMF
      1. Experiment Script
      2. Executing the Experiment Script
      3. Experiment Results
    1. WiSHFUL Tutorial: WiFi QoS Management
      1. About This Experiment
      2. Experiment Script
      3. Experiment Execution

Prerequisites

This tutorial series assumes you have an ​ORBIT account, have ​scheduled a session on the ORBIT testbed, are familiar with ​SSH'ing into the testbed itself, and are familiar with the ​basics of running ORBIT experiments. If you have not done these things yet, you may wish to do so before taking a look at this slightly more advanced experiment. If you are unfamiliar with or are entirely new to ORBIT, you may wish to start ​here.

About This Experiment

In this tutorial, ​WiSHFUL platform is used for WiFi EDCA management. Four nodes are used as nodes of system under test, wile fifth node is used as a WiSHFUL controller. The four nodes are split into two AP - client setups sharing the same channel and running [iperf] application to measure network bandwidth. WiFi QoS manager implemented as WiSHFUL controller will modify EDCA parameters of one of the flows changeing the bandwith allocation. Instance of iperf on all nodes is logging bandwidth measurements in the central OML server running on the console. The actual experiment script assumes usage of reference WiSHFUL image ('''wishful.ndz''') and is explicitly designed for use in SB4 (if you want to run this tutorial on a different domain or with a different set of nodes, you have to modify controller configuration file in the image).

Experiment Script

The OMF experiment script wishful_edca.rb​ is used to execute WiSHFUL control programs.

Experiment Execution

Image the nodes: 

omf load -t node1-3,node1-4,node1-5,node1-6,node2-1 -i wishful.ndz

and turn them on: 

omf tell -a on -t system:topo:imaged

wget http://www.orbit-lab.org/raw-attachment/wiki/Tutorials/c0WiFi/Tutorial5/wishful_edca.rb

and, after an optional minute wait, execute the script 

omf exec wishful_edca.rb

The output should look similar to: 

user@console.sb4:~# omf exec wishful_edca.rb

 INFO NodeHandler: OMF Experiment Controller 5.4 (git 861d645)
 INFO NodeHandler: Reading configuration file /etc/omf-expctl-5.4/services.yaml
 INFO NodeHandler: Add domain http - http://internal1.orbit-lab.org:5054/
 INFO NodeHandler: Add domain http - http://repository1.orbit-lab.org:5054/
 INFO NodeHandler: Add domain http - http://internal2dmz.orbit-lab.org:5054/
 INFO NodeHandler: Add domain http - http://external1.orbit-lab.org:5054/
 INFO NodeHandler: Slice ID: default_slice (default)
 INFO NodeHandler: Experiment ID: default_slice-2016-06-10t09.01.04.779-04.00
 INFO NodeHandler: Message authentication is disabled
 INFO Experiment: load system:exp:stdlib
 INFO property.resetDelay: resetDelay = 230 (Fixnum)
 INFO property.resetTries: resetTries = 1 (Fixnum)
 INFO Experiment: load system:exp:eventlib
 INFO Experiment: load system:exp:winlib
 INFO Experiment: load wishful_edca.rb
 INFO property.contr: contr = "node2-1" (String)
 INFO property.path: path = "/root/wishful/examples/edca/" (String)
 INFO property.accesspoints: accesspoints = "node1-3,node1-5" (String)
 INFO property.clients: clients = "node1-4,node1-6" (String)
 INFO property.channel: channel = 11 (Fixnum)
 INFO property.duration: duration = 60 (Fixnum)
 INFO ALL_UP_AND_INSTALLED: Event triggered. Starting the associated tasks.
 INFO exp: Wait for all nodes to come up
 INFO exp: Request from Experiment Script: Wait for 20s....
 INFO BRING_UP: Event triggered. Starting the associated tasks.
 INFO Experiment: Bringing up resources
 INFO exp: Both controller and agent are started; running for 60
 INFO exp: Request from Experiment Script: Wait for 60s....
 INFO exp: Both controller and agent are stopped...
 INFO EXPERIMENT_DONE: Event triggered. Starting the associated tasks.
 INFO NodeHandler: 
 INFO NodeHandler: Shutting down experiment, please wait...
 INFO NodeHandler: 
 INFO run: Experiment default_slice-2016-06-10t09.01.04.779-04.00 finished after 1:30

To recover experiment data to the local machine, and using the experiment ID: 

wget "http://oml:5054/result/dumpDatabase?expID=<your_experiment_ID>" -O myDatabase
  • If the experiment ID contains non-alphanumeric ASCII characters, it is necessary to escape each of them using "%" followed by the ASCII code.

In order to get SQLite to recognize the database, it first must be told that the information is a database. 

sqlite3 -init myDatabase myDatabase.sq3

You can also view the results in a web browser by visiting the following URL: 

http://console.sb4.orbit-lab.org:5054/result/dumpDatabase?expID=<your_experiment_ID>

For the experiment execution above, the results can be obtained by observing that Experiment ID: default_slice-2016-06-10t09.01.04.779-04.00 and loading the URL 

http://console.sb4.orbit-lab.org:5054/result/dumpDatabase?expID=default_slice-2016-06-10t09.01.04.779-04.00

The resulting abbreviated output is: 

--
-- Database Dump
-- Experiment ID: default_slice-2016-06-10t09.01.04.779-04.00
--
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE _senders (name TEXT PRIMARY KEY, id INTEGER UNIQUE);
INSERT INTO "_senders" VALUES('0',1);
INSERT INTO "_senders" VALUES('1',2);
CREATE TABLE "_experiment_metadata" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "subject" TEXT, "key" TEXT, "value" TEXT);
INSERT INTO "_experiment_metadata" VALUES(1,NULL,NULL,NULL,NULL,NULL,'table__experiment_metadata','0 _experiment_metadata subject:string key:string value:string');
INSERT INTO "_experiment_metadata" VALUES(2,NULL,NULL,NULL,NULL,NULL,'start_time','1465563690');
INSERT INTO "_experiment_metadata" VALUES(3,NULL,NULL,NULL,NULL,NULL,'table__client_instrumentation','1 _client_instrumentation measurements_injected:uint32 measurements_dropped:uint32 bytes_allocated:uint64 bytes_freed:uint64 bytes_in_use:uint64 bytes_max:uint64');
INSERT INTO "_experiment_metadata" VALUES(4,NULL,NULL,NULL,NULL,NULL,'table_iperf_application','2 iperf_application pid:guid version:string cmdline:string starttime_s:int32 starttime_us:int32');
INSERT INTO "_experiment_metadata" VALUES(5,NULL,NULL,NULL,NULL,NULL,'table_iperf_settings','3 iperf_settings pid:guid server_mode:int32 bind_address:string multicast:int32 multicast_ttl:int32 transport_protocol:int32 window_size:int32 buffer_size:int32');
INSERT INTO "_experiment_metadata" VALUES(6,NULL,NULL,NULL,NULL,NULL,'table_iperf_connection','4 iperf_connection pid:guid connection_id:guid local_address:string local_port:int32 remote_address:string remote_port:int32');
INSERT INTO "_experiment_metadata" VALUES(7,NULL,NULL,NULL,NULL,NULL,'table_iperf_transfer','5 iperf_transfer pid:guid connection_id:guid begin_interval:double end_interval:double size:uint64');
INSERT INTO "_experiment_metadata" VALUES(8,NULL,NULL,NULL,NULL,NULL,'table_iperf_losses','6 iperf_losses pid:guid connection_id:guid begin_interval:double end_interval:double total_datagrams:int32 lost_datagrams:int32');
INSERT INTO "_experiment_metadata" VALUES(9,NULL,NULL,NULL,NULL,NULL,'table_iperf_jitter','7 iperf_jitter pid:guid connection_id:guid begin_interval:double end_interval:double jitter:double');
INSERT INTO "_experiment_metadata" VALUES(10,NULL,NULL,NULL,NULL,NULL,'table_iperf_packets','8 iperf_packets pid:guid connection_id:guid packet_id:int32 packet_size:int32 packet_time_s:int32 packet_time_us:int32 packet_sent_time_s:int32 packet_sent_time_us:int32');
INSERT INTO "_experiment_metadata" VALUES(11,1,1,7.30248999781906604766e-01,6.64401999999999937074e-01,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(12,1,2,0.730273999273777,0.664441,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(13,1,3,7.30275999754667282104e-01,0.664451,'.','cmdline','/usr/bin/iperf-oml2 -y O -s O --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -s');
INSERT INTO "_experiment_metadata" VALUES(14,1,1,7.30248999781906604766e-01,0.66447,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(15,1,2,0.730273999273777,0.664526,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(16,1,3,7.30275999754667282104e-01,0.664535,'.','cmdline','/usr/bin/iperf-oml2 -y O -s O --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -s');
INSERT INTO "_experiment_metadata" VALUES(17,1,1,9.61976999416947364807e-01,0.664928,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(18,1,2,9.61991999298334121704e-01,6.6494199999999992201e-01,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(19,1,3,9.6200299914926290512e-01,6.64953999999999934011e-01,'.','cmdline','/usr/bin/iperf-oml2 -y O -s O --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -s');
INSERT INTO "_experiment_metadata" VALUES(20,1,1,9.61976999416947364807e-01,6.64968999999999921257e-01,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(21,1,2,9.61991999298334121704e-01,0.665026,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(22,1,3,9.6200299914926290512e-01,6.65034999999999931752e-01,'.','cmdline','/usr/bin/iperf-oml2 -y O -s O --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -s');
INSERT INTO "_experiment_metadata" VALUES(23,2,1,2.68745409995317459102e+01,26.631372,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(24,2,2,2.68745549991726875296e+01,26.781102,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(25,2,3,2.687456699926406145e+01,26.781129,'.','cmdline','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20 --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -t 20');
INSERT INTO "_experiment_metadata" VALUES(26,2,1,2.68745409995317459102e+01,26.78114,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(27,2,2,2.68745549991726875296e+01,26.781169,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(28,2,3,2.687456699926406145e+01,26.781178,'.','cmdline','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20 --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -t 20');
INSERT INTO "_experiment_metadata" VALUES(29,2,1,2.71345789998304098844e+01,26.781887,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(30,2,2,2.71346039997879415759e+01,2.67818979999999982064e+01,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(31,2,3,2.71346059998031705626e+01,26.781938,'.','cmdline','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20 --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -t 20');
INSERT INTO "_experiment_metadata" VALUES(32,2,1,2.71345789998304098844e+01,26.781946,'.','appname','iperf');
INSERT INTO "_experiment_metadata" VALUES(33,2,2,2.71346039997879415759e+01,26.781958,'.','version','2.11.0');
INSERT INTO "_experiment_metadata" VALUES(34,2,3,2.71346059998031705626e+01,26.781965,'.','cmdline','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20 --oml-server oml:3003 --oml-exp-id default_slice-2016-06-10t09.01.04.779-04.00 -t 20');
CREATE TABLE "_client_instrumentation" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "measurements_injected" UNSIGNED INTEGER, "measurements_dropped" UNSIGNED INTEGER, "bytes_allocated" UNSIGNED BIGINT, "bytes_freed" UNSIGNED BIGINT, "bytes_in_use" UNSIGNED BIGINT, "bytes_max" UNSIGNED BIGINT);
INSERT INTO "_client_instrumentation" VALUES(1,1,1,7.30261999182403087615e-01,6.64478999999999930814e-01,1,0,35330,15766,19564,21289);
INSERT INTO "_client_instrumentation" VALUES(2,1,1,9.61989999748766422271e-01,0.664978,1,0,35330,15766,19564,21289);
INSERT INTO "_client_instrumentation" VALUES(3,2,1,2.68745529996231198306e+01,26.781148,1,0,35330,15766,19564,21289);
INSERT INTO "_client_instrumentation" VALUES(4,1,2,2.70340389907360076912e+01,26.781314,1,0,39558,19417,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(5,1,2,2.67115789949893951411e+01,26.781397,1,0,39558,19417,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(6,2,1,27.1345919999294,26.781952,1,0,35330,15766,19564,21289);
INSERT INTO "_client_instrumentation" VALUES(7,1,3,2.70129119753837585457e+01,26.940808,17,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(8,2,2,2.7781223999336361885e+01,27.536649,1,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(9,2,2,2.81708319988101720801e+01,27.701432,2,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(10,1,3,2.80057679712772369376e+01,27.706225,114,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(11,2,3,2.80977949984371662139e+01,27.85319,2,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(12,1,4,2.80057809948921203613e+01,27.933659,151,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(13,1,4,2.9003846973180770874e+01,28.704269,301,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(14,2,3,2.91962629966437816611e+01,28.726833,4,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(15,1,5,2.9003676980733871459e+01,28.931543,371,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(16,2,4,2.93127429969608783721e+01,29.1752,5,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(17,1,5,3.00062709748744964603e+01,29.706658,508,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(18,2,5,3.00703979954123497004e+01,29.825767,7,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(19,1,6,3.00034049749374389639e+01,29.931197,579,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(20,2,4,3.04460669979453086848e+01,29.976623,7,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(21,1,6,3.10042159855365753165e+01,30.704597,725,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(22,2,5,31.2748069986701,30.805343,9,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(23,1,7,3.10044999718666076655e+01,30.932287,800,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(24,2,6,3.12099489942193031311e+01,30.965286,10,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(25,2,6,3.2075513996183872222e+01,31.606047,11,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(26,1,7,3.20075639486312866219e+01,31.707934,934,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(27,1,8,3.20049169659614562988e+01,31.932628,999,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(28,2,7,3.22397009953856468196e+01,31.995029,12,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(29,1,8,3.3007899999618530273e+01,32.708231,1151,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(30,2,8,3.3058653995394706726e+01,32.813962,14,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(31,2,7,3.33647639974951744075e+01,32.895279,14,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(32,1,9,3.30040469765663146972e+01,32.931721,1211,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(33,1,9,34.0037339925766,33.70408,1350,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(34,2,8,3.42258349955081939705e+01,33.756295,16,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(35,1,10,3.40075799822807312011e+01,33.935257,1418,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(36,2,9,3.42833709865808486947e+01,3.41527870000000035579e+01,17,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(37,2,9,3.50912769883871078491e+01,34.621755,18,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(38,1,10,3.50031719803810119633e+01,34.703471,1560,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(39,1,11,3.50042579770088195805e+01,34.931905,1612,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(40,2,10,3.52719179987907409672e+01,35.143509,19,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(41,1,11,3.60031589865684509277e+01,35.703463,1788,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(42,2,10,3.62123109996318817129e+01,35.74275,21,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(43,1,12,3.60031059980392456046e+01,35.930702,1840,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(44,2,11,3.62352139949798583988e+01,35.990454,21,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(45,1,12,3.7004411995410919189e+01,36.704704,2000,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(46,2,12,3.70716489851474761962e+01,36.826857,24,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(47,2,11,3.73297969996929168701e+01,36.860203,23,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(48,1,13,3.70047229528427124023e+01,36.932288,2045,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(49,1,13,3.8004593968391418457e+01,37.704846,2198,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(50,2,12,3.81936279982328414916e+01,37.724015,26,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(51,1,14,3.80142779946327209472e+01,37.941815,2251,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(52,2,13,38.4186489880085,38.173843,27,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(53,2,13,3.90433079898357391366e+01,38.573699,28,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(54,1,14,3.90084779858589172354e+01,38.708732,2421,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(55,1,15,3.90046509504318237313e+01,38.932172,2477,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(56,2,14,3.93293439894914627075e+01,39.150918,29,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(57,1,15,4.00059019923210144051e+01,39.70613,2618,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(58,2,15,4.00273769944906234732e+01,39.782555,31,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(59,1,16,4.00049479603767395036e+01,39.932413,2701,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(60,2,14,4.04227859973907470685e+01,39.95313,31,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(61,1,16,4.10041639804840087881e+01,40.704372,2837,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(62,2,15,4.12174219936132431047e+01,40.747753,33,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(63,2,16,4.11109419912099838256e+01,40.866112,34,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(64,1,17,4.10085979700088500967e+01,40.936049,2907,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(65,2,16,4.20935109853744506827e+01,41.623838,35,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(66,1,17,4.20188709497451782235e+01,41.719037,3055,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(67,2,17,4.20899809896945953369e+01,41.845138,36,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(68,1,18,4.20069729685783386239e+01,41.934394,3103,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(69,2,17,4.31773329973220825177e+01,42.7076,38,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(70,1,18,4.30140099525451660147e+01,42.714141,3281,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(71,1,19,4.30031389594078063956e+01,42.930543,3320,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(72,2,18,4.31978919804096221906e+01,42.953006,38,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(73,2,18,4.40306629836559295645e+01,43.560928,40,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(74,1,19,4.4005901992321014406e+01,43.706045,3494,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(75,2,19,4.40777549743652343741e+01,43.832842,40,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(76,1,20,4.4003269970417022705e+01,43.930634,3528,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(77,1,20,4.50042749643325805646e+01,44.70439,3697,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(78,2,19,4.51787939965724945085e+01,44.709032,42,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(79,1,21,4.50042819976806640625e+01,44.931576,3735,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(80,2,20,4.52707509994506835954e+01,45.163593,43,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(81,2,20,4.60295249819755554216e+01,45.559765,44,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(82,1,21,4.60172069668769836417e+01,45.71731,3895,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(83,2,21,4.61048889756202697745e+01,45.859933,45,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(84,1,22,4.60247329473495483389e+01,45.952034,3961,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(85,1,22,4.70053049921989440917e+01,46.705481,4103,0,39638,19497,20141,21541);
INSERT INTO "_client_instrumentation" VALUES(86,2,21,4.71887479722499847412e+01,46.718951,47,0,39676,19488,20188,21613);
INSERT INTO "_client_instrumentation" VALUES(87,1,23,4.70097019672393798836e+01,46.936949,4168,0,39638,19497,20141,21541);
CREATE TABLE "iperf_application" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "version" TEXT, "cmdline" TEXT, "starttime_s" INTEGER, "starttime_us" INTEGER);
INSERT INTO "iperf_application" VALUES(1,1,1,7.3027899954468011856e-01,0.664543,833850270123997830,'2.11.0','/usr/bin/iperf-oml2 -y O -s',1465563690,730277);
INSERT INTO "iperf_application" VALUES(2,1,1,9.62005999870598316192e-01,6.65042999999999939753e-01,6316594332143149512,'2.11.0','/usr/bin/iperf-oml2 -y O -s',1465563690,962004);
INSERT INTO "iperf_application" VALUES(3,2,1,2.68745709992945194235e+01,2.67811859999999981587e+01,-3544341636566083228,'2.11.0','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20',1465563716,874568);
INSERT INTO "iperf_application" VALUES(4,2,1,2.71346089998260140427e+01,26.78197,-4638133553200985154,'2.11.0','/usr/bin/iperf-oml2 -c 192.168.0.1 -i 5 -y O -t 20',1465563717,134607);
CREATE TABLE "iperf_settings" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "server_mode" INTEGER, "bind_address" TEXT, "multicast" INTEGER, "multicast_ttl" INTEGER, "transport_protocol" INTEGER, "window_size" INTEGER, "buffer_size" INTEGER);
INSERT INTO "iperf_settings" VALUES(1,1,1,7.31554999947547912597e-01,0.664581,833850270123997830,0,'0.0.0.0',0,0,6,87380,131072);
INSERT INTO "iperf_settings" VALUES(2,1,1,9.62284999899566173553e-01,0.66508,6316594332143149512,0,'0.0.0.0',0,0,6,87380,131072);
INSERT INTO "iperf_settings" VALUES(3,2,1,2.68817029995843768128e+01,26.781207,-3544341636566083228,1,'0.0.0.0',0,0,6,87040,131072);
INSERT INTO "iperf_settings" VALUES(4,2,1,2.71957059998530894509e+01,26.781977,-4638133553200985154,1,'0.0.0.0',0,0,6,87040,131072);
CREATE TABLE "iperf_connection" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "connection_id" UNSIGNED BIGINT, "local_address" TEXT, "local_port" INTEGER, "remote_address" TEXT, "remote_port" INTEGER);
INSERT INTO "iperf_connection" VALUES(1,1,1,2.70340309739112854008e+01,26.781242,6316594332143149512,-3379649244129461518,'192.168.0.1',5001,'192.168.0.2',33018);
INSERT INTO "iperf_connection" VALUES(2,1,2,2.7034040987491607666e+01,26.781322,6316594332143149512,-510027827797102319,'192.168.0.1',0,'192.168.0.2',0);
INSERT INTO "iperf_connection" VALUES(3,1,1,2.67115709781646728506e+01,26.781355,833850270123997830,5407760560782721986,'192.168.0.1',5001,'192.168.0.2',39692);
INSERT INTO "iperf_connection" VALUES(4,1,2,2.67115819752216339106e+01,26.781405,833850270123997830,3968755486798925933,'192.168.0.1',0,'192.168.0.2',0);
INSERT INTO "iperf_connection" VALUES(5,2,1,2.68817159999161958694e+01,26.781674,-3544341636566083228,-6410456378195227249,'192.168.0.2',39692,'192.168.0.1',5001);
INSERT INTO "iperf_connection" VALUES(6,2,1,2.71957329998258501291e+01,26.781987,-4638133553200985154,-5067046478646040380,'192.168.0.2',33018,'192.168.0.1',5001);
CREATE TABLE "iperf_transfer" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "connection_id" UNSIGNED BIGINT, "begin_interval" REAL, "end_interval" REAL, "size" UNSIGNED BIGINT);
INSERT INTO "iperf_transfer" VALUES(1,1,1,2.77147699892520904541e+01,27.642629,833850270123997830,5407760560782721986,0.0,1.0,130320);
INSERT INTO "iperf_transfer" VALUES(2,1,1,2.80369869768619537362e+01,27.737423,6316594332143149512,-3379649244129461518,0.0,1.0,173760);
INSERT INTO "iperf_transfer" VALUES(3,1,2,2.87143209874629974365e+01,28.64217,833850270123997830,5407760560782721986,1.0,2.0,304080);
INSERT INTO "iperf_transfer" VALUES(4,1,2,2.90520899891853332528e+01,28.752541,6316594332143149512,-3379649244129461518,1.0,2.0,272224);
INSERT INTO "iperf_transfer" VALUES(5,1,3,2.97136329710483551016e+01,29.641412,833850270123997830,5407760560782721986,2.0,3.0,309872);
INSERT INTO "iperf_transfer" VALUES(6,1,3,3.00345329940319061279e+01,29.734962,6316594332143149512,-3379649244129461518,2.0,3.0,291048);
INSERT INTO "iperf_transfer" VALUES(7,1,4,3.07127509713172912601e+01,30.640503,833850270123997830,5407760560782721986,3.0,4.0,314216);
INSERT INTO "iperf_transfer" VALUES(8,1,4,3.10349929928779602042e+01,30.735403,6316594332143149512,-3379649244129461518,3.0,4.0,321456);
INSERT INTO "iperf_transfer" VALUES(9,1,5,3.17155589759349822989e+01,31.64329,833850270123997830,5407760560782721986,4.0,5.0,299736);
INSERT INTO "iperf_transfer" VALUES(10,1,5,3.203489595651626587e+01,31.735246,6316594332143149512,-3379649244129461518,4.0,5.0,306976);
INSERT INTO "iperf_transfer" VALUES(11,2,1,3.22397039979696273812e+01,31.995167,-3544341636566083228,-6410456378195227249,0.0,5.0,1441792);
INSERT INTO "iperf_transfer" VALUES(12,2,1,3.25710929930210113525e+01,32.149049,-4638133553200985154,-5067046478646040380,0.0,5.0,1441792);
INSERT INTO "iperf_transfer" VALUES(13,1,6,3.27131999731063842777e+01,32.640889,833850270123997830,5407760560782721986,5.0,6.0,304080);
INSERT INTO "iperf_transfer" VALUES(14,1,6,3.30381989479064941406e+01,32.738539,6316594332143149512,-3379649244129461518,5.0,6.0,308424);
INSERT INTO "iperf_transfer" VALUES(15,1,7,3.37150639891624450674e+01,33.642728,833850270123997830,5407760560782721986,6.0,7.0,315664);
INSERT INTO "iperf_transfer" VALUES(16,1,7,34.0368549823761,33.737175,6316594332143149512,-3379649244129461518,6.0,7.0,291048);
INSERT INTO "iperf_transfer" VALUES(17,1,8,3.47192999720573425292e+01,34.646964,833850270123997830,5407760560782721986,7.0,8.0,278016);
INSERT INTO "iperf_transfer" VALUES(18,1,8,3.50351879596710205069e+01,34.73547,6316594332143149512,-3379649244129461518,7.0,8.0,306976);
INSERT INTO "iperf_transfer" VALUES(19,1,9,3.57166519761085510253e+01,35.64431,833850270123997830,5407760560782721986,8.0,9.0,305528);
INSERT INTO "iperf_transfer" VALUES(20,1,9,3.60375219583511352539e+01,35.737809,6316594332143149512,-3379649244129461518,8.0,9.0,327248);
INSERT INTO "iperf_transfer" VALUES(21,1,10,3.67127069830894470214e+01,36.640308,833850270123997830,5407760560782721986,9.0,10.0,317112);
INSERT INTO "iperf_transfer" VALUES(22,1,10,3.70350579619407653812e+01,36.735354,6316594332143149512,-3379649244129461518,9.0,10.0,304080);
INSERT INTO "iperf_transfer" VALUES(23,2,2,3.70716509968042373657e+01,36.826996,-3544341636566083228,-6410456378195227249,5.0,10.0,1572864);
INSERT INTO "iperf_transfer" VALUES(24,2,2,3.73297989964485168448e+01,36.860246,-4638133553200985154,-5067046478646040380,5.0,10.0,1441792);
INSERT INTO "iperf_transfer" VALUES(25,1,11,3.77142209410667419424e+01,37.641748,833850270123997830,5407760560782721986,10.0,11.0,305528);
INSERT INTO "iperf_transfer" VALUES(26,1,11,3.80390549898147583007e+01,37.739297,6316594332143149512,-3379649244129461518,10.0,11.0,288152);
INSERT INTO "iperf_transfer" VALUES(27,1,12,3.87128459811210632332e+01,38.640341,833850270123997830,5407760560782721986,11.0,12.0,308424);
INSERT INTO "iperf_transfer" VALUES(28,1,12,3.90341869592666625967e+01,38.73444,6316594332143149512,-3379649244129461518,11.0,12.0,327248);
INSERT INTO "iperf_transfer" VALUES(29,1,13,39.7122939825058,39.639783,833850270123997830,5407760560782721986,12.0,13.0,317112);
INSERT INTO "iperf_transfer" VALUES(30,1,13,4.00510689616203308105e+01,39.751305,6316594332143149512,-3379649244129461518,12.0,13.0,283808);
INSERT INTO "iperf_transfer" VALUES(31,1,14,4.07144529819488525373e+01,40.641924,833850270123997830,5407760560782721986,13.0,14.0,327248);
INSERT INTO "iperf_transfer" VALUES(32,1,14,4.10453369617462158211e+01,40.745506,6316594332143149512,-3379649244129461518,13.0,14.0,320008);
INSERT INTO "iperf_transfer" VALUES(33,1,15,4.1715602993965148924e+01,41.643009,833850270123997830,5407760560782721986,14.0,15.0,278016);
INSERT INTO "iperf_transfer" VALUES(34,1,15,4.20377579927444457999e+01,41.737904,6316594332143149512,-3379649244129461518,14.0,15.0,305528);
INSERT INTO "iperf_transfer" VALUES(35,2,3,4.20899839997291564958e+01,41.845146,-3544341636566083228,-6410456378195227249,10.0,15.0,1572864);
INSERT INTO "iperf_transfer" VALUES(36,2,3,4.2394909992814064025e+01,41.925208,-4638133553200985154,-5067046478646040380,10.0,15.0,1703936);
INSERT INTO "iperf_transfer" VALUES(37,1,16,4.2717866957187652587e+01,42.64525,833850270123997830,5407760560782721986,15.0,16.0,293944);
INSERT INTO "iperf_transfer" VALUES(38,1,16,4.30392599701881408682e+01,42.739399,6316594332143149512,-3379649244129461518,15.0,16.0,328696);
INSERT INTO "iperf_transfer" VALUES(39,1,17,4.37219039797782897931e+01,43.649286,833850270123997830,5407760560782721986,16.0,17.0,304080);
INSERT INTO "iperf_transfer" VALUES(40,1,17,4.40416289567947387677e+01,43.741738,6316594332143149512,-3379649244129461518,16.0,17.0,311320);
INSERT INTO "iperf_transfer" VALUES(41,1,18,4.47119509577751159676e+01,44.639294,833850270123997830,5407760560782721986,17.0,18.0,302632);
INSERT INTO "iperf_transfer" VALUES(42,1,18,4.50348509550094604474e+01,44.73494,6316594332143149512,-3379649244129461518,17.0,18.0,292496);
INSERT INTO "iperf_transfer" VALUES(43,1,19,4.57163599729537963858e+01,45.64363,833850270123997830,5407760560782721986,18.0,19.0,308424);
INSERT INTO "iperf_transfer" VALUES(44,1,19,46.0443149805069,45.744415,6316594332143149512,-3379649244129461518,18.0,19.0,280912);
INSERT INTO "iperf_transfer" VALUES(45,1,20,46.7140149474144,46.641274,833850270123997830,5407760560782721986,19.0,20.0,320008);
INSERT INTO "iperf_transfer" VALUES(46,2,4,4.69332739710807800292e+01,46.688349,-3544341636566083228,-6410456378195227249,15.0,20.0,1441792);
INSERT INTO "iperf_transfer" VALUES(47,1,20,4.70358919501304626473e+01,46.735966,6316594332143149512,-3379649244129461518,19.0,20.0,305528);
INSERT INTO "iperf_transfer" VALUES(48,2,4,4.77811639904975891121e+01,47.311348,-4638133553200985154,-5067046478646040380,15.0,20.0,1572864);
CREATE TABLE "iperf_losses" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "connection_id" UNSIGNED BIGINT, "begin_interval" REAL, "end_interval" REAL, "total_datagrams" INTEGER, "lost_datagrams" INTEGER);
CREATE TABLE "iperf_jitter" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "connection_id" UNSIGNED BIGINT, "begin_interval" REAL, "end_interval" REAL, "jitter" REAL);
CREATE TABLE "iperf_packets" (oml_tuple_id INTEGER PRIMARY KEY, oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, "pid" UNSIGNED BIGINT, "connection_id" UNSIGNED BIGINT, "packet_id" INTEGER, "packet_size" INTEGER, "packet_time_s" INTEGER, "packet_time_us" INTEGER, "packet_sent_time_s" INTEGER, "packet_sent_time_us" INTEGER);
INSERT INTO "iperf_packets" VALUES(1,1,1,2.70599989891052246089e+01,26.781331,6316594332143149512,-3379649244129461518,0,1448,1465563717,59998,0,0);
INSERT INTO "iperf_packets" VALUES(2,1,1,2.67179559767246246329e+01,26.781413,833850270123997830,5407760560782721986,0,1448,1465563716,717955,0,0);
INSERT INTO "iperf_packets" VALUES(3,1,2,2.67260909974575042733e+01,26.781421,833850270123997830,5407760560782721986,0,1448,1465563716,726090,0,0);
INSERT INTO "iperf_packets" VALUES(4,1,3,2.67341959774494171138e+01,26.781428,833850270123997830,5407760560782721986,0,1448,1465563716,734195,0,0);
INSERT INTO "iperf_packets" VALUES(5,1,4,2.67425009906291961665e+01,26.781435,833850270123997830,5407760560782721986,0,1448,1465563716,742500,0,0);
INSERT INTO "iperf_packets" VALUES(6,1,2,2.70808679759502410897e+01,26.781689,6316594332143149512,-3379649244129461518,0,1448,1465563717,80868,0,0);
INSERT INTO "iperf_packets" VALUES(7,1,5,2.67666969895362854008e+01,2.67817009999999982032e+01,833850270123997830,5407760560782721986,0,1448,1465563716,766697,0,0);
INSERT INTO "iperf_packets" VALUES(8,1,6,2.67901219725608825679e+01,26.781709,833850270123997830,5407760560782721986,0,1448,1465563716,790122,0,0);
INSERT INTO "iperf_packets" VALUES(9,1,7,2.67969239950180053715e+01,26.781715,833850270123997830,5407760560782721986,0,1448,1465563716,796923,0,0);
INSERT INTO "iperf_packets" VALUES(10,1,8,2.68049979805946350088e+01,26.781722,833850270123997830,5407760560782721986,0,1448,1465563716,804997,0,0);
INSERT INTO "iperf_packets" VALUES(11,1,9,2.68131279945373535156e+01,26.781728,833850270123997830,5407760560782721986,0,1448,1465563716,813128,0,0);
INSERT INTO "iperf_packets" VALUES(12,1,10,2.68194109797477722159e+01,26.781734,833850270123997830,5407760560782721986,0,1448,1465563716,819410,0,0);
INSERT INTO "iperf_packets" VALUES(13,1,11,2.68406479954719543465e+01,26.781741,833850270123997830,5407760560782721986,0,1448,1465563716,840647,0,0);
INSERT INTO "iperf_packets" VALUES(14,1,12,2.68872009813785552969e+01,26.815101,833850270123997830,5407760560782721986,0,1448,1465563716,887200,0,0);
INSERT INTO "iperf_packets" VALUES(15,1,3,2.71287169754505157475e+01,26.82918,6316594332143149512,-3379649244129461518,0,1448,1465563717,128716,0,0);
INSERT INTO "iperf_packets" VALUES(16,1,4,2.71411459743976593008e+01,26.841607,6316594332143149512,-3379649244129461518,0,1448,1465563717,141145,0,0);
INSERT INTO "iperf_packets" VALUES(17,1,13,2.69231809973716735835e+01,26.851093,833850270123997830,5407760560782721986,0,1448,1465563716,923180,0,0);
INSERT INTO "iperf_packets" VALUES(18,1,5,2.71647219955921173087e+01,26.865168,6316594332143149512,-3379649244129461518,0,1448,1465563717,164722,0,0);
INSERT INTO "iperf_packets" VALUES(19,1,6,2.71776079833507537846e+01,26.878046,6316594332143149512,-3379649244129461518,0,1448,1465563717,177608,0,0);
INSERT INTO "iperf_packets" VALUES(20,1,14,2.69582189917564392085e+01,26.886084,833850270123997830,5407760560782721986,0,1448,1465563716,958218,0,0);
INSERT INTO "iperf_packets" VALUES(21,1,15,2.69674469828605651851e+01,26.895319,833850270123997830,5407760560782721986,0,1448,1465563716,967447,0,0);
INSERT INTO "iperf_packets" VALUES(22,1,7,2.72081859707832336421e+01,26.908648,6316594332143149512,-3379649244129461518,0,1448,1465563717,208186,0,0);
INSERT INTO "iperf_packets" VALUES(23,1,16,2.69884559810161590571e+01,26.91637,833850270123997830,5407760560782721986,0,1448,1465563716,988455,0,0);
INSERT INTO "iperf_packets" VALUES(24,1,8,2.72201529741287231436e+01,26.920652,6316594332143149512,-3379649244129461518,0,1448,1465563717,220153,0,0);
INSERT INTO "iperf_packets" VALUES(25,1,9,2.72329019904136657723e+01,26.933361,6316594332143149512,-3379649244129461518,0,1448,1465563717,232902,0,0);
INSERT INTO "iperf_packets" VALUES(26,1,17,2.70129089951515197762e+01,26.940797,833850270123997830,5407760560782721986,0,1448,1465563717,12908,0,0);
INSERT INTO "iperf_packets" VALUES(27,1,10,2.72531469762325286856e+01,26.953647,6316594332143149512,-3379649244129461518,0,1448,1465563717,253147,0,0);
INSERT INTO "iperf_packets" VALUES(28,1,11,2.72800649702548980712e+01,26.980573,6316594332143149512,-3379649244129461518,0,1448,1465563717,280064,0,0);
INSERT INTO "iperf_packets" VALUES(29,1,18,2.70593959987163543709e+01,26.987276,833850270123997830,5407760560782721986,0,1448,1465563717,59396,0,0);
INSERT INTO "iperf_packets" VALUES(30,1,12,2.73009749948978424076e+01,27.00145,6316594332143149512,-3379649244129461518,0,1448,1465563717,300975,0,0);
INSERT INTO "iperf_packets" VALUES(31,1,13,2.73249119818210601802e+01,27.149188,6316594332143149512,-3379649244129461518,0,1448,1465563717,324912,0,0);
INSERT INTO "iperf_packets" VALUES(32,1,14,2.73377969861030578613e+01,27.149199,6316594332143149512,-3379649244129461518,0,1448,1465563717,337797,0,0);
INSERT INTO "iperf_packets" VALUES(33,1,15,2.73506819903850555424e+01,27.149206,6316594332143149512,-3379649244129461518,0,1448,1465563717,350682,0,0);
INSERT INTO "iperf_packets" VALUES(34,1,16,2.73635269999504089351e+01,27.149236,6316594332143149512,-3379649244129461518,0,1448,1465563717,363527,0,0);
INSERT INTO "iperf_packets" VALUES(35,1,17,2.73840119838714599618e+01,27.149244,6316594332143149512,-3379649244129461518,0,1448,1465563717,384011,0,0);
INSERT INTO "iperf_packets" VALUES(36,1,18,2.74058919847011566166e+01,27.14925,6316594332143149512,-3379649244129461518,0,1448,1465563717,405891,0,0);
INSERT INTO "iperf_packets" VALUES(37,1,19,2.74308009743690490718e+01,27.149257,6316594332143149512,-3379649244129461518,0,1448,1465563717,430800,0,0);
INSERT INTO "iperf_packets" VALUES(38,1,19,2.70779859721660614018e+01,27.149272,833850270123997830,5407760560782721986,0,1448,1465563717,77985,0,0);
INSERT INTO "iperf_packets" VALUES(39,1,20,27.0845929980278,27.149281,833850270123997830,5407760560782721986,0,1448,1465563717,84593,0,0);
INSERT INTO "iperf_packets" VALUES(40,1,21,2.71428399980068206791e+01,27.149296,833850270123997830,5407760560782721986,0,1448,1465563717,142839,0,0);
INSERT INTO "iperf_packets" VALUES(41,1,22,2.7167058974504470826e+01,27.149304,833850270123997830,5407760560782721986,0,1448,1465563717,167058,0,0);
INSERT INTO "iperf_packets" VALUES(42,1,23,2.71811539828777313241e+01,27.149311,833850270123997830,5407760560782721986,0,1448,1465563717,181153,0,0);
INSERT INTO "iperf_packets" VALUES(43,1,24,2.71891619861125946036e+01,27.149318,833850270123997830,5407760560782721986,0,1448,1465563717,189161,0,0);
INSERT INTO "iperf_packets" VALUES(44,1,25,2.72107269763946533211e+01,27.149325,833850270123997830,5407760560782721986,0,1448,1465563717,210725,0,0);
INSERT INTO "iperf_packets" VALUES(45,1,20,2.7450983971357345581e+01,27.151459,6316594332143149512,-3379649244129461518,0,1448,1465563717,450984,0,0);
INSERT INTO "iperf_packets" VALUES(46,1,21,2.74765609800815582266e+01,27.177018,6316594332143149512,-3379649244129461518,0,1448,1465563717,476560,0,0);
INSERT INTO "iperf_packets" VALUES(47,1,22,2.74933359920978546151e+01,27.19379,6316594332143149512,-3379649244129461518,0,1448,1465563717,493336,0,0);
INSERT INTO "iperf_packets" VALUES(48,1,23,2.74986129999160766601e+01,27.199081,6316594332143149512,-3379649244129461518,0,1448,1465563717,498613,0,0);
INSERT INTO "iperf_packets" VALUES(49,1,26,2.72761509716510772713e+01,27.204024,833850270123997830,5407760560782721986,0,1448,1465563717,276150,0,0);
INSERT INTO "iperf_packets" VALUES(50,1,24,2.75062769949436187739e+01,27.206719,6316594332143149512,-3379649244129461518,0,1448,1465563717,506277,0,0);
INSERT INTO "iperf_packets" VALUES(51,1,27,2.72854759991168975834e+01,27.213358,833850270123997830,5407760560782721986,0,1448,1465563717,285475,0,0);
INSERT INTO "iperf_packets" VALUES(52,1,28,2.72898949980735778804e+01,27.217751,833850270123997830,5407760560782721986,0,1448,1465563717,289894,0,0);
INSERT INTO "iperf_packets" VALUES(53,1,25,2.75200339853763580326e+01,27.220495,6316594332143149512,-3379649244129461518,0,1448,1465563717,520031,0,0);
INSERT INTO "iperf_packets" VALUES(54,1,29,2.72992919981479644766e+01,27.227186,833850270123997830,5407760560782721986,0,1448,1465563717,299291,0,0);
INSERT INTO "iperf_packets" VALUES(55,1,30,2.73066699802875518794e+01,27.234524,833850270123997830,5407760560782721986,0,1448,1465563717,306669,0,0);
INSERT INTO "iperf_packets" VALUES(56,1,26,2.75368559956550598135e+01,27.237318,6316594332143149512,-3379649244129461518,0,1448,1465563717,536855,0,0);
INSERT INTO "iperf_packets" VALUES(57,1,31,2.73191619813442230233e+01,27.247053,833850270123997830,5407760560782721986,0,1448,1465563717,319162,0,0);
INSERT INTO "iperf_packets" VALUES(58,1,27,2.75493479967117309574e+01,27.249799,6316594332143149512,-3379649244129461518,0,1448,1465563717,549348,0,0);
INSERT INTO "iperf_packets" VALUES(59,1,28,2.75526609718799591068e+01,27.253092,6316594332143149512,-3379649244129461518,0,1448,1465563717,552661,0,0);
INSERT INTO "iperf_packets" VALUES(60,1,32,2.7332742989063262939e+01,27.260631,833850270123997830,5407760560782721986,0,1448,1465563717,332742,0,0);
INSERT INTO "iperf_packets" VALUES(61,1,33,2.73364749848842620845e+01,27.264325,833850270123997830,5407760560782721986,0,1448,1465563717,336474,0,0);
INSERT INTO "iperf_packets" VALUES(62,1,29,2.75664999783039093021e+01,27.266971,6316594332143149512,-3379649244129461518,0,1448,1465563717,566500,0,0);
INSERT INTO "iperf_packets" VALUES(63,1,34,2.73424349725246429443e+01,27.270316,833850270123997830,5407760560782721986,0,1448,1465563717,342434,0,0);
INSERT INTO "iperf_packets" VALUES(64,1,30,2.75714859962463378897e+01,27.271912,6316594332143149512,-3379649244129461518,0,1448,1465563717,571486,0,0);
INSERT INTO "iperf_packets" VALUES(65,1,35,2.73485169708728790291e+01,27.276406,833850270123997830,5407760560782721986,0,1448,1465563717,348516,0,0);
INSERT INTO "iperf_packets" VALUES(66,1,36,2.73557319939136505131e+01,27.283595,833850270123997830,5407760560782721986,0,1448,1465563717,355732,0,0);
INSERT INTO "iperf_packets" VALUES(67,1,37,2.7359732985496520996e+01,27.287588,833850270123997830,5407760560782721986,0,1448,1465563717,359732,0,0);
INSERT INTO "iperf_packets" VALUES(68,1,38,2.7362471997737884521e+01,27.290334,833850270123997830,5407760560782721986,0,1448,1465563717,362472,0,0);
INSERT INTO "iperf_packets" VALUES(69,1,39,2.73658059835433959956e+01,27.293678,833850270123997830,5407760560782721986,0,1448,1465563717,365806,0,0);
INSERT INTO "iperf_packets" VALUES(70,1,40,2.73685259819030761723e+01,27.296373,833850270123997830,5407760560782721986,0,1448,1465563717,368526,0,0);
INSERT INTO "iperf_packets" VALUES(71,1,31,2.75975969731807708735e+01,27.298071,6316594332143149512,-3379649244129461518,0,1448,1465563717,597596,0,0);
INSERT INTO "iperf_packets" VALUES(72,1,41,2.73728769719600677494e+01,27.300766,833850270123997830,5407760560782721986,0,1448,1465563717,372877,0,0);
INSERT INTO "iperf_packets" VALUES(73,1,42,2.73773959875106811514e+01,27.30526,833850270123997830,5407760560782721986,0,1448,1465563717,377396,0,0);
INSERT INTO "iperf_packets" VALUES(74,1,32,2.76064039766788482666e+01,27.306857,6316594332143149512,-3379649244129461518,0,1448,1465563717,606404,0,0);
INSERT INTO "iperf_packets" VALUES(75,1,33,2.76088189780712127689e+01,27.309252,6316594332143149512,-3379649244129461518,0,1448,1465563717,608819,0,0);
INSERT INTO "iperf_packets" VALUES(76,1,43,2.73841219842433929447e+01,27.311999,833850270123997830,5407760560782721986,0,1448,1465563717,384121,0,0);
INSERT INTO "iperf_packets" VALUES(77,1,44,2.73980759978294372567e+01,27.325927,833850270123997830,5407760560782721986,0,1448,1465563717,398075,0,0);
INSERT INTO "iperf_packets" VALUES(78,1,34,2.76283019781112670898e+01,27.328771,6316594332143149512,-3379649244129461518,0,1448,1465563717,628301,0,0);
INSERT INTO "iperf_packets" VALUES(79,1,35,2.76343299746513366694e+01,27.334762,6316594332143149512,-3379649244129461518,0,1448,1465563717,634329,0,0);
INSERT INTO "iperf_packets" VALUES(80,1,45,2.74092519879341125479e+01,27.337108,833850270123997830,5407760560782721986,0,1448,1465563717,409252,0,0);
INSERT INTO "iperf_packets" VALUES(81,1,46,2.74122899770736694335e+01,27.340154,833850270123997830,5407760560782721986,0,1448,1465563717,412289,0,0);
INSERT INTO "iperf_packets" VALUES(82,1,47,2.74163129925727844238e+01,27.344198,833850270123997830,5407760560782721986,0,1448,1465563717,416313,0,0);
INSERT INTO "iperf_packets" VALUES(83,1,36,2.76459549963474273672e+01,27.346393,6316594332143149512,-3379649244129461518,0,1448,1465563717,645954,0,0);
INSERT INTO "iperf_packets" VALUES(84,1,37,2.76492909789085388187e+01,27.349738,6316594332143149512,-3379649244129461518,0,1448,1465563717,649291,0,0);
INSERT INTO "iperf_packets" VALUES(85,1,38,2.76508679986000061035e+01,27.351334,6316594332143149512,-3379649244129461518,0,1448,1465563717,650867,0,0);
INSERT INTO "iperf_packets" VALUES(86,1,48,2.74262009859085083003e+01,27.354081,833850270123997830,5407760560782721986,0,1448,1465563717,426200,0,0);
INSERT INTO "iperf_packets" VALUES(87,1,39,2.76552699804306030269e+01,27.355728,6316594332143149512,-3379649244129461518,0,1448,1465563717,655270,0,0);
INSERT INTO "iperf_packets" VALUES(88,1,49,2.74305329918861389164e+01,27.358375,833850270123997830,5407760560782721986,0,1448,1465563717,430532,0,0);
INSERT INTO "iperf_packets" VALUES(89,1,50,2.74327899813652038569e+01,27.360669,833850270123997830,5407760560782721986,0,1448,1465563717,432789,0,0);
INSERT INTO "iperf_packets" VALUES(90,1,51,2.74354999959468841557e+01,27.363366,833850270123997830,5407760560782721986,0,1448,1465563717,435499,0,0);
INSERT INTO "iperf_packets" VALUES(91,1,40,2.76658499836921691885e+01,27.366311,6316594332143149512,-3379649244129461518,0,1448,1465563717,665850,0,0);
INSERT INTO "iperf_packets" VALUES(92,1,52,2.74399949908256530757e+01,27.367858,833850270123997830,5407760560782721986,0,1448,1465563717,439995,0,0);
INSERT INTO "iperf_packets" VALUES(93,1,53,2.74415679872035980215e+01,27.369455,833850270123997830,5407760560782721986,0,1448,1465563717,441567,0,0);
INSERT INTO "iperf_packets" VALUES(94,1,41,2.76707469820976257332e+01,27.371205,6316594332143149512,-3379649244129461518,0,1448,1465563717,670747,0,0);
INSERT INTO "iperf_packets" VALUES(95,1,54,2.7444892972707748413e+01,27.37275,833850270123997830,5407760560782721986,0,1448,1465563717,444892,0,0);
INSERT INTO "iperf_packets" VALUES(96,1,42,2.76744509935379028324e+01,27.374897,6316594332143149512,-3379649244129461518,0,1448,1465563717,674451,0,0);
INSERT INTO "iperf_packets" VALUES(97,1,43,2.76842949986457824711e+01,27.384732,6316594332143149512,-3379649244129461518,0,1448,1465563717,684294,0,0);
INSERT INTO "iperf_packets" VALUES(98,1,55,2.7458460986614227294e+01,27.38633,833850270123997830,5407760560782721986,0,1448,1465563717,458460,0,0);
INSERT INTO "iperf_packets" VALUES(99,1,56,2.74606869816780090336e+01,27.388574,833850270123997830,5407760560782721986,0,1448,1465563717,460687,0,0);
INSERT INTO "iperf_packets" VALUES(100,1,57,2.74623179733753204341e+01,27.390173,833850270123997830,5407760560782721986,0,1448,1465563717,462318,0,0);
INSERT INTO "iperf_packets" VALUES(101,1,44,2.76913589835166931143e+01,27.39182,6316594332143149512,-3379649244129461518,0,1448,1465563717,691358,0,0);
INSERT INTO "iperf_packets" VALUES(102,1,45,2.76991709768772125248e+01,27.399608,6316594332143149512,-3379649244129461518,0,1448,1465563717,699170,0,0);
INSERT INTO "iperf_packets" VALUES(103,1,58,2.74762489795684814461e+01,27.404101,833850270123997830,5407760560782721986,0,1448,1465563717,476248,0,0);
INSERT INTO "iperf_packets" VALUES(104,1,59,2.74778169989585876456e+01,27.405698,833850270123997830,5407760560782721986,0,1448,1465563717,477817,0,0);
INSERT INTO "iperf_packets" VALUES(105,1,46,2.77068369984626770028e+01,27.407295,6316594332143149512,-3379649244129461518,0,1448,1465563717,706837,0,0);
INSERT INTO "iperf_packets" VALUES(106,1,47,2.7708469986915588378e+01,27.408892,6316594332143149512,-3379649244129461518,0,1448,1465563717,708470,0,0);
INSERT INTO "iperf_packets" VALUES(107,1,48,2.7711692988872528077e+01,27.412138,6316594332143149512,-3379649244129461518,0,1448,1465563717,711693,0,0);
INSERT INTO "iperf_packets" VALUES(108,1,49,2.77151619791984558114e+01,27.415632,6316594332143149512,-3379649244129461518,0,1448,1465563717,715161,0,0);
INSERT INTO "iperf_packets" VALUES(109,1,50,2.77192729711532592773e+01,27.419725,6316594332143149512,-3379649244129461518,0,1448,1465563717,719273,0,0);
INSERT INTO "iperf_packets" VALUES(110,1,60,2.74941549897193908695e+01,27.422021,833850270123997830,5407760560782721986,0,1448,1465563717,494154,0,0);
INSERT INTO "iperf_packets" VALUES(111,1,51,2.77231529951095581046e+01,27.423618,6316594332143149512,-3379649244129461518,0,1448,1465563717,723152,0,0);
INSERT INTO "iperf_packets" VALUES(112,1,52,2.77262769937515258784e+01,27.426714,6316594332143149512,-3379649244129461518,0,1448,1465563717,726277,0,0);
INSERT INTO "iperf_packets" VALUES(113,1,61,2.75004429817199707035e+01,27.428311,833850270123997830,5407760560782721986,0,1448,1465563717,500443,0,0);
INSERT INTO "iperf_packets" VALUES(114,1,62,2.75071209967136383052e+01,27.435002,833850270123997830,5407760560782721986,0,1448,1465563717,507121,0,0);
INSERT INTO "iperf_packets" VALUES(115,1,63,2.75126679837703704825e+01,27.440542,833850270123997830,5407760560782721986,0,1448,1465563717,512667,0,0);
INSERT INTO "iperf_packets" VALUES(116,1,64,2.75153489708900451655e+01,27.443238,833850270123997830,5407760560782721986,0,1448,1465563717,515348,0,0);
INSERT INTO "iperf_packets" VALUES(117,1,53,2.77448879778385162344e+01,27.445334,6316594332143149512,-3379649244129461518,0,1448,1465563717,744888,0,0);
INSERT INTO "iperf_packets" VALUES(118,1,54,2.77464599907398223876e+01,27.446882,6316594332143149512,-3379649244129461518,0,1448,1465563717,746460,0,0);
INSERT INTO "iperf_packets" VALUES(119,1,55,2.77491109967231750496e+01,27.449577,6316594332143149512,-3379649244129461518,0,1448,1465563717,749111,0,0);
INSERT INTO "iperf_packets" VALUES(120,1,56,2.77506829798221588134e+01,27.451124,6316594332143149512,-3379649244129461518,0,1448,1465563717,750683,0,0);
INSERT INTO "iperf_packets" VALUES(121,1,65,2.75248299837112426753e+01,27.452672,833850270123997830,5407760560782721986,0,1448,1465563717,524829,0,0);
INSERT INTO "iperf_packets" VALUES(122,1,66,2.75265199840068817147e+01,27.45437,833850270123997830,5407760560782721986,0,1448,1465563717,526520,0,0);
INSERT INTO "iperf_packets" VALUES(123,1,67,2.75280939936637878426e+01,27.455966,833850270123997830,5407760560782721986,0,1448,1465563717,528094,0,0);
INSERT INTO "iperf_packets" VALUES(124,1,68,2.75297059714794158926e+01,27.457564,833850270123997830,5407760560782721986,0,1448,1465563717,529706,0,0);
INSERT INTO "iperf_packets" VALUES(125,1,57,2.77585989832878112784e+01,27.459061,6316594332143149512,-3379649244129461518,0,1448,1465563717,758598,0,0);
INSERT INTO "iperf_packets" VALUES(126,1,58,2.77620269954204559317e+01,27.462457,6316594332143149512,-3379649244129461518,0,1448,1465563717,762027,0,0);
INSERT INTO "iperf_packets" VALUES(127,2,1,2.79324299991130828866e+01,27.463056,-4638133553200985154,-5067046478646040380,0,131072,1465563717,932425,0,2080508432);
INSERT INTO "iperf_packets" VALUES(128,1,69,2.75409869849681854248e+01,27.468846,833850270123997830,5407760560782721986,0,1448,1465563717,540987,0,0);
INSERT INTO "iperf_packets" VALUES(129,1,59,2.7770003974437713623e+01,27.470444,6316594332143149512,-3379649244129461518,0,1448,1465563717,770004,0,0);
INSERT INTO "iperf_packets" VALUES(130,1,70,2.75465309917926788325e+01,27.474388,833850270123997830,5407760560782721986,0,1448,1465563717,546530,0,0);
INSERT INTO "iperf_packets" VALUES(131,1,71,2.75481229722499847416e+01,27.475984,833850270123997830,5407760560782721986,0,1448,1465563717,548122,0,0);
INSERT INTO "iperf_packets" VALUES(132,1,60,2.7777680993080139161e+01,27.478132,6316594332143149512,-3379649244129461518,0,1448,1465563717,777680,0,0);
INSERT INTO "iperf_packets" VALUES(133,1,72,2.75548079907894134517e+01,27.482675,833850270123997830,5407760560782721986,0,1448,1465563717,554808,0,0);
INSERT INTO "iperf_packets" VALUES(134,1,61,27.78603297472,27.486468,6316594332143149512,-3379649244129461518,0,1448,1465563717,786033,0,0);
INSERT INTO "iperf_packets" VALUES(135,1,62,2.77882039844989776606e+01,27.488663,6316594332143149512,-3379649244129461518,0,1448,1465563717,788204,0,0);
INSERT INTO "iperf_packets" VALUES(136,1,63,2.77905159890651702885e+01,27.490961,6316594332143149512,-3379649244129461518,0,1448,1465563717,790516,0,0);
INSERT INTO "iperf_packets" VALUES(137,1,64,2.77954309880733489994e+01,27.495853,6316594332143149512,-3379649244129461518,0,1448,1465563717,795431,0,0);
Last modified 8 years ago Last modified on Aug 10, 2016, 3:20:44 PM

Attachments (1)

  • wishful_edca.rb​ (2.7 KB ) - added by seskar 8 years ago. WiSHFUL EDCA Management Tutorial Script

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.