Merged PRs
dolt
- 5186: Fixed an error when running table funcs on a read replica
This fixes #5184 - 5181: Add from commit index
Adds adolt_diff.from_commit
index.
The biggest assumption made here is if we are givenfrom_commit
and are looking for its highestto_commit
that referencesfrom
as a child, we can make an optimization for the case where there is only one commit inHEAD
's closure atfrom.height+1
. If there is more than one commit at height+1, that indicates a branching in the graph whose merge back toHEAD
can referencefrom
at a higher level of the tree. In the default case, or when parent isHEAD
, we fall back to a reverse commit iterator that terminates as soon as we find a commit referencingfrom
. This maintains backwards compatibility for the tests I've added.
go-mysql-server
- 1546: add
information_schema.parameters
table
Addedinformation_schema.parameters
table.
Removinggrant option
privileges being granted incorrectly ingrant all
statement. - 1538: implement
st_intersects
MySQL Reference: https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html#function_st-intersects - 1536: adding spatial index checks
Closed Issues
- 5184: dolt_diff_summary doesn't work on a read replica
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.93 | 2.71 | 1.4 |
groupby_scan | 12.3 | 16.41 | 1.3 |
index_join | 1.21 | 4.65 | 3.8 |
index_join_scan | 1.14 | 4.03 | 3.5 |
index_scan | 30.26 | 53.85 | 1.8 |
oltp_point_select | 0.15 | 0.49 | 3.3 |
oltp_read_only | 3.02 | 8.58 | 2.8 |
select_random_points | 0.3 | 0.75 | 2.5 |
select_random_ranges | 0.35 | 1.14 | 3.3 |
table_scan | 30.81 | 63.32 | 2.1 |
types_table_scan | 69.29 | 189.93 | 2.7 |
reads_mean_multiplier | 2.6 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 2.66 | 17.01 | 6.4 |
oltp_insert | 1.34 | 3.68 | 2.7 |
oltp_read_write | 5.0 | 26.2 | 5.2 |
oltp_update_index | 1.39 | 7.3 | 5.3 |
oltp_update_non_index | 1.39 | 8.13 | 5.8 |
oltp_write_only | 2.18 | 15.27 | 7.0 |
types_delete_insert | 2.71 | 17.01 | 6.3 |
writes_mean_multiplier | 5.0 |
Overall Mean Multiple | 3.6 |
---|