Merged PRs
dolt
- 7880: Migrate
dolt remoteto SQL
Fixes: #7622 - 7879: avoid
NewEmptyIndexwhen table does not exist
It would be better to have NewEmptyIndex not write to chunkstore, but I'm not sure if it's possible right now.
Workaround is to just avoid calling it altogether in this particular case.
Closed Issues
- 7622: Migrate
dolt remoteto SQL
Performance
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 2.07 | 3.02 | 1.5 |
| groupby_scan | 13.22 | 17.32 | 1.3 |
| index_join | 1.34 | 5.18 | 3.9 |
| index_join_scan | 1.27 | 2.18 | 1.7 |
| index_scan | 35.59 | 53.85 | 1.5 |
| oltp_point_select | 0.17 | 0.51 | 3.0 |
| oltp_read_only | 3.36 | 8.28 | 2.5 |
| select_random_points | 0.33 | 0.8 | 2.4 |
| select_random_ranges | 0.39 | 0.95 | 2.4 |
| table_scan | 35.59 | 55.82 | 1.6 |
| types_table_scan | 75.82 | 137.35 | 1.8 |
| reads_mean_multiplier | 2.1 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| oltp_delete_insert | 7.98 | 6.67 | 0.8 |
| oltp_insert | 3.75 | 3.25 | 0.9 |
| oltp_read_write | 8.43 | 15.83 | 1.9 |
| oltp_update_index | 3.82 | 3.49 | 0.9 |
| oltp_update_non_index | 3.82 | 3.43 | 0.9 |
| oltp_write_only | 5.37 | 7.56 | 1.4 |
| types_delete_insert | 7.7 | 7.56 | 1.0 |
| writes_mean_multiplier | 1.1 |
| TPC-C TPS Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| tpcc-scale-factor-1 | 101.66 | 22.89 | 4.4 |
| tpcc_tps_multiplier | 4.4 |
| Overall Mean Multiple | 2.53 |
|---|