Before migrating from MySQL 5.7 to 8.0 I had created automated benchmarking framework which proved to give us repeatable results. It is based on sysbench and we perform set of runs with different threads from 16 to 256 with the step of 16, using OLTP Read Write workload and Percona’s TPCC-like one. I may write the other time a bit more on all the details and the process we are using, but in the context of this post the most important thing to know is that we can rely on its results and between different runs with the same conditions we were achieving less than 0.7% difference (averaged across runs for all threads, in terms of transactions per second).
Continue reading “Significant performance regression since MySQL 8.0.30 (up to 8.2.0 so far)”Tag: benchmarking
NVMes write back vs. write through performance
Recently I was running some benchmarks to double-check that the performance of AMD EPYCs servers delivered by Company A, match the performance of those delivered by Company B. I was using our benchmark automation tool (about which I may write a bit more in the future). It is currently based on sysbench to hammer MySQL instances. Surprisingly, the results have shown very significant difference: B servers were on average 83% slower…
Change is the only constant... 