dolthub / dolt

Dolt – Git for Data
Apache License 2.0
17.81k stars 505 forks source link

Re-enable doltgres sysbench scripts #8080

Closed zachmu closed 3 months ago

github-actions[bot] commented 3 months ago

Additional work is required for integration with DoltgreSQL.

coffeegoddd commented 3 months ago

@zachmu DOLT

comparing_percentages
100.000000 to 100.000000
version result total
f849cbe ok 5937457
version total_tests
f849cbe 5937457
correctness_percentage
100.0
github-actions[bot] commented 3 months ago
@coffeegoddd DOLT test_name detail row_cnt sorted mysql_time sql_mult cli_mult
batching LOAD DATA 10000 1 0.05 1.8
batching batch sql 10000 1 0.08 1.75
batching by line sql 10000 1 0.07 2
blob 1 blob 200000 1 0.87 3.99 3.89
blob 2 blobs 200000 1 0.92 4.29 4.26
blob no blob 200000 1 0.88 2.51 2.11
col type datetime 200000 1 0.82 3.04 2.79
col type varchar 200000 1 0.68 3.44 2.81
config width 2 cols 200000 1 0.78 2.58 2.18
config width 32 cols 200000 1 1.87 1.99 2.48
config width 8 cols 200000 1 0.97 2.44 2.19
pk type float 200000 1 1.05 1.93 1.64
pk type int 200000 1 0.83 2.41 2.05
pk type varchar 200000 1 1.5 1.94 1.45
row count 1.6mm 1600000 1 5.48 3.05 2.6
row count 400k 400000 1 1.45 2.83 2.38
row count 800k 800000 1 2.79 2.99 2.53
secondary index four index 200000 1 3.58 1.35 1.06
secondary index no secondary 200000 1 0.87 2.54 2.17
secondary index one index 200000 1 1.12 2.47 2.14
secondary index two index 200000 1 1.96 1.76 1.48
sorting shuffled 1mm 1000000 0 4.95 2.9 2.55
sorting sorted 1mm 1000000 1 4.87 2.94 2.6
github-actions[bot] commented 3 months ago
@coffeegoddd DOLT name detail mean_mult
dolt_blame_basic system table 1.26
dolt_blame_commit_filter system table 3.4
dolt_commit_ancestors_commit_filter system table 0.89
dolt_commits_commit_filter system table 0.94
dolt_diff_log_join_from_commit system table 1.99
dolt_diff_log_join_to_commit system table 2.06
dolt_diff_table_from_commit_filter system table 1.16
dolt_diff_table_to_commit_filter system table 1.1
dolt_diffs_commit_filter system table 0.97
dolt_history_commit_filter system table 1.22
dolt_log_commit_filter system table 0.91
github-actions[bot] commented 3 months ago
@coffeegoddd DOLT name add_cnt delete_cnt update_cnt latency
adds_only 60000 0 0 1.37
adds_updates_deletes 60000 60000 60000 4.45
deletes_only 0 60000 0 2.42
updates_only 0 0 60000 3.03