Merged PRs
dolt
- 8155: Bug fix: loading persisted
@@server_id
from config.json
This fixes binlog replicas loading@@server_id
values persisted in config.json so that they are properly converted from strings to the right type.
Also added extra connection error logging - 8153: make tags case insensitive
This PR makes it so tags are case-insensitive.
Additionally, fixes a display error in the sql shell.
fixes #8147 - 8152: Revive ability to read really old dolt_schema tables
We have several old databases which we don't touch but are public on DoltHub. These databases present an error to users with the removal of the migration ability in 1.42.0. The change will bring them back. - 8135: Build Archives more robustly
This change is long in coming. Several findings from building a large user database are incorporated here. Specifically:- No longer storing all chunks in memory
- Cancellable process with
^C
- Progress reporting for major stages of the build
- No chunk grouping by default,
--group-chunks
to enable. Pathological cgo dictionary building problem needs to be fixed before we enable by default. - Writing a useful metadata json block with dolt version and origin table file ID.
go-mysql-server
- 2605: add lock to prevent warnings from being cleared
This PR adds two functions to BaseSession that toggle a boolean, so integrators can prevent warnings from being cleared.
This is mostly useful fordolt sql shell
.
addresses #8016 - 2603: [memo] reorder should add new plans to intermediate expr join child
There was a bug where we'd add reordered join plans to project or distinct nodes, rather than their join children. Code comment explains more clearly how this works. - 2602: disallow forward slash in database name
fixes #8126 - 2600: Support information_schema.columns hook for doltgres
- 2593: custom row exec
Additions for custom row operators on Dolt side: #8072
Closed Issues
- 8147: Tag releases: database not found
Performance
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.07 | 2.97 | 1.4 |
groupby_scan | 13.46 | 17.01 | 1.3 |
index_join | 1.34 | 2.81 | 2.1 |
index_join_scan | 1.27 | 2.57 | 2.0 |
index_scan | 34.33 | 54.83 | 1.6 |
oltp_point_select | 0.18 | 0.45 | 2.5 |
oltp_read_only | 3.49 | 7.56 | 2.2 |
select_random_points | 0.34 | 0.75 | 2.2 |
select_random_ranges | 0.39 | 0.89 | 2.3 |
table_scan | 34.95 | 55.82 | 1.6 |
types_table_scan | 75.82 | 142.39 | 1.9 |
reads_mean_multiplier | 1.9 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
oltp_delete_insert | 8.13 | 6.09 | 0.7 |
oltp_insert | 3.82 | 3.02 | 0.8 |
oltp_read_write | 8.58 | 13.95 | 1.6 |
oltp_update_index | 3.89 | 3.07 | 0.8 |
oltp_update_non_index | 3.89 | 3.02 | 0.8 |
oltp_write_only | 5.47 | 6.32 | 1.2 |
types_delete_insert | 7.7 | 6.67 | 0.9 |
writes_mean_multiplier | 1.0 |
TPC-C TPS Tests | MySQL | Dolt | Multiple |
---|---|---|---|
tpcc-scale-factor-1 | 99.27 | 34.31 | 2.9 |
tpcc_tps_multiplier | 2.9 |
Overall Mean Multiple | 1.93 |
---|