6.6.1.2.2. MySQL + Galera + HAproxy performance report¶
This scenario is executed with Sysbench tool. There is one instance of tool per tester node, each running in N threads. Galera cluster is located behind HAproxy. Tester tools all point to HAProxy endpoint.
6.6.1.2.2.1. Throughput¶
The following chart shows the number of queries, read queries and transactions depending on total thread count.
| threads | queries per sec | read queries per sec | transactions per sec |
|---|---|---|---|
| 20 | 49331.4 | 32887.6 | 2349.1 |
| 40 | 56479.8 | 37653.2 | 2689.5 |
| 60 | 56265.1 | 37510.2 | 2679.2 |
| 80 | 58458.7 | 38972.5 | 2783.7 |
| 120 | 55108.4 | 36739.3 | 2624.1 |
| 160 | 17298.6 | 11532.5 | 823.7 |
| 200 | 11732.2 | 7821.8 | 558.5 |
6.6.1.2.2.2. Throughput and server CPU consumption¶
The following chart shows how DB server CPU consumption depends on number of concurrent threads and throughput.
| threads | queries per sec | CPU, % |
|---|---|---|
| 20 | 49331.4 | 917.4 |
| 40 | 56479.8 | 1115.2 |
| 60 | 56265.1 | 1073.0 |
| 80 | 58458.7 | 1153.9 |
| 120 | 55108.4 | 1178.3 |
| 160 | 17298.6 | 2050.1 |
| 200 | 11732.2 | 2058.9 |
6.6.1.2.2.3. Operation latency¶
The following chart shows how operation latency depends on number of concurrent threads.
| threads | min latency, ms | avg latency, ms | max latency, ms |
|---|---|---|---|
| 20 | 4.8 | 8.5 | 23.3 |
| 40 | 6.1 | 14.9 | 27.2 |
| 60 | 5.4 | 22.4 | 64.8 |
| 80 | 7.3 | 28.7 | 78.6 |
| 120 | 9.4 | 45.7 | 113.8 |
| 160 | 13.4 | 194.5 | 1069.3 |
| 200 | 14.9 | 358.9 | 4071.6 |