dolthub / dolt

Dolt – Git for Data
Apache License 2.0
17.89k stars 507 forks source link

Continue to support writes when archives are in play #8140

Closed macneale4 closed 3 months ago

macneale4 commented 3 months ago

Error in hasMany effectively prevented writes after moving database to archives.

coffeegoddd commented 3 months ago

@macneale4 DOLT

comparing_percentages
100.000000 to 100.000000
version result total
546a6a6 ok 5937457
version total_tests
546a6a6 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.06 1.5
batching batch sql 10000 1 0.08 1.75
batching by line sql 10000 1 0.07 2.14
blob 1 blob 200000 1 0.88 3.93 3.77
blob 2 blobs 200000 1 0.86 4.52 4.45
blob no blob 200000 1 0.89 2.48 2.11
col type datetime 200000 1 0.8 3.06 2.86
col type varchar 200000 1 0.68 3.43 2.79
config width 2 cols 200000 1 0.78 2.55 2.18
config width 32 cols 200000 1 1.83 2.01 2.5
config width 8 cols 200000 1 0.93 2.49 2.27
pk type float 200000 1 0.82 2.45 2.1
pk type int 200000 1 0.81 2.48 2.06
pk type varchar 200000 1 1.47 1.79 1.46
row count 1.6mm 1600000 1 5.58 2.99 2.53
row count 400k 400000 1 1.42 2.87 2.39
row count 800k 800000 1 2.81 2.93 2.46
secondary index four index 200000 1 3.42 1.46 1.12
secondary index no secondary 200000 1 0.89 2.48 2.08
secondary index one index 200000 1 1.15 2.37 2.08
secondary index two index 200000 1 1.91 1.81 1.48
sorting shuffled 1mm 1000000 0 4.91 2.9 2.51
sorting sorted 1mm 1000000 1 4.95 2.88 2.5
github-actions[bot] commented 3 months ago
@coffeegoddd DOLT name detail mean_mult
dolt_blame_basic system table 1.32
dolt_blame_commit_filter system table 3.42
dolt_commit_ancestors_commit_filter system table 0.84
dolt_commits_commit_filter system table 0.89
dolt_diff_log_join_from_commit system table 2.11
dolt_diff_log_join_to_commit system table 2.09
dolt_diff_table_from_commit_filter system table 1.14
dolt_diff_table_to_commit_filter system table 1.12
dolt_diffs_commit_filter system table 1
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.35
adds_updates_deletes 60000 60000 60000 4.48
deletes_only 0 60000 0 2.43
updates_only 0 0 60000 3