This has results for IO-bound sysbench with InnoDB and MySQL
versions 5.0, 5.1, 5.5, 5.6, 5.7 and 8.0. The results here don't
always match the results from in-memory sysbench. One source of variance is
the differing performance of the SSDs used on the i3 and i5
There are four types of tests: write-heavy, scan-heavy, point-query and inlist-query. Performance within each group is usually similar. Reading the summary below the results for modern InnoDB are mostly an improvement. This is good news because these tests are limited to low-concurrency and the many improvements in modern InnoDB don't help here.
tl;dr - performance for InnoDB in 8.0.3 compared to 5.0.96
- Full index scans were faster on the i5 NUC and both slower & faster on the i3 NUC. Shorter scans from read-write and …