node-mysql vs node-mysql2 benchmark using https://github.com/TechEmpower/FrameworkBenchmarks/blob/master/nodejs/hello.js

gistfile1.txt

node-mysql2:

wrk git:master ❯ ./wrk -c 200 "http://localhost:8080/mysql?queries=1" -d60
Running 1m test @ Chttp://localhost:8080/mysql?queries=1
  2 threads and 200 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency    43.77ms   20.00ms 116.91ms   65.06%
    Req/Sec     3.00k     1.00k    4.00k    49.94%
  397508 requests in 1.00m, 69.67MB read
Requests/sec:   6624.97

wrk git:master ❯ ./wrk -c 200 "http://localhost:8080/mysql?queries=20" -d60
Running 1m test @ Chttp://localhost:8080/mysql?queries=20
  2 threads and 200 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency   472.75ms  233.92ms 820.73ms   64.93%
    Req/Sec     0.00      0.00     0.00    100.00%
  35621 requests in 1.00m, 26.79MB read
Requests/sec:    593.63
Transfer/sec:    457.09KB

node-mysql:

Transfer/sec:      1.16MB
wrk git:master ❯ ./wrk -c 200 "http://localhost:8080/mysql?queries=1" -d60
Running 1m test @ Chttp://localhost:8080/mysql?queries=1
  2 threads and 200 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency    88.52ms   42.11ms 210.81ms   67.63%
    Req/Sec     0.98k     0.99k    2.00k    51.32%
  199106 requests in 1.00m, 34.90MB read
Requests/sec:   3318.34
Transfer/sec:    595.53KB

wrk git:master ❯ ./wrk -c 200 "http://localhost:8080/mysql?queries=20" -d60
Running 1m test @ Chttp://localhost:8080/mysql?queries=20
  2 threads and 200 connections
  Thread Stats   Avg      Stdev     Max   +/- Stdev
    Latency     1.41s   710.28ms   2.25s    75.13%
    Req/Sec     0.00      0.00     0.00    100.00%
  13523 requests in 1.00m, 10.17MB read
  Socket errors: connect 0, read 0, write 0, timeout 66
Requests/sec:    225.33
Transfer/sec:    173.50KB
wrk git:master ❯