Merged PRs
dolt
- 5206: adding new codec for spatial indexes
go-mysql-server
- 1557: make the length of logged queries configurable and default to non-tru…
…ncated - 1556: fix multiple column partition
fix for: #5209 - 1555: Fix dolt panic when dealing with top-most left join
When moving join conditions to filter, update top join even if a join is left or degenerate.
Fixes #5136 - 1553: Merge join inclusion correctness
Merge join was not principled selecting 1) monotonic filters and 2) sorting indexes that aligned with the filter of choice. We also failed to push filters referencing a single table out of join conditions.
Closed Issues
- 5175: High load in 1) SELECT queries when we have 7000 rows and 21000 branches 2) create extra branches when we've already have 21000
- 5136: Dolt panic during multiple JOINs
- 5209: Window function only respects first PARTITION column
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.96 | 2.71 | 1.4 |
groupby_scan | 12.3 | 16.41 | 1.3 |
index_join | 1.16 | 4.57 | 3.9 |
index_join_scan | 1.12 | 3.89 | 3.5 |
index_scan | 30.26 | 52.89 | 1.7 |
oltp_point_select | 0.15 | 0.48 | 3.2 |
oltp_read_only | 2.97 | 8.58 | 2.9 |
select_random_points | 0.3 | 0.75 | 2.5 |
select_random_ranges | 0.35 | 1.14 | 3.3 |
table_scan | 30.81 | 62.19 | 2.0 |
types_table_scan | 69.29 | 186.54 | 2.7 |
reads_mean_multiplier | 2.6 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 2.91 | 12.98 | 4.5 |
oltp_insert | 1.42 | 3.13 | 2.2 |
oltp_read_write | 5.18 | 18.28 | 3.5 |
oltp_update_index | 1.47 | 5.99 | 4.1 |
oltp_update_non_index | 1.44 | 6.55 | 4.5 |
oltp_write_only | 2.3 | 9.39 | 4.1 |
types_delete_insert | 3.07 | 12.3 | 4.0 |
writes_mean_multiplier | 3.5 |
Overall Mean Multiple | 3.0 |
---|