Skip to content

Instantly share code, notes, and snippets.

@qix

qix/gist:8daf3affc16c92abcddb

Created April 1, 2015 18:20
Show Gist options
  • Save qix/8daf3affc16c92abcddb to your computer and use it in GitHub Desktop.
Save qix/8daf3affc16c92abcddb to your computer and use it in GitHub Desktop.
Download ZIP
Pipelined queries
Raw
gistfile1.js
#!/usr/bin/env node
'use strict';
var mysql = require('mysql2');
var connection = mysql.createConnection({ user: 'root', database: 'memsql'});
var request = 0;
setInterval(function() {
var thisRequest = 'Request #' + (request++);
console.time(thisRequest);
connection.query('SELECT 1', function(err, rows) {
console.timeEnd(thisRequest);
});
}, 10);
@qix
Copy link
Author

qix commented Apr 1, 2015 

$ docker exec 'tc qdisc add dev eth0 root netem delay 30ms'
$ node test.js
Request #0: 194ms
Request #1: 231ms
Request #2: 271ms
Request #3: 310ms
Request #4: 351ms
Request #5: 391ms
Request #6: 432ms
Request #7: 472ms
Request #8: 512ms
Request #9: 553ms
Request #10: 593ms
Request #11: 633ms
Request #12: 674ms
Request #13: 714ms
Request #14: 755ms
Request #15: 794ms
Request #16: 835ms
Request #17: 875ms
Request #18: 916ms
Request #19: 955ms
Request #20: 996ms

@qix
Copy link
Author

qix commented Apr 1, 2015 

$ docker exec dev-memsql 'tc qdisc del dev eth0 root netem'
$ node test.js 
Request #0: 3ms
Request #1: 1ms
Request #2: 0ms
Request #3: 1ms
Request #4: 0ms
Request #5: 1ms
Request #6: 1ms
Request #7: 0ms
Request #8: 0ms
Request #9: 1ms
Request #10: 0ms
Request #11: 0ms
Request #12: 1ms
Request #13: 0ms
Request #14: 1ms
Request #15: 0ms
Request #16: 0ms
Request #17: 1ms
Request #18: 0ms
Request #19: 0ms
Request #20: 0ms

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment