mysqlpool

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] (mean) Time per request: 82.804 [ms] (mean) Time per request: 1.656 [ms] (mean, across all concurrent requests) 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] (mean) Time per request: 85.078 [ms] (mean) Time per request: 1.702 [ms] (mean, across all concurrent requests) 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.