[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:

  • Substantial improvements in throughput for LltMixed on long lived writes.
  • Improvements in general for MixedWorkloadsGenny for writes.
  • Improvement for ParallelInsertReplica(DelayMixed) with high numbers of threads
  • Improvement on Ycsb60Gb for 100% reads
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.

Generated at Thu Feb 08 06:02:00 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.