Changes between Version 2 and Version 3 of Tutorials/c0WiFi/Tutorial5


Ignore:
Timestamp:
Jun 10, 2016, 1:15:53 PM (8 years ago)
Author:
seskar
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • Tutorials/c0WiFi/Tutorial5

    v2 v3  
    66
    77=== About This Experiment ===
     8
     9In this tutorial, [http://www.wishful-project.eu/ 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 [wiki:Documentation/cImages/wishful WiSHFUL image ('''wishful.ndz''')] and is explicitly designed for use in [wiki:Hardware/bDomains/cSandboxes/dSB4 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).
     10
     11=== Experiment Script ===
     12
     13The OMF experiment script [attachment:wishful_edca.rb wishful_edca.rb] is used to execute WiSHFUL control programs.
     14
     15
     16=== Experiment Execution ===
     17
     18Image the nodes:
     19{{{
     20omf load -t node1-3,node1-4,node1-5,node1-6,node2-1 -i wishful.ndz
     21}}}
     22and turn them on:
     23{{{
     24omf tell -a on -t system:topo:imaged
     25}}}
     26{{{
     27wget
     28}}}
     29and, after an optional minute wait, execute the script
     30{{{
     31omf exec wishful_edca.rb
     32}}}
     33
     34
     35The output should look similar to:
     36{{{
     37user@console.sb4:~# omf exec wishful_edca.rb
     38
     39 INFO NodeHandler: OMF Experiment Controller 5.4 (git 861d645)
     40 INFO NodeHandler: Reading configuration file /etc/omf-expctl-5.4/services.yaml
     41 INFO NodeHandler: Add domain http - http://internal1.orbit-lab.org:5054/
     42 INFO NodeHandler: Add domain http - http://repository1.orbit-lab.org:5054/
     43 INFO NodeHandler: Add domain http - http://internal2dmz.orbit-lab.org:5054/
     44 INFO NodeHandler: Add domain http - http://external1.orbit-lab.org:5054/
     45 INFO NodeHandler: Slice ID: default_slice (default)
     46 INFO NodeHandler: Experiment ID: default_slice-2016-06-10t09.01.04.779-04.00
     47 INFO NodeHandler: Message authentication is disabled
     48 INFO Experiment: load system:exp:stdlib
     49 INFO property.resetDelay: resetDelay = 230 (Fixnum)
     50 INFO property.resetTries: resetTries = 1 (Fixnum)
     51 INFO Experiment: load system:exp:eventlib
     52 INFO Experiment: load system:exp:winlib
     53 INFO Experiment: load wishful_edca.rb
     54 INFO property.contr: contr = "node2-1" (String)
     55 INFO property.path: path = "/root/wishful/examples/edca/" (String)
     56 INFO property.accesspoints: accesspoints = "node1-3,node1-5" (String)
     57 INFO property.clients: clients = "node1-4,node1-6" (String)
     58 INFO property.channel: channel = 11 (Fixnum)
     59 INFO property.duration: duration = 60 (Fixnum)
     60 INFO ALL_UP_AND_INSTALLED: Event triggered. Starting the associated tasks.
     61 INFO exp: Wait for all nodes to come up
     62 INFO exp: Request from Experiment Script: Wait for 20s....
     63 INFO BRING_UP: Event triggered. Starting the associated tasks.
     64 INFO Experiment: Bringing up resources
     65 INFO exp: Both controller and agent are started; running for 60
     66 INFO exp: Request from Experiment Script: Wait for 60s....
     67 INFO exp: Both controller and agent are stopped...
     68 INFO EXPERIMENT_DONE: Event triggered. Starting the associated tasks.
     69 INFO NodeHandler:
     70 INFO NodeHandler: Shutting down experiment, please wait...
     71 INFO NodeHandler:
     72 INFO run: Experiment default_slice-2016-06-10t09.01.04.779-04.00 finished after 1:30
     73}}}
     74
     75To recover experiment data to the local machine, and using the experiment ID:
     76
     77{{{
     78wget "http://oml:5054/result/dumpDatabase?expID=<your_experiment_ID>" -O myDatabase
     79}}}
     80
     81 * If the experiment ID contains non-alphanumeric ASCII characters, it is necessary to escape each of them using "%" followed by the ASCII code.
     82
     83In order to get SQLite to recognize the database, it first must be told that the information '''is''' a database.
     84{{{
     85sqlite3 -init myDatabase myDatabase.sq3
     86}}}
     87
     88You can also view the results in a web browser by visiting the following URL:
     89{{{
     90http://console.sb4.orbit-lab.org:5054/result/dumpDatabase?expID=<your_experiment_ID>
     91}}}
     92For 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
     93{{{
     94http://console.sb4.orbit-lab.org:5054/result/dumpDatabase?expID=default_slice-2016-06-10t09.01.04.779-04.00
     95}}}
     96The resulting abbreviated output is:
     97{{{
     98--
     99-- Database Dump
     100-- Experiment ID: default_slice-2016-06-10t09.01.04.779-04.00
     101--
     102PRAGMA foreign_keys=OFF;
     103BEGIN TRANSACTION;
     104CREATE TABLE _senders (name TEXT PRIMARY KEY, id INTEGER UNIQUE);
     105INSERT INTO "_senders" VALUES('0',1);
     106INSERT INTO "_senders" VALUES('1',2);
     107CREATE 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);
     108INSERT INTO "_experiment_metadata" VALUES(1,NULL,NULL,NULL,NULL,NULL,'table__experiment_metadata','0 _experiment_metadata subject:string key:string value:string');
     109INSERT INTO "_experiment_metadata" VALUES(2,NULL,NULL,NULL,NULL,NULL,'start_time','1465563690');
     110INSERT 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');
     111INSERT 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');
     112INSERT 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');
     113INSERT 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');
     114INSERT 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');
     115INSERT 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');
     116INSERT 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');
     117INSERT 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');
     118INSERT INTO "_experiment_metadata" VALUES(11,1,1,7.30248999781906604766e-01,6.64401999999999937074e-01,'.','appname','iperf');
     119INSERT INTO "_experiment_metadata" VALUES(12,1,2,0.730273999273777,0.664441,'.','version','2.11.0');
     120INSERT 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');
     121INSERT INTO "_experiment_metadata" VALUES(14,1,1,7.30248999781906604766e-01,0.66447,'.','appname','iperf');
     122INSERT INTO "_experiment_metadata" VALUES(15,1,2,0.730273999273777,0.664526,'.','version','2.11.0');
     123INSERT 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');
     124INSERT INTO "_experiment_metadata" VALUES(17,1,1,9.61976999416947364807e-01,0.664928,'.','appname','iperf');
     125INSERT INTO "_experiment_metadata" VALUES(18,1,2,9.61991999298334121704e-01,6.6494199999999992201e-01,'.','version','2.11.0');
     126INSERT 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');
     127INSERT INTO "_experiment_metadata" VALUES(20,1,1,9.61976999416947364807e-01,6.64968999999999921257e-01,'.','appname','iperf');
     128INSERT INTO "_experiment_metadata" VALUES(21,1,2,9.61991999298334121704e-01,0.665026,'.','version','2.11.0');
     129INSERT 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');
     130INSERT INTO "_experiment_metadata" VALUES(23,2,1,2.68745409995317459102e+01,26.631372,'.','appname','iperf');
     131INSERT INTO "_experiment_metadata" VALUES(24,2,2,2.68745549991726875296e+01,26.781102,'.','version','2.11.0');
     132INSERT 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');
     133INSERT INTO "_experiment_metadata" VALUES(26,2,1,2.68745409995317459102e+01,26.78114,'.','appname','iperf');
     134INSERT INTO "_experiment_metadata" VALUES(27,2,2,2.68745549991726875296e+01,26.781169,'.','version','2.11.0');
     135INSERT 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');
     136INSERT INTO "_experiment_metadata" VALUES(29,2,1,2.71345789998304098844e+01,26.781887,'.','appname','iperf');
     137INSERT INTO "_experiment_metadata" VALUES(30,2,2,2.71346039997879415759e+01,2.67818979999999982064e+01,'.','version','2.11.0');
     138INSERT 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');
     139INSERT INTO "_experiment_metadata" VALUES(32,2,1,2.71345789998304098844e+01,26.781946,'.','appname','iperf');
     140INSERT INTO "_experiment_metadata" VALUES(33,2,2,2.71346039997879415759e+01,26.781958,'.','version','2.11.0');
     141INSERT 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');
     142CREATE 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);
     143INSERT INTO "_client_instrumentation" VALUES(1,1,1,7.30261999182403087615e-01,6.64478999999999930814e-01,1,0,35330,15766,19564,21289);
     144INSERT INTO "_client_instrumentation" VALUES(2,1,1,9.61989999748766422271e-01,0.664978,1,0,35330,15766,19564,21289);
     145INSERT INTO "_client_instrumentation" VALUES(3,2,1,2.68745529996231198306e+01,26.781148,1,0,35330,15766,19564,21289);
     146INSERT INTO "_client_instrumentation" VALUES(4,1,2,2.70340389907360076912e+01,26.781314,1,0,39558,19417,20141,21541);
     147INSERT INTO "_client_instrumentation" VALUES(5,1,2,2.67115789949893951411e+01,26.781397,1,0,39558,19417,20141,21541);
     148INSERT INTO "_client_instrumentation" VALUES(6,2,1,27.1345919999294,26.781952,1,0,35330,15766,19564,21289);
     149INSERT INTO "_client_instrumentation" VALUES(7,1,3,2.70129119753837585457e+01,26.940808,17,0,39638,19497,20141,21541);
     150INSERT INTO "_client_instrumentation" VALUES(8,2,2,2.7781223999336361885e+01,27.536649,1,0,39676,19488,20188,21613);
     151INSERT INTO "_client_instrumentation" VALUES(9,2,2,2.81708319988101720801e+01,27.701432,2,0,39676,19488,20188,21613);
     152INSERT INTO "_client_instrumentation" VALUES(10,1,3,2.80057679712772369376e+01,27.706225,114,0,39638,19497,20141,21541);
     153INSERT INTO "_client_instrumentation" VALUES(11,2,3,2.80977949984371662139e+01,27.85319,2,0,39676,19488,20188,21613);
     154INSERT INTO "_client_instrumentation" VALUES(12,1,4,2.80057809948921203613e+01,27.933659,151,0,39638,19497,20141,21541);
     155INSERT INTO "_client_instrumentation" VALUES(13,1,4,2.9003846973180770874e+01,28.704269,301,0,39638,19497,20141,21541);
     156INSERT INTO "_client_instrumentation" VALUES(14,2,3,2.91962629966437816611e+01,28.726833,4,0,39676,19488,20188,21613);
     157INSERT INTO "_client_instrumentation" VALUES(15,1,5,2.9003676980733871459e+01,28.931543,371,0,39638,19497,20141,21541);
     158INSERT INTO "_client_instrumentation" VALUES(16,2,4,2.93127429969608783721e+01,29.1752,5,0,39676,19488,20188,21613);
     159INSERT INTO "_client_instrumentation" VALUES(17,1,5,3.00062709748744964603e+01,29.706658,508,0,39638,19497,20141,21541);
     160INSERT INTO "_client_instrumentation" VALUES(18,2,5,3.00703979954123497004e+01,29.825767,7,0,39676,19488,20188,21613);
     161INSERT INTO "_client_instrumentation" VALUES(19,1,6,3.00034049749374389639e+01,29.931197,579,0,39638,19497,20141,21541);
     162INSERT INTO "_client_instrumentation" VALUES(20,2,4,3.04460669979453086848e+01,29.976623,7,0,39676,19488,20188,21613);
     163INSERT INTO "_client_instrumentation" VALUES(21,1,6,3.10042159855365753165e+01,30.704597,725,0,39638,19497,20141,21541);
     164INSERT INTO "_client_instrumentation" VALUES(22,2,5,31.2748069986701,30.805343,9,0,39676,19488,20188,21613);
     165INSERT INTO "_client_instrumentation" VALUES(23,1,7,3.10044999718666076655e+01,30.932287,800,0,39638,19497,20141,21541);
     166INSERT INTO "_client_instrumentation" VALUES(24,2,6,3.12099489942193031311e+01,30.965286,10,0,39676,19488,20188,21613);
     167INSERT INTO "_client_instrumentation" VALUES(25,2,6,3.2075513996183872222e+01,31.606047,11,0,39676,19488,20188,21613);
     168INSERT INTO "_client_instrumentation" VALUES(26,1,7,3.20075639486312866219e+01,31.707934,934,0,39638,19497,20141,21541);
     169INSERT INTO "_client_instrumentation" VALUES(27,1,8,3.20049169659614562988e+01,31.932628,999,0,39638,19497,20141,21541);
     170INSERT INTO "_client_instrumentation" VALUES(28,2,7,3.22397009953856468196e+01,31.995029,12,0,39676,19488,20188,21613);
     171INSERT INTO "_client_instrumentation" VALUES(29,1,8,3.3007899999618530273e+01,32.708231,1151,0,39638,19497,20141,21541);
     172INSERT INTO "_client_instrumentation" VALUES(30,2,8,3.3058653995394706726e+01,32.813962,14,0,39676,19488,20188,21613);
     173INSERT INTO "_client_instrumentation" VALUES(31,2,7,3.33647639974951744075e+01,32.895279,14,0,39676,19488,20188,21613);
     174INSERT INTO "_client_instrumentation" VALUES(32,1,9,3.30040469765663146972e+01,32.931721,1211,0,39638,19497,20141,21541);
     175INSERT INTO "_client_instrumentation" VALUES(33,1,9,34.0037339925766,33.70408,1350,0,39638,19497,20141,21541);
     176INSERT INTO "_client_instrumentation" VALUES(34,2,8,3.42258349955081939705e+01,33.756295,16,0,39676,19488,20188,21613);
     177INSERT INTO "_client_instrumentation" VALUES(35,1,10,3.40075799822807312011e+01,33.935257,1418,0,39638,19497,20141,21541);
     178INSERT INTO "_client_instrumentation" VALUES(36,2,9,3.42833709865808486947e+01,3.41527870000000035579e+01,17,0,39676,19488,20188,21613);
     179INSERT INTO "_client_instrumentation" VALUES(37,2,9,3.50912769883871078491e+01,34.621755,18,0,39676,19488,20188,21613);
     180INSERT INTO "_client_instrumentation" VALUES(38,1,10,3.50031719803810119633e+01,34.703471,1560,0,39638,19497,20141,21541);
     181INSERT INTO "_client_instrumentation" VALUES(39,1,11,3.50042579770088195805e+01,34.931905,1612,0,39638,19497,20141,21541);
     182INSERT INTO "_client_instrumentation" VALUES(40,2,10,3.52719179987907409672e+01,35.143509,19,0,39676,19488,20188,21613);
     183INSERT INTO "_client_instrumentation" VALUES(41,1,11,3.60031589865684509277e+01,35.703463,1788,0,39638,19497,20141,21541);
     184INSERT INTO "_client_instrumentation" VALUES(42,2,10,3.62123109996318817129e+01,35.74275,21,0,39676,19488,20188,21613);
     185INSERT INTO "_client_instrumentation" VALUES(43,1,12,3.60031059980392456046e+01,35.930702,1840,0,39638,19497,20141,21541);
     186INSERT INTO "_client_instrumentation" VALUES(44,2,11,3.62352139949798583988e+01,35.990454,21,0,39676,19488,20188,21613);
     187INSERT INTO "_client_instrumentation" VALUES(45,1,12,3.7004411995410919189e+01,36.704704,2000,0,39638,19497,20141,21541);
     188INSERT INTO "_client_instrumentation" VALUES(46,2,12,3.70716489851474761962e+01,36.826857,24,0,39676,19488,20188,21613);
     189INSERT INTO "_client_instrumentation" VALUES(47,2,11,3.73297969996929168701e+01,36.860203,23,0,39676,19488,20188,21613);
     190INSERT INTO "_client_instrumentation" VALUES(48,1,13,3.70047229528427124023e+01,36.932288,2045,0,39638,19497,20141,21541);
     191INSERT INTO "_client_instrumentation" VALUES(49,1,13,3.8004593968391418457e+01,37.704846,2198,0,39638,19497,20141,21541);
     192INSERT INTO "_client_instrumentation" VALUES(50,2,12,3.81936279982328414916e+01,37.724015,26,0,39676,19488,20188,21613);
     193INSERT INTO "_client_instrumentation" VALUES(51,1,14,3.80142779946327209472e+01,37.941815,2251,0,39638,19497,20141,21541);
     194INSERT INTO "_client_instrumentation" VALUES(52,2,13,38.4186489880085,38.173843,27,0,39676,19488,20188,21613);
     195INSERT INTO "_client_instrumentation" VALUES(53,2,13,3.90433079898357391366e+01,38.573699,28,0,39676,19488,20188,21613);
     196INSERT INTO "_client_instrumentation" VALUES(54,1,14,3.90084779858589172354e+01,38.708732,2421,0,39638,19497,20141,21541);
     197INSERT INTO "_client_instrumentation" VALUES(55,1,15,3.90046509504318237313e+01,38.932172,2477,0,39638,19497,20141,21541);
     198INSERT INTO "_client_instrumentation" VALUES(56,2,14,3.93293439894914627075e+01,39.150918,29,0,39676,19488,20188,21613);
     199INSERT INTO "_client_instrumentation" VALUES(57,1,15,4.00059019923210144051e+01,39.70613,2618,0,39638,19497,20141,21541);
     200INSERT INTO "_client_instrumentation" VALUES(58,2,15,4.00273769944906234732e+01,39.782555,31,0,39676,19488,20188,21613);
     201INSERT INTO "_client_instrumentation" VALUES(59,1,16,4.00049479603767395036e+01,39.932413,2701,0,39638,19497,20141,21541);
     202INSERT INTO "_client_instrumentation" VALUES(60,2,14,4.04227859973907470685e+01,39.95313,31,0,39676,19488,20188,21613);
     203INSERT INTO "_client_instrumentation" VALUES(61,1,16,4.10041639804840087881e+01,40.704372,2837,0,39638,19497,20141,21541);
     204INSERT INTO "_client_instrumentation" VALUES(62,2,15,4.12174219936132431047e+01,40.747753,33,0,39676,19488,20188,21613);
     205INSERT INTO "_client_instrumentation" VALUES(63,2,16,4.11109419912099838256e+01,40.866112,34,0,39676,19488,20188,21613);
     206INSERT INTO "_client_instrumentation" VALUES(64,1,17,4.10085979700088500967e+01,40.936049,2907,0,39638,19497,20141,21541);
     207INSERT INTO "_client_instrumentation" VALUES(65,2,16,4.20935109853744506827e+01,41.623838,35,0,39676,19488,20188,21613);
     208INSERT INTO "_client_instrumentation" VALUES(66,1,17,4.20188709497451782235e+01,41.719037,3055,0,39638,19497,20141,21541);
     209INSERT INTO "_client_instrumentation" VALUES(67,2,17,4.20899809896945953369e+01,41.845138,36,0,39676,19488,20188,21613);
     210INSERT INTO "_client_instrumentation" VALUES(68,1,18,4.20069729685783386239e+01,41.934394,3103,0,39638,19497,20141,21541);
     211INSERT INTO "_client_instrumentation" VALUES(69,2,17,4.31773329973220825177e+01,42.7076,38,0,39676,19488,20188,21613);
     212INSERT INTO "_client_instrumentation" VALUES(70,1,18,4.30140099525451660147e+01,42.714141,3281,0,39638,19497,20141,21541);
     213INSERT INTO "_client_instrumentation" VALUES(71,1,19,4.30031389594078063956e+01,42.930543,3320,0,39638,19497,20141,21541);
     214INSERT INTO "_client_instrumentation" VALUES(72,2,18,4.31978919804096221906e+01,42.953006,38,0,39676,19488,20188,21613);
     215INSERT INTO "_client_instrumentation" VALUES(73,2,18,4.40306629836559295645e+01,43.560928,40,0,39676,19488,20188,21613);
     216INSERT INTO "_client_instrumentation" VALUES(74,1,19,4.4005901992321014406e+01,43.706045,3494,0,39638,19497,20141,21541);
     217INSERT INTO "_client_instrumentation" VALUES(75,2,19,4.40777549743652343741e+01,43.832842,40,0,39676,19488,20188,21613);
     218INSERT INTO "_client_instrumentation" VALUES(76,1,20,4.4003269970417022705e+01,43.930634,3528,0,39638,19497,20141,21541);
     219INSERT INTO "_client_instrumentation" VALUES(77,1,20,4.50042749643325805646e+01,44.70439,3697,0,39638,19497,20141,21541);
     220INSERT INTO "_client_instrumentation" VALUES(78,2,19,4.51787939965724945085e+01,44.709032,42,0,39676,19488,20188,21613);
     221INSERT INTO "_client_instrumentation" VALUES(79,1,21,4.50042819976806640625e+01,44.931576,3735,0,39638,19497,20141,21541);
     222INSERT INTO "_client_instrumentation" VALUES(80,2,20,4.52707509994506835954e+01,45.163593,43,0,39676,19488,20188,21613);
     223INSERT INTO "_client_instrumentation" VALUES(81,2,20,4.60295249819755554216e+01,45.559765,44,0,39676,19488,20188,21613);
     224INSERT INTO "_client_instrumentation" VALUES(82,1,21,4.60172069668769836417e+01,45.71731,3895,0,39638,19497,20141,21541);
     225INSERT INTO "_client_instrumentation" VALUES(83,2,21,4.61048889756202697745e+01,45.859933,45,0,39676,19488,20188,21613);
     226INSERT INTO "_client_instrumentation" VALUES(84,1,22,4.60247329473495483389e+01,45.952034,3961,0,39638,19497,20141,21541);
     227INSERT INTO "_client_instrumentation" VALUES(85,1,22,4.70053049921989440917e+01,46.705481,4103,0,39638,19497,20141,21541);
     228INSERT INTO "_client_instrumentation" VALUES(86,2,21,4.71887479722499847412e+01,46.718951,47,0,39676,19488,20188,21613);
     229INSERT INTO "_client_instrumentation" VALUES(87,1,23,4.70097019672393798836e+01,46.936949,4168,0,39638,19497,20141,21541);
     230CREATE 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);
     231INSERT 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);
     232INSERT 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);
     233INSERT 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);
     234INSERT 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);
     235CREATE 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);
     236INSERT INTO "iperf_settings" VALUES(1,1,1,7.31554999947547912597e-01,0.664581,833850270123997830,0,'0.0.0.0',0,0,6,87380,131072);
     237INSERT INTO "iperf_settings" VALUES(2,1,1,9.62284999899566173553e-01,0.66508,6316594332143149512,0,'0.0.0.0',0,0,6,87380,131072);
     238INSERT INTO "iperf_settings" VALUES(3,2,1,2.68817029995843768128e+01,26.781207,-3544341636566083228,1,'0.0.0.0',0,0,6,87040,131072);
     239INSERT INTO "iperf_settings" VALUES(4,2,1,2.71957059998530894509e+01,26.781977,-4638133553200985154,1,'0.0.0.0',0,0,6,87040,131072);
     240CREATE 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);
     241INSERT INTO "iperf_connection" VALUES(1,1,1,2.70340309739112854008e+01,26.781242,6316594332143149512,-3379649244129461518,'192.168.0.1',5001,'192.168.0.2',33018);
     242INSERT INTO "iperf_connection" VALUES(2,1,2,2.7034040987491607666e+01,26.781322,6316594332143149512,-510027827797102319,'192.168.0.1',0,'192.168.0.2',0);
     243INSERT INTO "iperf_connection" VALUES(3,1,1,2.67115709781646728506e+01,26.781355,833850270123997830,5407760560782721986,'192.168.0.1',5001,'192.168.0.2',39692);
     244INSERT INTO "iperf_connection" VALUES(4,1,2,2.67115819752216339106e+01,26.781405,833850270123997830,3968755486798925933,'192.168.0.1',0,'192.168.0.2',0);
     245INSERT INTO "iperf_connection" VALUES(5,2,1,2.68817159999161958694e+01,26.781674,-3544341636566083228,-6410456378195227249,'192.168.0.2',39692,'192.168.0.1',5001);
     246INSERT INTO "iperf_connection" VALUES(6,2,1,2.71957329998258501291e+01,26.781987,-4638133553200985154,-5067046478646040380,'192.168.0.2',33018,'192.168.0.1',5001);
     247CREATE 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);
     248INSERT INTO "iperf_transfer" VALUES(1,1,1,2.77147699892520904541e+01,27.642629,833850270123997830,5407760560782721986,0.0,1.0,130320);
     249INSERT INTO "iperf_transfer" VALUES(2,1,1,2.80369869768619537362e+01,27.737423,6316594332143149512,-3379649244129461518,0.0,1.0,173760);
     250INSERT INTO "iperf_transfer" VALUES(3,1,2,2.87143209874629974365e+01,28.64217,833850270123997830,5407760560782721986,1.0,2.0,304080);
     251INSERT INTO "iperf_transfer" VALUES(4,1,2,2.90520899891853332528e+01,28.752541,6316594332143149512,-3379649244129461518,1.0,2.0,272224);
     252INSERT INTO "iperf_transfer" VALUES(5,1,3,2.97136329710483551016e+01,29.641412,833850270123997830,5407760560782721986,2.0,3.0,309872);
     253INSERT INTO "iperf_transfer" VALUES(6,1,3,3.00345329940319061279e+01,29.734962,6316594332143149512,-3379649244129461518,2.0,3.0,291048);
     254INSERT INTO "iperf_transfer" VALUES(7,1,4,3.07127509713172912601e+01,30.640503,833850270123997830,5407760560782721986,3.0,4.0,314216);
     255INSERT INTO "iperf_transfer" VALUES(8,1,4,3.10349929928779602042e+01,30.735403,6316594332143149512,-3379649244129461518,3.0,4.0,321456);
     256INSERT INTO "iperf_transfer" VALUES(9,1,5,3.17155589759349822989e+01,31.64329,833850270123997830,5407760560782721986,4.0,5.0,299736);
     257INSERT INTO "iperf_transfer" VALUES(10,1,5,3.203489595651626587e+01,31.735246,6316594332143149512,-3379649244129461518,4.0,5.0,306976);
     258INSERT INTO "iperf_transfer" VALUES(11,2,1,3.22397039979696273812e+01,31.995167,-3544341636566083228,-6410456378195227249,0.0,5.0,1441792);
     259INSERT INTO "iperf_transfer" VALUES(12,2,1,3.25710929930210113525e+01,32.149049,-4638133553200985154,-5067046478646040380,0.0,5.0,1441792);
     260INSERT INTO "iperf_transfer" VALUES(13,1,6,3.27131999731063842777e+01,32.640889,833850270123997830,5407760560782721986,5.0,6.0,304080);
     261INSERT INTO "iperf_transfer" VALUES(14,1,6,3.30381989479064941406e+01,32.738539,6316594332143149512,-3379649244129461518,5.0,6.0,308424);
     262INSERT INTO "iperf_transfer" VALUES(15,1,7,3.37150639891624450674e+01,33.642728,833850270123997830,5407760560782721986,6.0,7.0,315664);
     263INSERT INTO "iperf_transfer" VALUES(16,1,7,34.0368549823761,33.737175,6316594332143149512,-3379649244129461518,6.0,7.0,291048);
     264INSERT INTO "iperf_transfer" VALUES(17,1,8,3.47192999720573425292e+01,34.646964,833850270123997830,5407760560782721986,7.0,8.0,278016);
     265INSERT INTO "iperf_transfer" VALUES(18,1,8,3.50351879596710205069e+01,34.73547,6316594332143149512,-3379649244129461518,7.0,8.0,306976);
     266INSERT INTO "iperf_transfer" VALUES(19,1,9,3.57166519761085510253e+01,35.64431,833850270123997830,5407760560782721986,8.0,9.0,305528);
     267INSERT INTO "iperf_transfer" VALUES(20,1,9,3.60375219583511352539e+01,35.737809,6316594332143149512,-3379649244129461518,8.0,9.0,327248);
     268INSERT INTO "iperf_transfer" VALUES(21,1,10,3.67127069830894470214e+01,36.640308,833850270123997830,5407760560782721986,9.0,10.0,317112);
     269INSERT INTO "iperf_transfer" VALUES(22,1,10,3.70350579619407653812e+01,36.735354,6316594332143149512,-3379649244129461518,9.0,10.0,304080);
     270INSERT INTO "iperf_transfer" VALUES(23,2,2,3.70716509968042373657e+01,36.826996,-3544341636566083228,-6410456378195227249,5.0,10.0,1572864);
     271INSERT INTO "iperf_transfer" VALUES(24,2,2,3.73297989964485168448e+01,36.860246,-4638133553200985154,-5067046478646040380,5.0,10.0,1441792);
     272INSERT INTO "iperf_transfer" VALUES(25,1,11,3.77142209410667419424e+01,37.641748,833850270123997830,5407760560782721986,10.0,11.0,305528);
     273INSERT INTO "iperf_transfer" VALUES(26,1,11,3.80390549898147583007e+01,37.739297,6316594332143149512,-3379649244129461518,10.0,11.0,288152);
     274INSERT INTO "iperf_transfer" VALUES(27,1,12,3.87128459811210632332e+01,38.640341,833850270123997830,5407760560782721986,11.0,12.0,308424);
     275INSERT INTO "iperf_transfer" VALUES(28,1,12,3.90341869592666625967e+01,38.73444,6316594332143149512,-3379649244129461518,11.0,12.0,327248);
     276INSERT INTO "iperf_transfer" VALUES(29,1,13,39.7122939825058,39.639783,833850270123997830,5407760560782721986,12.0,13.0,317112);
     277INSERT INTO "iperf_transfer" VALUES(30,1,13,4.00510689616203308105e+01,39.751305,6316594332143149512,-3379649244129461518,12.0,13.0,283808);
     278INSERT INTO "iperf_transfer" VALUES(31,1,14,4.07144529819488525373e+01,40.641924,833850270123997830,5407760560782721986,13.0,14.0,327248);
     279INSERT INTO "iperf_transfer" VALUES(32,1,14,4.10453369617462158211e+01,40.745506,6316594332143149512,-3379649244129461518,13.0,14.0,320008);
     280INSERT INTO "iperf_transfer" VALUES(33,1,15,4.1715602993965148924e+01,41.643009,833850270123997830,5407760560782721986,14.0,15.0,278016);
     281INSERT INTO "iperf_transfer" VALUES(34,1,15,4.20377579927444457999e+01,41.737904,6316594332143149512,-3379649244129461518,14.0,15.0,305528);
     282INSERT INTO "iperf_transfer" VALUES(35,2,3,4.20899839997291564958e+01,41.845146,-3544341636566083228,-6410456378195227249,10.0,15.0,1572864);
     283INSERT INTO "iperf_transfer" VALUES(36,2,3,4.2394909992814064025e+01,41.925208,-4638133553200985154,-5067046478646040380,10.0,15.0,1703936);
     284INSERT INTO "iperf_transfer" VALUES(37,1,16,4.2717866957187652587e+01,42.64525,833850270123997830,5407760560782721986,15.0,16.0,293944);
     285INSERT INTO "iperf_transfer" VALUES(38,1,16,4.30392599701881408682e+01,42.739399,6316594332143149512,-3379649244129461518,15.0,16.0,328696);
     286INSERT INTO "iperf_transfer" VALUES(39,1,17,4.37219039797782897931e+01,43.649286,833850270123997830,5407760560782721986,16.0,17.0,304080);
     287INSERT INTO "iperf_transfer" VALUES(40,1,17,4.40416289567947387677e+01,43.741738,6316594332143149512,-3379649244129461518,16.0,17.0,311320);
     288INSERT INTO "iperf_transfer" VALUES(41,1,18,4.47119509577751159676e+01,44.639294,833850270123997830,5407760560782721986,17.0,18.0,302632);
     289INSERT INTO "iperf_transfer" VALUES(42,1,18,4.50348509550094604474e+01,44.73494,6316594332143149512,-3379649244129461518,17.0,18.0,292496);
     290INSERT INTO "iperf_transfer" VALUES(43,1,19,4.57163599729537963858e+01,45.64363,833850270123997830,5407760560782721986,18.0,19.0,308424);
     291INSERT INTO "iperf_transfer" VALUES(44,1,19,46.0443149805069,45.744415,6316594332143149512,-3379649244129461518,18.0,19.0,280912);
     292INSERT INTO "iperf_transfer" VALUES(45,1,20,46.7140149474144,46.641274,833850270123997830,5407760560782721986,19.0,20.0,320008);
     293INSERT INTO "iperf_transfer" VALUES(46,2,4,4.69332739710807800292e+01,46.688349,-3544341636566083228,-6410456378195227249,15.0,20.0,1441792);
     294INSERT INTO "iperf_transfer" VALUES(47,1,20,4.70358919501304626473e+01,46.735966,6316594332143149512,-3379649244129461518,19.0,20.0,305528);
     295INSERT INTO "iperf_transfer" VALUES(48,2,4,4.77811639904975891121e+01,47.311348,-4638133553200985154,-5067046478646040380,15.0,20.0,1572864);
     296CREATE 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);
     297CREATE 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);
     298CREATE 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);
     299INSERT INTO "iperf_packets" VALUES(1,1,1,2.70599989891052246089e+01,26.781331,6316594332143149512,-3379649244129461518,0,1448,1465563717,59998,0,0);
     300INSERT INTO "iperf_packets" VALUES(2,1,1,2.67179559767246246329e+01,26.781413,833850270123997830,5407760560782721986,0,1448,1465563716,717955,0,0);
     301INSERT INTO "iperf_packets" VALUES(3,1,2,2.67260909974575042733e+01,26.781421,833850270123997830,5407760560782721986,0,1448,1465563716,726090,0,0);
     302INSERT INTO "iperf_packets" VALUES(4,1,3,2.67341959774494171138e+01,26.781428,833850270123997830,5407760560782721986,0,1448,1465563716,734195,0,0);
     303INSERT INTO "iperf_packets" VALUES(5,1,4,2.67425009906291961665e+01,26.781435,833850270123997830,5407760560782721986,0,1448,1465563716,742500,0,0);
     304INSERT INTO "iperf_packets" VALUES(6,1,2,2.70808679759502410897e+01,26.781689,6316594332143149512,-3379649244129461518,0,1448,1465563717,80868,0,0);
     305INSERT INTO "iperf_packets" VALUES(7,1,5,2.67666969895362854008e+01,2.67817009999999982032e+01,833850270123997830,5407760560782721986,0,1448,1465563716,766697,0,0);
     306INSERT INTO "iperf_packets" VALUES(8,1,6,2.67901219725608825679e+01,26.781709,833850270123997830,5407760560782721986,0,1448,1465563716,790122,0,0);
     307INSERT INTO "iperf_packets" VALUES(9,1,7,2.67969239950180053715e+01,26.781715,833850270123997830,5407760560782721986,0,1448,1465563716,796923,0,0);
     308INSERT INTO "iperf_packets" VALUES(10,1,8,2.68049979805946350088e+01,26.781722,833850270123997830,5407760560782721986,0,1448,1465563716,804997,0,0);
     309INSERT INTO "iperf_packets" VALUES(11,1,9,2.68131279945373535156e+01,26.781728,833850270123997830,5407760560782721986,0,1448,1465563716,813128,0,0);
     310INSERT INTO "iperf_packets" VALUES(12,1,10,2.68194109797477722159e+01,26.781734,833850270123997830,5407760560782721986,0,1448,1465563716,819410,0,0);
     311INSERT INTO "iperf_packets" VALUES(13,1,11,2.68406479954719543465e+01,26.781741,833850270123997830,5407760560782721986,0,1448,1465563716,840647,0,0);
     312INSERT INTO "iperf_packets" VALUES(14,1,12,2.68872009813785552969e+01,26.815101,833850270123997830,5407760560782721986,0,1448,1465563716,887200,0,0);
     313INSERT INTO "iperf_packets" VALUES(15,1,3,2.71287169754505157475e+01,26.82918,6316594332143149512,-3379649244129461518,0,1448,1465563717,128716,0,0);
     314INSERT INTO "iperf_packets" VALUES(16,1,4,2.71411459743976593008e+01,26.841607,6316594332143149512,-3379649244129461518,0,1448,1465563717,141145,0,0);
     315INSERT INTO "iperf_packets" VALUES(17,1,13,2.69231809973716735835e+01,26.851093,833850270123997830,5407760560782721986,0,1448,1465563716,923180,0,0);
     316INSERT INTO "iperf_packets" VALUES(18,1,5,2.71647219955921173087e+01,26.865168,6316594332143149512,-3379649244129461518,0,1448,1465563717,164722,0,0);
     317INSERT INTO "iperf_packets" VALUES(19,1,6,2.71776079833507537846e+01,26.878046,6316594332143149512,-3379649244129461518,0,1448,1465563717,177608,0,0);
     318INSERT INTO "iperf_packets" VALUES(20,1,14,2.69582189917564392085e+01,26.886084,833850270123997830,5407760560782721986,0,1448,1465563716,958218,0,0);
     319INSERT INTO "iperf_packets" VALUES(21,1,15,2.69674469828605651851e+01,26.895319,833850270123997830,5407760560782721986,0,1448,1465563716,967447,0,0);
     320INSERT INTO "iperf_packets" VALUES(22,1,7,2.72081859707832336421e+01,26.908648,6316594332143149512,-3379649244129461518,0,1448,1465563717,208186,0,0);
     321INSERT INTO "iperf_packets" VALUES(23,1,16,2.69884559810161590571e+01,26.91637,833850270123997830,5407760560782721986,0,1448,1465563716,988455,0,0);
     322INSERT INTO "iperf_packets" VALUES(24,1,8,2.72201529741287231436e+01,26.920652,6316594332143149512,-3379649244129461518,0,1448,1465563717,220153,0,0);
     323INSERT INTO "iperf_packets" VALUES(25,1,9,2.72329019904136657723e+01,26.933361,6316594332143149512,-3379649244129461518,0,1448,1465563717,232902,0,0);
     324INSERT INTO "iperf_packets" VALUES(26,1,17,2.70129089951515197762e+01,26.940797,833850270123997830,5407760560782721986,0,1448,1465563717,12908,0,0);
     325INSERT INTO "iperf_packets" VALUES(27,1,10,2.72531469762325286856e+01,26.953647,6316594332143149512,-3379649244129461518,0,1448,1465563717,253147,0,0);
     326INSERT INTO "iperf_packets" VALUES(28,1,11,2.72800649702548980712e+01,26.980573,6316594332143149512,-3379649244129461518,0,1448,1465563717,280064,0,0);
     327INSERT INTO "iperf_packets" VALUES(29,1,18,2.70593959987163543709e+01,26.987276,833850270123997830,5407760560782721986,0,1448,1465563717,59396,0,0);
     328INSERT INTO "iperf_packets" VALUES(30,1,12,2.73009749948978424076e+01,27.00145,6316594332143149512,-3379649244129461518,0,1448,1465563717,300975,0,0);
     329INSERT INTO "iperf_packets" VALUES(31,1,13,2.73249119818210601802e+01,27.149188,6316594332143149512,-3379649244129461518,0,1448,1465563717,324912,0,0);
     330INSERT INTO "iperf_packets" VALUES(32,1,14,2.73377969861030578613e+01,27.149199,6316594332143149512,-3379649244129461518,0,1448,1465563717,337797,0,0);
     331INSERT INTO "iperf_packets" VALUES(33,1,15,2.73506819903850555424e+01,27.149206,6316594332143149512,-3379649244129461518,0,1448,1465563717,350682,0,0);
     332INSERT INTO "iperf_packets" VALUES(34,1,16,2.73635269999504089351e+01,27.149236,6316594332143149512,-3379649244129461518,0,1448,1465563717,363527,0,0);
     333INSERT INTO "iperf_packets" VALUES(35,1,17,2.73840119838714599618e+01,27.149244,6316594332143149512,-3379649244129461518,0,1448,1465563717,384011,0,0);
     334INSERT INTO "iperf_packets" VALUES(36,1,18,2.74058919847011566166e+01,27.14925,6316594332143149512,-3379649244129461518,0,1448,1465563717,405891,0,0);
     335INSERT INTO "iperf_packets" VALUES(37,1,19,2.74308009743690490718e+01,27.149257,6316594332143149512,-3379649244129461518,0,1448,1465563717,430800,0,0);
     336INSERT INTO "iperf_packets" VALUES(38,1,19,2.70779859721660614018e+01,27.149272,833850270123997830,5407760560782721986,0,1448,1465563717,77985,0,0);
     337INSERT INTO "iperf_packets" VALUES(39,1,20,27.0845929980278,27.149281,833850270123997830,5407760560782721986,0,1448,1465563717,84593,0,0);
     338INSERT INTO "iperf_packets" VALUES(40,1,21,2.71428399980068206791e+01,27.149296,833850270123997830,5407760560782721986,0,1448,1465563717,142839,0,0);
     339INSERT INTO "iperf_packets" VALUES(41,1,22,2.7167058974504470826e+01,27.149304,833850270123997830,5407760560782721986,0,1448,1465563717,167058,0,0);
     340INSERT INTO "iperf_packets" VALUES(42,1,23,2.71811539828777313241e+01,27.149311,833850270123997830,5407760560782721986,0,1448,1465563717,181153,0,0);
     341INSERT INTO "iperf_packets" VALUES(43,1,24,2.71891619861125946036e+01,27.149318,833850270123997830,5407760560782721986,0,1448,1465563717,189161,0,0);
     342INSERT INTO "iperf_packets" VALUES(44,1,25,2.72107269763946533211e+01,27.149325,833850270123997830,5407760560782721986,0,1448,1465563717,210725,0,0);
     343INSERT INTO "iperf_packets" VALUES(45,1,20,2.7450983971357345581e+01,27.151459,6316594332143149512,-3379649244129461518,0,1448,1465563717,450984,0,0);
     344INSERT INTO "iperf_packets" VALUES(46,1,21,2.74765609800815582266e+01,27.177018,6316594332143149512,-3379649244129461518,0,1448,1465563717,476560,0,0);
     345INSERT INTO "iperf_packets" VALUES(47,1,22,2.74933359920978546151e+01,27.19379,6316594332143149512,-3379649244129461518,0,1448,1465563717,493336,0,0);
     346INSERT INTO "iperf_packets" VALUES(48,1,23,2.74986129999160766601e+01,27.199081,6316594332143149512,-3379649244129461518,0,1448,1465563717,498613,0,0);
     347INSERT INTO "iperf_packets" VALUES(49,1,26,2.72761509716510772713e+01,27.204024,833850270123997830,5407760560782721986,0,1448,1465563717,276150,0,0);
     348INSERT INTO "iperf_packets" VALUES(50,1,24,2.75062769949436187739e+01,27.206719,6316594332143149512,-3379649244129461518,0,1448,1465563717,506277,0,0);
     349INSERT INTO "iperf_packets" VALUES(51,1,27,2.72854759991168975834e+01,27.213358,833850270123997830,5407760560782721986,0,1448,1465563717,285475,0,0);
     350INSERT INTO "iperf_packets" VALUES(52,1,28,2.72898949980735778804e+01,27.217751,833850270123997830,5407760560782721986,0,1448,1465563717,289894,0,0);
     351INSERT INTO "iperf_packets" VALUES(53,1,25,2.75200339853763580326e+01,27.220495,6316594332143149512,-3379649244129461518,0,1448,1465563717,520031,0,0);
     352INSERT INTO "iperf_packets" VALUES(54,1,29,2.72992919981479644766e+01,27.227186,833850270123997830,5407760560782721986,0,1448,1465563717,299291,0,0);
     353INSERT INTO "iperf_packets" VALUES(55,1,30,2.73066699802875518794e+01,27.234524,833850270123997830,5407760560782721986,0,1448,1465563717,306669,0,0);
     354INSERT INTO "iperf_packets" VALUES(56,1,26,2.75368559956550598135e+01,27.237318,6316594332143149512,-3379649244129461518,0,1448,1465563717,536855,0,0);
     355INSERT INTO "iperf_packets" VALUES(57,1,31,2.73191619813442230233e+01,27.247053,833850270123997830,5407760560782721986,0,1448,1465563717,319162,0,0);
     356INSERT INTO "iperf_packets" VALUES(58,1,27,2.75493479967117309574e+01,27.249799,6316594332143149512,-3379649244129461518,0,1448,1465563717,549348,0,0);
     357INSERT INTO "iperf_packets" VALUES(59,1,28,2.75526609718799591068e+01,27.253092,6316594332143149512,-3379649244129461518,0,1448,1465563717,552661,0,0);
     358INSERT INTO "iperf_packets" VALUES(60,1,32,2.7332742989063262939e+01,27.260631,833850270123997830,5407760560782721986,0,1448,1465563717,332742,0,0);
     359INSERT INTO "iperf_packets" VALUES(61,1,33,2.73364749848842620845e+01,27.264325,833850270123997830,5407760560782721986,0,1448,1465563717,336474,0,0);
     360INSERT INTO "iperf_packets" VALUES(62,1,29,2.75664999783039093021e+01,27.266971,6316594332143149512,-3379649244129461518,0,1448,1465563717,566500,0,0);
     361INSERT INTO "iperf_packets" VALUES(63,1,34,2.73424349725246429443e+01,27.270316,833850270123997830,5407760560782721986,0,1448,1465563717,342434,0,0);
     362INSERT INTO "iperf_packets" VALUES(64,1,30,2.75714859962463378897e+01,27.271912,6316594332143149512,-3379649244129461518,0,1448,1465563717,571486,0,0);
     363INSERT INTO "iperf_packets" VALUES(65,1,35,2.73485169708728790291e+01,27.276406,833850270123997830,5407760560782721986,0,1448,1465563717,348516,0,0);
     364INSERT INTO "iperf_packets" VALUES(66,1,36,2.73557319939136505131e+01,27.283595,833850270123997830,5407760560782721986,0,1448,1465563717,355732,0,0);
     365INSERT INTO "iperf_packets" VALUES(67,1,37,2.7359732985496520996e+01,27.287588,833850270123997830,5407760560782721986,0,1448,1465563717,359732,0,0);
     366INSERT INTO "iperf_packets" VALUES(68,1,38,2.7362471997737884521e+01,27.290334,833850270123997830,5407760560782721986,0,1448,1465563717,362472,0,0);
     367INSERT INTO "iperf_packets" VALUES(69,1,39,2.73658059835433959956e+01,27.293678,833850270123997830,5407760560782721986,0,1448,1465563717,365806,0,0);
     368INSERT INTO "iperf_packets" VALUES(70,1,40,2.73685259819030761723e+01,27.296373,833850270123997830,5407760560782721986,0,1448,1465563717,368526,0,0);
     369INSERT INTO "iperf_packets" VALUES(71,1,31,2.75975969731807708735e+01,27.298071,6316594332143149512,-3379649244129461518,0,1448,1465563717,597596,0,0);
     370INSERT INTO "iperf_packets" VALUES(72,1,41,2.73728769719600677494e+01,27.300766,833850270123997830,5407760560782721986,0,1448,1465563717,372877,0,0);
     371INSERT INTO "iperf_packets" VALUES(73,1,42,2.73773959875106811514e+01,27.30526,833850270123997830,5407760560782721986,0,1448,1465563717,377396,0,0);
     372INSERT INTO "iperf_packets" VALUES(74,1,32,2.76064039766788482666e+01,27.306857,6316594332143149512,-3379649244129461518,0,1448,1465563717,606404,0,0);
     373INSERT INTO "iperf_packets" VALUES(75,1,33,2.76088189780712127689e+01,27.309252,6316594332143149512,-3379649244129461518,0,1448,1465563717,608819,0,0);
     374INSERT INTO "iperf_packets" VALUES(76,1,43,2.73841219842433929447e+01,27.311999,833850270123997830,5407760560782721986,0,1448,1465563717,384121,0,0);
     375INSERT INTO "iperf_packets" VALUES(77,1,44,2.73980759978294372567e+01,27.325927,833850270123997830,5407760560782721986,0,1448,1465563717,398075,0,0);
     376INSERT INTO "iperf_packets" VALUES(78,1,34,2.76283019781112670898e+01,27.328771,6316594332143149512,-3379649244129461518,0,1448,1465563717,628301,0,0);
     377INSERT INTO "iperf_packets" VALUES(79,1,35,2.76343299746513366694e+01,27.334762,6316594332143149512,-3379649244129461518,0,1448,1465563717,634329,0,0);
     378INSERT INTO "iperf_packets" VALUES(80,1,45,2.74092519879341125479e+01,27.337108,833850270123997830,5407760560782721986,0,1448,1465563717,409252,0,0);
     379INSERT INTO "iperf_packets" VALUES(81,1,46,2.74122899770736694335e+01,27.340154,833850270123997830,5407760560782721986,0,1448,1465563717,412289,0,0);
     380INSERT INTO "iperf_packets" VALUES(82,1,47,2.74163129925727844238e+01,27.344198,833850270123997830,5407760560782721986,0,1448,1465563717,416313,0,0);
     381INSERT INTO "iperf_packets" VALUES(83,1,36,2.76459549963474273672e+01,27.346393,6316594332143149512,-3379649244129461518,0,1448,1465563717,645954,0,0);
     382INSERT INTO "iperf_packets" VALUES(84,1,37,2.76492909789085388187e+01,27.349738,6316594332143149512,-3379649244129461518,0,1448,1465563717,649291,0,0);
     383INSERT INTO "iperf_packets" VALUES(85,1,38,2.76508679986000061035e+01,27.351334,6316594332143149512,-3379649244129461518,0,1448,1465563717,650867,0,0);
     384INSERT INTO "iperf_packets" VALUES(86,1,48,2.74262009859085083003e+01,27.354081,833850270123997830,5407760560782721986,0,1448,1465563717,426200,0,0);
     385INSERT INTO "iperf_packets" VALUES(87,1,39,2.76552699804306030269e+01,27.355728,6316594332143149512,-3379649244129461518,0,1448,1465563717,655270,0,0);
     386INSERT INTO "iperf_packets" VALUES(88,1,49,2.74305329918861389164e+01,27.358375,833850270123997830,5407760560782721986,0,1448,1465563717,430532,0,0);
     387INSERT INTO "iperf_packets" VALUES(89,1,50,2.74327899813652038569e+01,27.360669,833850270123997830,5407760560782721986,0,1448,1465563717,432789,0,0);
     388INSERT INTO "iperf_packets" VALUES(90,1,51,2.74354999959468841557e+01,27.363366,833850270123997830,5407760560782721986,0,1448,1465563717,435499,0,0);
     389INSERT INTO "iperf_packets" VALUES(91,1,40,2.76658499836921691885e+01,27.366311,6316594332143149512,-3379649244129461518,0,1448,1465563717,665850,0,0);
     390INSERT INTO "iperf_packets" VALUES(92,1,52,2.74399949908256530757e+01,27.367858,833850270123997830,5407760560782721986,0,1448,1465563717,439995,0,0);
     391INSERT INTO "iperf_packets" VALUES(93,1,53,2.74415679872035980215e+01,27.369455,833850270123997830,5407760560782721986,0,1448,1465563717,441567,0,0);
     392INSERT INTO "iperf_packets" VALUES(94,1,41,2.76707469820976257332e+01,27.371205,6316594332143149512,-3379649244129461518,0,1448,1465563717,670747,0,0);
     393INSERT INTO "iperf_packets" VALUES(95,1,54,2.7444892972707748413e+01,27.37275,833850270123997830,5407760560782721986,0,1448,1465563717,444892,0,0);
     394INSERT INTO "iperf_packets" VALUES(96,1,42,2.76744509935379028324e+01,27.374897,6316594332143149512,-3379649244129461518,0,1448,1465563717,674451,0,0);
     395INSERT INTO "iperf_packets" VALUES(97,1,43,2.76842949986457824711e+01,27.384732,6316594332143149512,-3379649244129461518,0,1448,1465563717,684294,0,0);
     396INSERT INTO "iperf_packets" VALUES(98,1,55,2.7458460986614227294e+01,27.38633,833850270123997830,5407760560782721986,0,1448,1465563717,458460,0,0);
     397INSERT INTO "iperf_packets" VALUES(99,1,56,2.74606869816780090336e+01,27.388574,833850270123997830,5407760560782721986,0,1448,1465563717,460687,0,0);
     398INSERT INTO "iperf_packets" VALUES(100,1,57,2.74623179733753204341e+01,27.390173,833850270123997830,5407760560782721986,0,1448,1465563717,462318,0,0);
     399INSERT INTO "iperf_packets" VALUES(101,1,44,2.76913589835166931143e+01,27.39182,6316594332143149512,-3379649244129461518,0,1448,1465563717,691358,0,0);
     400INSERT INTO "iperf_packets" VALUES(102,1,45,2.76991709768772125248e+01,27.399608,6316594332143149512,-3379649244129461518,0,1448,1465563717,699170,0,0);
     401INSERT INTO "iperf_packets" VALUES(103,1,58,2.74762489795684814461e+01,27.404101,833850270123997830,5407760560782721986,0,1448,1465563717,476248,0,0);
     402INSERT INTO "iperf_packets" VALUES(104,1,59,2.74778169989585876456e+01,27.405698,833850270123997830,5407760560782721986,0,1448,1465563717,477817,0,0);
     403INSERT INTO "iperf_packets" VALUES(105,1,46,2.77068369984626770028e+01,27.407295,6316594332143149512,-3379649244129461518,0,1448,1465563717,706837,0,0);
     404INSERT INTO "iperf_packets" VALUES(106,1,47,2.7708469986915588378e+01,27.408892,6316594332143149512,-3379649244129461518,0,1448,1465563717,708470,0,0);
     405INSERT INTO "iperf_packets" VALUES(107,1,48,2.7711692988872528077e+01,27.412138,6316594332143149512,-3379649244129461518,0,1448,1465563717,711693,0,0);
     406INSERT INTO "iperf_packets" VALUES(108,1,49,2.77151619791984558114e+01,27.415632,6316594332143149512,-3379649244129461518,0,1448,1465563717,715161,0,0);
     407INSERT INTO "iperf_packets" VALUES(109,1,50,2.77192729711532592773e+01,27.419725,6316594332143149512,-3379649244129461518,0,1448,1465563717,719273,0,0);
     408INSERT INTO "iperf_packets" VALUES(110,1,60,2.74941549897193908695e+01,27.422021,833850270123997830,5407760560782721986,0,1448,1465563717,494154,0,0);
     409INSERT INTO "iperf_packets" VALUES(111,1,51,2.77231529951095581046e+01,27.423618,6316594332143149512,-3379649244129461518,0,1448,1465563717,723152,0,0);
     410INSERT INTO "iperf_packets" VALUES(112,1,52,2.77262769937515258784e+01,27.426714,6316594332143149512,-3379649244129461518,0,1448,1465563717,726277,0,0);
     411INSERT INTO "iperf_packets" VALUES(113,1,61,2.75004429817199707035e+01,27.428311,833850270123997830,5407760560782721986,0,1448,1465563717,500443,0,0);
     412INSERT INTO "iperf_packets" VALUES(114,1,62,2.75071209967136383052e+01,27.435002,833850270123997830,5407760560782721986,0,1448,1465563717,507121,0,0);
     413INSERT INTO "iperf_packets" VALUES(115,1,63,2.75126679837703704825e+01,27.440542,833850270123997830,5407760560782721986,0,1448,1465563717,512667,0,0);
     414INSERT INTO "iperf_packets" VALUES(116,1,64,2.75153489708900451655e+01,27.443238,833850270123997830,5407760560782721986,0,1448,1465563717,515348,0,0);
     415INSERT INTO "iperf_packets" VALUES(117,1,53,2.77448879778385162344e+01,27.445334,6316594332143149512,-3379649244129461518,0,1448,1465563717,744888,0,0);
     416INSERT INTO "iperf_packets" VALUES(118,1,54,2.77464599907398223876e+01,27.446882,6316594332143149512,-3379649244129461518,0,1448,1465563717,746460,0,0);
     417INSERT INTO "iperf_packets" VALUES(119,1,55,2.77491109967231750496e+01,27.449577,6316594332143149512,-3379649244129461518,0,1448,1465563717,749111,0,0);
     418INSERT INTO "iperf_packets" VALUES(120,1,56,2.77506829798221588134e+01,27.451124,6316594332143149512,-3379649244129461518,0,1448,1465563717,750683,0,0);
     419INSERT INTO "iperf_packets" VALUES(121,1,65,2.75248299837112426753e+01,27.452672,833850270123997830,5407760560782721986,0,1448,1465563717,524829,0,0);
     420INSERT INTO "iperf_packets" VALUES(122,1,66,2.75265199840068817147e+01,27.45437,833850270123997830,5407760560782721986,0,1448,1465563717,526520,0,0);
     421INSERT INTO "iperf_packets" VALUES(123,1,67,2.75280939936637878426e+01,27.455966,833850270123997830,5407760560782721986,0,1448,1465563717,528094,0,0);
     422INSERT INTO "iperf_packets" VALUES(124,1,68,2.75297059714794158926e+01,27.457564,833850270123997830,5407760560782721986,0,1448,1465563717,529706,0,0);
     423INSERT INTO "iperf_packets" VALUES(125,1,57,2.77585989832878112784e+01,27.459061,6316594332143149512,-3379649244129461518,0,1448,1465563717,758598,0,0);
     424INSERT INTO "iperf_packets" VALUES(126,1,58,2.77620269954204559317e+01,27.462457,6316594332143149512,-3379649244129461518,0,1448,1465563717,762027,0,0);
     425INSERT INTO "iperf_packets" VALUES(127,2,1,2.79324299991130828866e+01,27.463056,-4638133553200985154,-5067046478646040380,0,131072,1465563717,932425,0,2080508432);
     426INSERT INTO "iperf_packets" VALUES(128,1,69,2.75409869849681854248e+01,27.468846,833850270123997830,5407760560782721986,0,1448,1465563717,540987,0,0);
     427INSERT INTO "iperf_packets" VALUES(129,1,59,2.7770003974437713623e+01,27.470444,6316594332143149512,-3379649244129461518,0,1448,1465563717,770004,0,0);
     428INSERT INTO "iperf_packets" VALUES(130,1,70,2.75465309917926788325e+01,27.474388,833850270123997830,5407760560782721986,0,1448,1465563717,546530,0,0);
     429INSERT INTO "iperf_packets" VALUES(131,1,71,2.75481229722499847416e+01,27.475984,833850270123997830,5407760560782721986,0,1448,1465563717,548122,0,0);
     430INSERT INTO "iperf_packets" VALUES(132,1,60,2.7777680993080139161e+01,27.478132,6316594332143149512,-3379649244129461518,0,1448,1465563717,777680,0,0);
     431INSERT INTO "iperf_packets" VALUES(133,1,72,2.75548079907894134517e+01,27.482675,833850270123997830,5407760560782721986,0,1448,1465563717,554808,0,0);
     432INSERT INTO "iperf_packets" VALUES(134,1,61,27.78603297472,27.486468,6316594332143149512,-3379649244129461518,0,1448,1465563717,786033,0,0);
     433INSERT INTO "iperf_packets" VALUES(135,1,62,2.77882039844989776606e+01,27.488663,6316594332143149512,-3379649244129461518,0,1448,1465563717,788204,0,0);
     434INSERT INTO "iperf_packets" VALUES(136,1,63,2.77905159890651702885e+01,27.490961,6316594332143149512,-3379649244129461518,0,1448,1465563717,790516,0,0);
     435INSERT INTO "iperf_packets" VALUES(137,1,64,2.77954309880733489994e+01,27.495853,6316594332143149512,-3379649244129461518,0,1448,1465563717,795431,0,0);
     436}}}
     437