6.6.1.2.1. MySQL + Galera performance report¶
This scenario is executed with Sysbench tool. There is one instance of tool per tester node, each running in N threads. The tool is configured to point to one of DB nodes in Galera cluster directly.
6.6.1.2.1.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 | 69112.8 | 46075.2 | 3291.1 |
| 40 | 74157.2 | 49438.2 | 3531.3 |
| 60 | 67909.4 | 45273.0 | 3233.8 |
| 80 | 65218.1 | 43478.9 | 3105.6 |
| 120 | 58895.1 | 39263.7 | 2804.4 |
| 160 | 57187.0 | 38125.3 | 2723.0 |
| 200 | 51120.9 | 34081.6 | 2434.0 |
6.6.1.2.1.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 | 69112.8 | 1247.3 |
| 40 | 74157.2 | 1942.5 |
| 60 | 67909.4 | 2302.5 |
| 80 | 65218.1 | 2414.2 |
| 120 | 58895.1 | 2423.0 |
| 160 | 57187.0 | 2421.0 |
| 200 | 51120.9 | 2326.0 |
6.6.1.2.1.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 | 3.2 | 6.1 | 19.6 |
| 40 | 3.5 | 11.4 | 42.9 |
| 60 | 4.3 | 18.7 | 56.5 |
| 80 | 4.1 | 25.9 | 155.9 |
| 120 | 4.3 | 42.8 | 572.9 |
| 160 | 5.2 | 58.8 | 485.3 |
| 200 | 6.6 | 82.2 | 745.9 |