Merged PRs
dolt
- 9773: Make sure
dolt_testssystem table changes show up indolt diffby default
Addresses: #9771 - 9770: #9762 - Add fix for detached head err on dolt_log(tag)
Fixes #9762 - 9768: Replace Dolt CI testing references in AGENT.md with reference to
dolt_tests - 9757: Cache materialized commits on
doltdb
Changes:- store a cache of all resolved commit hashes on doltdb
This results in another ~2.3x speed up, so ~4.7x in total.
- store a cache of all resolved commit hashes on doltdb
Closed Issues
- 9743: dolt log is slow to respond without a small -n limit and no other params on a small database (7000 commits)
- 9771:
dolt_testssystem table does not show indolt diff - 9762: dolt_log is "not supported while in a detached head state"
Performance
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.86 | 0.67 | 0.36 |
| groupby_scan | 13.95 | 18.61 | 1.33 |
| index_join | 1.5 | 2.48 | 1.65 |
| index_join_scan | 1.47 | 1.39 | 0.95 |
| index_scan | 34.33 | 30.26 | 0.88 |
| oltp_point_select | 0.21 | 0.28 | 1.33 |
| oltp_read_only | 3.82 | 5.37 | 1.41 |
| select_random_points | 0.36 | 0.58 | 1.61 |
| select_random_ranges | 0.39 | 0.62 | 1.59 |
| table_scan | 34.95 | 32.53 | 0.93 |
| types_table_scan | 74.46 | 127.81 | 1.72 |
| reads_mean_multiplier | 1.25 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| oltp_delete_insert | 8.43 | 6.67 | 0.79 |
| oltp_insert | 4.18 | 3.25 | 0.78 |
| oltp_read_write | 9.22 | 11.87 | 1.29 |
| oltp_update_index | 4.25 | 3.3 | 0.78 |
| oltp_update_non_index | 4.25 | 3.25 | 0.76 |
| oltp_write_only | 5.28 | 6.55 | 1.24 |
| types_delete_insert | 8.58 | 7.04 | 0.82 |
| writes_mean_multiplier | 0.92 |
| TPC-C TPS Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| tpcc-scale-factor-1 | 93.73 | 39.61 | 2.37 |
| tpcc_tps_multiplier | 2.37 |
| Overall Mean Multiple | 1.51 |
|---|