Hello Cristian, Ben, On Thu, Oct 24, 2024 at 07:12:49PM +1100, Benjamin Herrenschmidt wrote: > On Sat, 2024-10-19 at 02:30 +0000, Prundeanu, Cristian wrote: > > > > The hammerdb test is a bit more complex than sysbench. It uses two > > independent physical machines to perform a TPC-C derived test [1], aiming > > to simulate a real-world database workload. The machines are allocated as > > an AWS EC2 instance pair on the same cluster placement group [2], to avoid > > measuring network bottlenecks instead of server performance. The SUT > > instance runs mysql configured to use 2 worker threads per vCPU (32 > > total); the load generator instance runs hammerdb configured with 64 > > virtual users and 24 warehouses [3]. Each test consists of multiple > > 20-minute rounds, run consecutively on multiple independent instance > > pairs. > > Would it be possible to produce something that Prateek and Gautham > (Hi Gautham btw !) can easily consume to reproduce ? > > Maybe a container image or a pair of container images hammering each > other ? (the simpler the better). Yes, that would be useful. Please share your recipe. We will try and reproduce it at our end. In our testing from a few months ago (some of which was presented at OSPM 2024), most of the database related regressions that we observed with EEVDF went away after running these the server threads under SCHED_BATCH. > > Cheers, > Ben. -- Thanks and Regards gautham.
|