当前位置: 代码迷 >> MySQL >> mycat1.4 amoeba3.0.5 mysql直连对照
  详细解决方案

mycat1.4 amoeba3.0.5 mysql直连对照

热度:159   发布时间:2016-05-05 16:38:51.0
mycat1.4 amoeba3.0.5 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

?

??

?

  相关解决方案