== WiSHFUL Tutorial: !WiFi QoS Management == [[TOC(Tutorials/c0WiFi*)]] [[Include(Documentation/Short/Prereq)]] === About This Experiment === In 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). === Experiment Script === The OMF experiment script [attachment:wishful_edca.rb 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,node1-2 -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=" -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= }}} 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); }}}