[SERVER-65156] Analyze performance runs with varying numbers of read/write tickets Created: 01/Apr/22 Updated: 20/Apr/22 Resolved: 20/Apr/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Daniel Gomez Ferro | Assignee: | Jordi Olivares Provencio |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Sprint: | Execution Team 2022-04-18, Execution Team 2022-05-02 |
| Participants: |
| Description |
|
Schedule performance runs in 3 node repl sets with varying numbers of read/write tickets, for instance 32, 64 and 256. Analyze results to find out any workloads that would benefit from more (or less) throttling. |
| Comments |
| Comment by Daniel Gomez Ferro [ 05/Apr/22 ] |
|
LltMixed has lots of failed queries, the benchmark might be counting them as completed queries. louis.williams said transactions timeout if they can't take a ticket under 5 ms, that would explain why so many timeout with a reduced number of tickets. |
| Comment by Jordi Olivares Provencio [ 05/Apr/22 ] |
|
And in the case of reducing tickets to 32, there are:
|
| Comment by Jordi Olivares Provencio [ 05/Apr/22 ] |
|
In general it seems that there is no reason to increase tickets by default to 256 as there's no workload that improves while there's a general regression in all of them |
| Comment by Jordi Olivares Provencio [ 05/Apr/22 ] |
|
SbLargeScale, and CrudWorkloadsMajority also benefit greatly from reduced number of tickets, leading to a substantial increase in throughput with 64 tickets. There's additionally a decrease in latency on ChangeStreamsLatency, and MixedWorkloadsGenny with writes in large number of threads. And a possible thgroughput increase in MixedWorkloads. |
| Comment by Daniel Gomez Ferro [ 05/Apr/22 ] |
|
ParallelInsertReplica and ParallelInsertReplicaDelayMixed show improvements with lower number of tickets. |