Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created August 23, 2024 23:39
Show Gist options
  • Save mdcallag/094908b6d06643e173de92b44245fddd to your computer and use it in GitHub Desktop.
Save mdcallag/094908b6d06643e173de92b44245fddd to your computer and use it in GitHub Desktop.
12 clients, 8 tables, 10M rows per table, innodb_change_buffering=all, sysbench runs with --secondary
Relative to: x.ma100619_rel_withdbg.z11a2_c24r64.pk0
col-1 : x.ma1006_bbperfpkgtest.z11a2_c24r64.pk0
col-2 : x.ma1006_mdev34759.z11a2_c24r64.pk0
col-1 col-2
1.76 1.79 hot-points_range=100
0.99 1.00 point-query.pre_range=100
1.00 1.00 point-query_range=100
1.00 1.01 points-covered-pk.pre_range=100
1.00 1.01 points-covered-pk_range=100
1.00 1.01 points-covered-si.pre_range=100
1.00 1.00 points-covered-si_range=100
1.00 1.01 points-notcovered-pk.pre_range=100
1.00 1.01 points-notcovered-pk_range=100
1.01 1.01 points-notcovered-si.pre_range=100
1.00 1.01 points-notcovered-si_range=100
1.00 1.01 random-points.pre_range=10
1.00 1.01 random-points.pre_range=100
1.00 1.01 random-points.pre_range=1000
1.00 1.00 random-points_range=10
1.01 1.01 random-points_range=100
1.00 1.01 random-points_range=1000
0.97 1.00 range-covered-pk.pre_range=100
0.96 1.01 range-covered-pk_range=100
0.97 1.01 range-covered-si.pre_range=100
0.96 1.00 range-covered-si_range=100
0.99 1.00 range-notcovered-pk.pre_range=100
0.99 1.00 range-notcovered-pk_range=100
1.00 1.00 range-notcovered-si.pre_range=100
1.00 1.01 range-notcovered-si_range=100
0.99 1.00 read-only.pre_range=10
0.99 1.00 read-only.pre_range=100
0.99 1.00 read-only.pre_range=10000
1.00 1.00 read-only_range=10
0.99 1.00 read-only_range=100
0.98 1.00 read-only_range=10000
0.90 1.04 scan_range=100
0.99 1.00 delete_range=100
1.00 1.00 insert_range=100
1.04 1.00 read-write_range=10
1.02 1.01 read-write_range=100
1.09 0.98 update-index_range=100
1.00 1.02 update-inlist_range=100
1.00 1.00 update-nonindex_range=100
0.99 1.00 update-one_range=100
1.00 1.00 update-zipf_range=100
1.06 0.99 write-only_range=10000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment