VNS12 MySQL Performance

VNS12 MySQL Performance

VNS12 (192.168.195.91): 2vCPU + 2GBMem
MySQL1 (192.168.185.73): 2vCPU + 1GBMem
MySQL2 (192.168.185.75): 2vCPU + 1GBMem
Linuxclient (192.168.195.71): 2vCPU + 1GBMem

MySQL2 (192.168.185.75:3306) Performance:

[[email protected] ~]# Sysbench/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua--db-driver=mysql-- mysql-host=192.168.185.75--mysql-port=3306--mysql-user=sbtest--mysql-password=sbtest--mysql-db=sbtest-- Oltp-test-mode=complex--oltp-tables-count=10--oltp-table-size=100000--threads=10--time=120--report-interval=10 Runsysbench 1.0.9 (using System Luajit 2.0.4) Running the test with following options:number of Threads:10report Intermedi Ate results every second (s) Initializing random number generator from current timeinitializing worker threads ... Threads started! [10s] thds:10 tps:236.25 qps:4741.53 (r/w/o:3320.12/874.12/547.29) Lat (ms,95%): 71.83 err/s: 0.00 RECONN/S: 0.00[2 0s] thds:10 tps:195.21 qps:3897.73 (r/w/o:2728.99/715.12/453.62) Lat (ms,95%): 92.42 err/s: 0.00 RECONN/S: 0.00[30s ] Thds:10 tps:189.69 qps:3801.34 (r/w/o:2659.99/701.27/440.08) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[40s] Thds:10 tps:213.60 qps:4270.33 (r/w/o:2990.82/782.61/496.90) Lat (ms,95%): 92.42 err/s: 0.00 RECONN/S: 0.00[50s] thds:10 tps:189.61 qps:3787.75 (r/w/o:2651.10 /699.63/437.02) Lat (ms,95%): 121.08 err/s: 0.00 RECONN/S: 0.00[60s] thds:10 tps:195.50 qps:3914.50 (R/W/O:2739.60/7 19.60/455.30) Lat (ms,95%): 104.84 err/s: 0.00 RECONN/S: 0.00[70s] thds:10 tps:193.10 qps:3859.52 (r/w/o:2702.65/709 .89/446.99) Lat (ms,95%): 116.80 err/s: 0.00 RECONN/S: 0.00[80s] thds:10 tps:206.49 qps:4127.70 (r/w/o:2888.63/756.5 8/482.49) Lat (ms,95%): 94.10 err/s: 0.00 RECONN/S: 0.00[90s] thds:10 tps:192.61 qps:3858.12 (R/W/O:2700.69/711.62/4 45.81) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[100s] thds:10 tps:197.40 qps:3948.56 (r/w/o:2763.54/729.51/45 5.51) Lat (ms,95%): 112.67 err/s: 0.00 RECONN/S: 0.00[110s] thds:10 tps:198.00 qps:3961.06 (r/w/o:2772.27/726.89/461 ) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[120s] thds:10 tps:184.77 qps:3689.19 (r/w/o:2583.07/673.59/432. ) Lat (ms,95%): 144.97 ERR/S: 0.00 RECONN/S: 0.00SQL statistics:queries performed:read:335062 WRI                           te:88031 other:55567 Total:    478660 transactions:23933 (199.38 per sec.)    queries:478660 (3987.54 per sec.)    Ignored errors:0 (0.00 per Sec.) Reconnects:0 (0.00 per Sec.)  General Statistics:total time:120.0375s Total number of events:23933latency                                (ms): min:11.35 avg:50.14 Max:                            812.61 95th percentile:108.68 sum: 1200039.92Threads fairness:events (Avg/stddev): 2393.3000/56.73 Execution Time (Avg/stddev): 120 .0040/0.01 

Lb_vsrv_mysql_single (192.168.195.104:3306) Performance:
--MySQL2 (192.168.185.75:3306)

[[email protected] ~]# Sysbench/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua--db-driver=mysql-- mysql-host=192.168.195.104--mysql-port=3306--mysql-user=sbtest--mysql-password=sbtest--mysql-db=sbtest-- Oltp-test-mode=complex--oltp-tables-count=10--oltp-table-size=100000--threads=10--time=120--report-interval=10 Runsysbench 1.0.9 (using System Luajit 2.0.4) Running the test with following options:number of Threads:10report Intermedi Ate results every second (s) Initializing random number generator from current timeinitializing worker threads ... Threads started! [10s] thds:10 tps:208.75 qps:4183.88 (r/w/o:2929.96/760.03/493.89) Lat (ms,95%): 90.78 err/s: 0.00 RECONN/S: 0.00[2  0s] thds:10 tps:179.61 qps:3594.66 (r/w/o:2517.01/659.33/418.32) Lat (ms,95%): 121.08 err/s: 0.00 RECONN/S: 0.00[30s  ] Thds:10 tps:158.00 qps:3161.02 (r/w/o:2212.91/579.50/368.60) Lat (ms,95%): 153.02 err/s: 0.00 RECONN/S: 0.00[40s] Thds:10 tps:166.00 qps:3310.43 (r/w/o:2314.85/601.49/394.09) Lat (ms,95%): 150.29 err/s: 0.00 RECONN/S: 0.00[50s] thds:10 tps:157.76 qps:3165.90 (r/w/o:2217 .01/580.17/368.72) Lat (ms,95%): 150.29 err/s: 0.00 RECONN/S: 0.00[60s] thds:10 tps:178.44 qps:3568.67 (r/w/o:2498.4 4/655.54/414.69) Lat (ms,95%): 134.90 err/s: 0.00 RECONN/S: 0.00[70s] thds:10 tps:180.69 qps:3605.49 (r/w/o:2523.45/ 662.76/419.28) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[80s] thds:10 tps:181.51 qps:3644.28 (r/w/o:2551.09/66 8.45/424.73) Lat (ms,95%): 121.08 err/s: 0.00 RECONN/S: 0.00[90s] thds:10 tps:191.48 qps:3820.55 (r/w/o:2675.66/701. 54/443.36) Lat (ms,95%): 94.10 err/s: 0.00 RECONN/S: 0.00[100s] thds:10 tps:180.70 qps:3617.37 (r/w/o:2531.75/662.61 /423.01) Lat (ms,95%): 123.28 err/s: 0.00 RECONN/S: 0.00[110s] thds:10 tps:190.42 qps:3804.70 (r/w/o:2663.41/697.25/ 444.04) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[120s] thds:10 tps:198.60 qps:3971.28 (R/W/O:2778.99/732.90/4 59.40) Lat (ms,95%): 102. ERR/S: 0.00 RECONN/S: 0.00SQL statistics:queries performed:read:304220                           write:79642 other:50738 Total:    434600 transactions:21730 (181.01 per sec.)    queries:434600 (3620.29 per sec.)    Ignored errors:0 (0.00 per Sec.) Reconnects:0 (0.00 per Sec.)  General Statistics:total time:120.0444s Total number of events:21730latency                                (ms): min:16.45 avg:55.23 Max:                            939.91 95th percentile:121.08 sum: 1200142.16Threads fairness:events (Avg/stddev): 2173.0000/16.17 Execution Time (Avg/stddev): 120 .0142/0.02 

Lb_vsrv_mysql_write (192.168.195.105:3306) Performance:
--MySQL1 (192.168.185.73:3306)
--MySQL2 (192.168.185.75:3306)

[[email protected] ~]# Sysbench/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua--db-driver=mysql-- mysql-host=192.168.195.105--mysql-port=3306--mysql-user=sbtest--mysql-password=sbtest--mysql-db=sbtest-- Oltp-test-mode=complex--oltp-tables-count=10--oltp-table-size=100000--threads=10--time=120--report-interval=10 Runsysbench 1.0.9 (using System Luajit 2.0.4) Running the test with following options:number of Threads:10report Intermedi Ate results every second (s) Initializing random number generator from current timeinitializing worker threads ... Threads started! [10s] thds:10 tps:254.64 qps:5111.88 (r/w/o:3579.02/921.80/611.07) Lat (ms,95%): 82.96 err/s: 0.00 RECONN/S: 0.00[2  0s] thds:10 tps:221.20 qps:4420.38 (r/w/o:3094.79/797.00/528.60) Lat (ms,95%): 123.28 err/s: 0.00 RECONN/S: 0.00[30s  ] Thds:10 tps:187.19 qps:3734.54 (r/w/o:2613.49/678.47/442.58) Lat (ms,95%): 139.85 err/s: 0.00 RECONN/S: 0.00[40s] Thds:10 tps:121.40 qps:2431.02 (r/w/o:1701.74/440.39/288.89) Lat (ms,95%): 257.95 err/s: 0.00 RECONN/S: 0.00[50s] thds:10 tps:208.20 qps:4163.85 (r/w/o:2915 .77/749.69/498.39) Lat (ms,95%): 127.81 err/s: 0.00 RECONN/S: 0.00[60s] thds:10 tps:216.92 qps:4347.94 (r/w/o:3042.9 1/784.48/520.55) Lat (ms,95%): 110.66 err/s: 0.00 RECONN/S: 0.00[70s] thds:10 tps:222.41 qps:4448.05 (r/w/o:3113.61/ 809.63/524.82) Lat (ms,95%): 99.33 err/s: 0.00 RECONN/S: 0.00[80s] thds:10 tps:229.38 qps:4577.85 (r/w/o:3204.46/831 .34/542.06) Lat (ms,95%): 104.84 err/s: 0.00 RECONN/S: 0.00[90s] thds:10 tps:200.98 qps:4021.04 (r/w/o:2815.18/729.0 2/476.85) Lat (ms,95%): 132.49 err/s: 0.00 RECONN/S: 0.00[100s] thds:10 tps:214.83 qps:4296.27 (r/w/o:3006.10/781.00 /509.17) Lat (ms,95%): 123.28 err/s: 0.00 RECONN/S: 0.00[110s] thds:10 tps:212.91 qps:4263.62 (r/w/o:2987.08/775.52/ 501.01) Lat (ms,95%): 114.72 err/s: 0.00 RECONN/S: 0.00[120s] thds:10 tps:206.59 qps:4126.78 (R/W/O:2887.44/750.96/4 88.37) Lat (ms,95%): 97.ERR/S: 0.00 RECONN/S: 0.00SQL statistics:queries performed:read:349678 W                           rite:90526 other:59336 Total:    499540 transactions:24977 (208.05 per sec.)    queries:499540 (4160.97 per sec.)    Ignored errors:0 (0.00 per Sec.) Reconnects:0 (0.00 per Sec.)  General Statistics:total time:120.0524s Total number of events:24977latency                               (ms): min:12.48 avg:48.05 Max:                            1509.04 95th percentile:118.92 sum: 1200217.54Threads fairness:events (Avg/stddev): 2497.7000/10.93 Execution Time (Avg/stddev): 120 .0218/0.01 

VNS12 MySQL Performance