mysql-pool
A pool of connections for mysql, using round robin
BenchMarks
With mysql-pool
This is ApacheBench, Version 2.3 <$Revision: 655654 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking 192.168.1.3 (be patient) Completed 1000 requests Completed 2000 requests Completed 3000 requests Completed 4000 requests Completed 5000 requests Completed 6000 requests Completed 7000 requests Completed 8000 requests Completed 9000 requests Completed 10000 requests Finished 10000 requests
Server Software:
Server Hostname: 192.168.1.3
Server Port: 1337
Document Path: / Document Length: 0 bytes
Concurrency Level: 50 Time taken for tests: 16.561 seconds Complete requests: 10000 Failed requests: 0 Write errors: 0 Total transferred: 640000 bytes HTML transferred: 0 bytes Requests per second: 603.83 #/sec Time per request: 82.804 ms Time per request: 1.656 ms Transfer rate: 37.74 [Kbytes/sec] received
Connection Times (ms) min mean[+/-sd] median max Connect: 3 33 73.2 28 1064 Processing: 19 49 12.3 47 128 Waiting: 19 49 12.3 47 126 Total: 39 82 75.1 76 1144
Percentage of the requests served within a certain time (ms) 50% 76 66% 82 75% 88 80% 91 90% 99 95% 106 98% 116 99% 127 100% 1144 (longest request)
Without mysql-pool
This is ApacheBench, Version 2.3 <$Revision: 655654 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking 192.168.1.3 (be patient) Completed 1000 requests Completed 2000 requests Completed 3000 requests Completed 4000 requests Completed 5000 requests Completed 6000 requests Completed 7000 requests Completed 8000 requests Completed 9000 requests Completed 10000 requests Finished 10000 requests
Server Software:
Server Hostname: 192.168.1.3
Server Port: 1338
Document Path: / Document Length: 0 bytes
Concurrency Level: 50 Time taken for tests: 17.016 seconds Complete requests: 10000 Failed requests: 0 Write errors: 0 Total transferred: 640000 bytes HTML transferred: 0 bytes Requests per second: 587.69 #/sec Time per request: 85.078 ms Time per request: 1.702 ms Transfer rate: 36.73 [Kbytes/sec] received
Connection Times (ms) min mean[+/-sd] median max Connect: 3 32 77.7 25 1123 Processing: 16 53 19.0 48 153 Waiting: 16 52 19.0 48 153 Total: 38 85 80.6 74 1203
Percentage of the requests served within a certain time (ms) 50% 74 66% 84 75% 92 80% 97 90% 111 95% 126 98% 140 99% 159 100% 1203 (longest request)
The benchmarks were run using 'ab' and with concurrency set to 50, with ab on one machine and mysql and nodejs code on another on the same WLAN.