Merged PRs
dolt
- 4431: Make NomsBinFormat
__DOLT__the default format - 4429: go: sqle: cluster: Add a dolt_cluster database, exposing a dolt_cluster_status table which queries replication status.
- 4426: Reference new socket interface functionality in README
- 4422: go/libraries/doltcore/sqle: Implement standby replication hook.
- 4318: implement
call dolt_conflicts_resolve()
Closes #2475
go-mysql-server
- 1296: server: context.go: Expose *SessionManager.KillConnection.
Closed Issues
- 2587: Can't add columns to a table with an AUTO_INCREMENT column that isn't primary key
- 2475:
dolt_conflicts_resolve()SQL procedure - 4176: Collation not respected properly by
LIKEandREGEXP_LIKE - 1144: Is it possible to run raw sql queries to mock the database?
Latency
Current Format (__DOLT__)
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.96 | 2.71 | 1.4 |
| groupby_scan | 12.52 | 17.01 | 1.4 |
| index_join | 1.21 | 4.41 | 3.6 |
| index_join_scan | 1.16 | 3.75 | 3.2 |
| index_scan | 30.26 | 51.94 | 1.7 |
| oltp_point_select | 0.15 | 0.48 | 3.2 |
| oltp_read_only | 2.97 | 8.43 | 2.8 |
| select_random_points | 0.3 | 0.73 | 2.4 |
| select_random_ranges | 0.35 | 1.12 | 3.2 |
| table_scan | 30.81 | 61.08 | 2.0 |
| types_table_scan | 69.29 | 179.94 | 2.6 |
| reads_mean_multiplier | 2.5 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 3.02 | 9.73 | 3.2 |
| oltp_insert | 1.58 | 2.76 | 1.7 |
| oltp_read_write | 5.28 | 16.71 | 3.2 |
| oltp_update_index | 1.55 | 4.41 | 2.8 |
| oltp_update_non_index | 1.52 | 4.65 | 3.1 |
| oltp_write_only | 2.39 | 7.98 | 3.3 |
| types_delete_insert | 2.97 | 11.87 | 4.0 |
| writes_mean_multiplier | 2.8 |
| Overall Mean Multiple | 2.6 |
|---|
Old Format (__LD_1__)
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 6.79 | 3.5 |
| groupby_scan | 12.3 | 22.69 | 1.8 |
| index_join | 1.21 | 16.71 | 13.8 |
| index_join_scan | 1.14 | 16.12 | 14.1 |
| index_scan | 30.81 | 70.55 | 2.3 |
| oltp_point_select | 0.15 | 0.58 | 3.9 |
| oltp_read_only | 2.97 | 9.91 | 3.3 |
| select_random_points | 0.3 | 1.39 | 4.6 |
| select_random_ranges | 0.35 | 1.39 | 4.0 |
| table_scan | 30.81 | 66.84 | 2.2 |
| types_table_scan | 70.55 | 211.6 | 3.0 |
| reads_mean_multiplier | 5.1 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 3.36 | 19.65 | 5.8 |
| oltp_insert | 1.79 | 8.13 | 4.5 |
| oltp_read_write | 5.28 | 37.56 | 7.1 |
| oltp_update_index | 1.79 | 9.39 | 5.2 |
| oltp_update_non_index | 1.73 | 6.55 | 3.8 |
| oltp_write_only | 2.52 | 26.68 | 10.6 |
| types_delete_insert | 3.62 | 155.8 | 43.0 |
| writes_mean_multiplier | 10.1 |
| Overall Mean Multiple | 7.2 |
|---|