search

dolthub / dolt

Dolt – Git for Data
Apache License 2.0
17.36k stars 488 forks source link

[no-release-notes] need stats to run on dolt servers #8055

Closed max-hoffman closed 1 week ago

max-hoffman commented 1 week ago

It looks like sysbench and tpcc are not using stats since the recent change for doltgres. If the server name is a full specified path, I think this version will permit dolt but disable doltgres/mysql stats.

coffeegoddd commented 1 week ago

@max-hoffman DOLT

comparing_percentages
100.000000 to 100.000000
version result total
f2e33d4 ok 5937457
version total_tests
f2e33d4 5937457
correctness_percentage
100.0
max-hoffman commented 1 week ago

benchmark

max-hoffman commented 1 week ago

benchmark

github-actions[bot] commented 1 week ago

@max-hoffman workflow run: https://github.com/dolthub/dolt/actions/runs/9651083663

coffeegoddd commented 1 week ago
@max-hoffman DOLT test_name from_latency_p95 to_latency_p95 is_faster
tpcc-scale-factor-1 80.03 75.82 0
test_name server_name server_version tps test_name server_name server_version tps is_faster
tpcc-scale-factor-1 dolt 07ddfecf3e1e3cb249f7b6531d54957e6bcd0bd9 32.16 tpcc-scale-factor-1 dolt f2e33d489b3a60a97198486a7aa26828891ed267 32.88 0
coffeegoddd commented 1 week ago
@max-hoffman DOLT read_tests from_latency_median to_latency_median is_faster
covering_index_scan 2.86 2.86 0
groupby_scan 17.63 17.63 0
index_join 5.37 5.37 0
index_join_scan 2.57 2.61 0
index_scan 54.83 54.83 0
oltp_point_select 0.46 0.46 0
oltp_read_only 7.7 7.7 0
select_random_points 0.77 0.77 0
select_random_ranges 0.92 0.94 0
table_scan 56.84 56.84 0
types_table_scan 147.61 144.97 0
write_tests from_latency_median to_latency_median is_faster
oltp_delete_insert 6.21 6.21 0
oltp_insert 3.07 3.07 0
oltp_read_write 14.21 14.21 0
oltp_update_index 3.13 3.13 0
oltp_update_non_index 3.07 3.07 0
oltp_write_only 6.43 6.55 0
types_delete_insert 6.79 6.79 0