mycat1.4 amoeba3.0.5 mysql直连对照_mysql

同样jvm的配置，下面是amoeba跑的数据，还是用前面sysbench的脚本跑的

 java_OPTS=”-server -Xms2G -Xmx2G -XX:MaxPermSize=64M  -XX:+AggressiveOpts -XX:MaxDirectMemorySize=2G”

amoeba的最大288左右

[  10s] threads: 8, tps: 117.70, reads: 1651.79, writes: 0.00, response time: 185.06ms (99%), errors: 0.00, reconnects:  0.00 [  20s] threads: 8, tps: 203.90, reads: 2855.99, writes: 0.00, response time: 84.70ms (99%), errors: 0.00, reconnects:  0.00 [  30s] threads: 8, tps: 201.00, reads: 2810.05, writes: 0.00, response time: 125.55ms (99%), errors: 0.00, reconnects:  0.00 [  40s] threads: 8, tps: 275.00, reads: 3854.10, writes: 0.00, response time: 57.07ms (99%), errors: 0.00, reconnects:  0.00 [  50s] threads: 8, tps: 280.60, reads: 3928.23, writes: 0.00, response time: 53.82ms (99%), errors: 0.00, reconnects:  0.00 [  60s] threads: 8, tps: 219.70, reads: 3077.09, writes: 0.00, response time: 77.68ms (99%), errors: 0.00, reconnects:  0.00 [  70s] threads: 8, tps: 276.49, reads: 3869.91, writes: 0.00, response time: 55.04ms (99%), errors: 0.00, reconnects:  0.00 [  80s] threads: 8, tps: 274.99, reads: 3848.90, writes: 0.00, response time: 66.38ms (99%), errors: 0.00, reconnects:  0.00 [  90s] threads: 8, tps: 223.93, reads: 3135.48, writes: 0.00, response time: 226.02ms (99%), errors: 0.00, reconnects:  0.00 [ 100s] threads: 8, tps: 286.00, reads: 4003.86, writes: 0.00, response time: 50.12ms (99%), errors: 0.00, reconnects:  0.00 [ 110s] threads: 8, tps: 276.40, reads: 3870.35, writes: 0.00, response time: 55.85ms (99%), errors: 0.00, reconnects:  0.00 [ 120s] threads: 8, tps: 233.90, reads: 3274.09, writes: 0.00, response time: 82.17ms (99%), errors: 0.00, reconnects:  0.00 [ 130s] threads: 8, tps: 275.70, reads: 3859.10, writes: 0.00, response time: 62.58ms (99%), errors: 0.00, reconnects:  0.00 [ 140s] threads: 8, tps: 270.30, reads: 3786.58, writes: 0.00, response time: 62.51ms (99%), errors: 0.00, reconnects:  0.00 [ 150s] threads: 8, tps: 216.30, reads: 3026.08, writes: 0.00, response time: 366.19ms (99%), errors: 0.00, reconnects:  0.00 [ 160s] threads: 8, tps: 270.90, reads: 3792.93, writes: 0.00, response time: 55.40ms (99%), errors: 0.00, reconnects:  0.00 [ 170s] threads: 8, tps: 265.50, reads: 3716.41, writes: 0.00, response time: 61.69ms (99%), errors: 0.00, reconnects:  0.00 [ 180s] threads: 8, tps: 220.49, reads: 3087.72, writes: 0.00, response time: 251.51ms (99%), errors: 0.00, reconnects:  0.00 [ 190s] threads: 8, tps: 274.31, reads: 3838.39, writes: 0.00, response time: 49.67ms (99%), errors: 0.00, reconnects:  0.00 [ 200s] threads: 8, tps: 233.90, reads: 3277.58, writes: 0.00, response time: 94.82ms (99%), errors: 0.00, reconnects:  0.00 [ 210s] threads: 8, tps: 215.10, reads: 3012.12, writes: 0.00, response time: 163.54ms (99%), errors: 0.00, reconnects:  0.00 [ 220s] threads: 8, tps: 284.70, reads: 3983.51, writes: 0.00, response time: 46.91ms (99%), errors: 0.00, reconnects:  0.00 [ 230s] threads: 8, tps: 268.90, reads: 3765.80, writes: 0.00, response time: 64.58ms (99%), errors: 0.00, reconnects:  0.00 [ 240s] threads: 8, tps: 196.40, reads: 2748.50, writes: 0.00, response time: 97.73ms (99%), errors: 0.00, reconnects:  0.00 [ 250s] threads: 8, tps: 288.20, reads: 4034.90, writes: 0.00, response time: 46.53ms (99%), errors: 0.00, reconnects:  0.00

相同的参数、相同的机器，相同的数据mycat1.4的数据，最大540左右

[  10s] threads: 8, tps: 373.08, reads: 5229.56, writes: 0.00, response time: 76.09ms (99%), errors: 0.00, reconnects:  0.00 [  20s] threads: 8, tps: 521.21, reads: 7295.49, writes: 0.00, response time: 33.23ms (99%), errors: 0.00, reconnects:  0.00 [  30s] threads: 8, tps: 522.20, reads: 7311.06, writes: 0.00, response time: 22.13ms (99%), errors: 0.00, reconnects:  0.00 [  40s] threads: 8, tps: 533.90, reads: 7474.16, writes: 0.00, response time: 21.75ms (99%), errors: 0.00, reconnects:  0.00 [  50s] threads: 8, tps: 537.10, reads: 7520.18, writes: 0.00, response time: 20.72ms (99%), errors: 0.00, reconnects:  0.00 [  60s] threads: 8, tps: 536.70, reads: 7512.71, writes: 0.00, response time: 22.24ms (99%), errors: 0.00, reconnects:  0.00 [  70s] threads: 8, tps: 536.60, reads: 7512.65, writes: 0.00, response time: 24.08ms (99%), errors: 0.00, reconnects:  0.00 [  80s] threads: 8, tps: 552.80, reads: 7738.95, writes: 0.00, response time: 18.92ms (99%), errors: 0.00, reconnects:  0.00 [  90s] threads: 8, tps: 495.30, reads: 6933.28, writes: 0.00, response time: 35.77ms (99%), errors: 0.00, reconnects:  0.00 [ 100s] threads: 8, tps: 540.20, reads: 7564.04, writes: 0.00, response time: 20.20ms (99%), errors: 0.00, reconnects:  0.00 [ 110s] threads: 8, tps: 534.80, reads: 7486.15, writes: 0.00, response time: 21.14ms (99%), errors: 0.00, reconnects:  0.00 [ 120s] threads: 8, tps: 537.20, reads: 7523.19, writes: 0.00, response time: 20.94ms (99%), errors: 0.00, reconnects:  0.00 [ 130s] threads: 8, tps: 523.30, reads: 7326.45, writes: 0.00, response time: 32.93ms (99%), errors: 0.00, reconnects:  0.00 [ 140s] threads: 8, tps: 537.50, reads: 7521.30, writes: 0.00, response time: 20.05ms (99%), errors: 0.00, reconnects:  0.00 [ 150s] threads: 8, tps: 522.70, reads: 7321.09, writes: 0.00, response time: 20.67ms (99%), errors: 0.00, reconnects:  0.00 [ 160s] threads: 8, tps: 538.50, reads: 7539.27, writes: 0.00, response time: 20.66ms (99%), errors: 0.00, reconnects:  0.00 [ 170s] threads: 8, tps: 533.70, reads: 7470.62, writes: 0.00, response time: 20.48ms (99%), errors: 0.00, reconnects:  0.00 [ 180s] threads: 8, tps: 562.70, reads: 7878.92, writes: 0.00, response time: 18.70ms (99%), errors: 0.00, reconnects:  0.00 [ 190s] threads: 8, tps: 535.90, reads: 7501.03, writes: 0.00, response time: 21.79ms (99%), errors: 0.00, reconnects:  0.00 [ 200s] threads: 8, tps: 548.60, reads: 7679.83, writes: 0.00, response time: 19.44ms (99%), errors: 0.00, reconnects:  0.00 [ 210s] threads: 8, tps: 509.00, reads: 7126.94, writes: 0.00, response time: 20.62ms (99%), errors: 0.00, reconnects:  0.00 [ 220s] threads: 8, tps: 533.99, reads: 7477.01, writes: 0.00, response time: 19.74ms (99%), errors: 0.00, reconnects:  0.00

 相同的参数、相同的机器，相同的数据，直连mysql的数据对比，最大750

[1640s] threads: 8, tps: 718.60, reads: 10060.20, writes: 0.00, response time: 19.05ms (99%), errors: 0.00, reconnects:  0.00 [1650s] threads: 8, tps: 721.20, reads: 10096.98, writes: 0.00, response time: 19.03ms (99%), errors: 0.00, reconnects:  0.00 [1660s] threads: 8, tps: 728.70, reads: 10201.62, writes: 0.00, response time: 18.51ms (99%), errors: 0.00, reconnects:  0.00 [1670s] threads: 8, tps: 734.20, reads: 10277.80, writes: 0.00, response time: 18.80ms (99%), errors: 0.00, reconnects:  0.00 [1680s] threads: 8, tps: 735.00, reads: 10288.80, writes: 0.00, response time: 19.09ms (99%), errors: 0.00, reconnects:  0.00 [1690s] threads: 8, tps: 750.40, reads: 10504.70, writes: 0.00, response time: 19.03ms (99%), errors: 0.00, reconnects:  0.00 [1700s] threads: 8, tps: 751.50, reads: 10521.80, writes: 0.00, response time: 18.47ms (99%), errors: 0.00, reconnects:  0.00 [1710s] threads: 8, tps: 747.20, reads: 10462.60, writes: 0.00, response time: 18.65ms (99%), errors: 0.00, reconnects:  0.00 [1720s] threads: 8, tps: 702.90, reads: 9840.97, writes: 0.00, response time: 25.00ms (99%), errors: 0.00, reconnects:  0.00 [1730s] threads: 8, tps: 683.90, reads: 9573.53, writes: 0.00, response time: 25.07ms (99%), errors: 0.00, reconnects:  0.00 [1740s] threads: 8, tps: 742.20, reads: 10391.49, writes: 0.00, response time: 18.68ms (99%), errors: 0.00, reconnects:  0.00 [1750s] threads: 8, tps: 687.10, reads: 9619.91, writes: 0.00, response time: 26.62ms (99%), errors: 0.00, reconnects:  0.00 [1760s] threads: 8, tps: 655.50, reads: 9174.40, writes: 0.00, response time: 26.43ms (99%), errors: 0.00, reconnects:  0.00 [1770s] threads: 8, tps: 715.20, reads: 10015.86, writes: 0.00, response time: 23.60ms (99%), errors: 0.00, reconnects:  0.00 [1780s] threads: 8, tps: 700.00, reads: 9798.94, writes: 0.00, response time: 24.37ms (99%), errors: 0.00, reconnects:  0.00 [1790s] threads: 8, tps: 680.90, reads: 9531.30, writes: 0.00, response time: 24.48ms (99%), errors: 0.00, reconnects:  0.00 [1800s] threads: 8, tps: 736.50, reads: 10313.80, writes: 0.00, response time: 18.94ms (99%), errors: 0.00, reconnects:  0.00 [1810s] threads: 8, tps: 698.60, reads: 9778.80, writes: 0.00, response time: 23.98ms (99%), errors: 0.00, reconnects:  0.00