1.43.19

Merged PRs

dolt

• 8612: go/store/nbs: Fixing GCGen to be more correct.
  The original purpose of gc gen was two fold. The first purpose was to avoid applying the garbage collection results if the store had changed due to multi-process concurrency for any reason. The second purpose was to fast-complete a dolt gc invocation if the store had not changed at all since the last GC run.
  For the first purpose, it is no longer necessary. We no longer allow multi-process access to the same NomsBlockStore.
  For the second purpose, it was implemented slightly incorrectly, given the introduction of dolt gc --full. This change fixes the implementation to be more correct.
  In particular, the semantics are:
  • After a dolt gc --full, an immediate invocation of dolt gc or dolt gc --full fast-completes as no collection being necessary.
  • After a dolt gc, only a dolt gc fast-completes as no collection being necessary. A dolt gc --full will run a full GC to completion.

go-mysql-server

• 2765: increase column size for information_schema.processlist.state
  The State column in our information_schema.processlist table is different than the MySQL implementation because we include progress information. As a result, it is possible to exceed the 64 character limit that the column is defined as.
  However, thius means deviating from MySQL's definition of the table.
• 2762: Add schema to StatsQualifier for schema databases

Closed Issues

• 8385: Permissions / branch control incorrect for branch-qualified database names

Performance

Read Tests	MySQL	Dolt	Multiple
covering_index_scan	2.11	0.62	0.3
groupby_scan	13.22	16.71	1.3
index_join	1.37	2.26	1.6
index_join_scan	1.27	1.44	1.1
index_scan	34.33	54.83	1.6
oltp_point_select	0.18	0.27	1.5
oltp_read_only	3.49	5.37	1.5
select_random_points	0.34	0.65	1.9
select_random_ranges	0.39	0.65	1.7
table_scan	34.95	55.82	1.6
types_table_scan	74.46	147.61	2.0
reads_mean_multiplier			1.5

Write Tests	MySQL	Dolt	Multiple
oltp_delete_insert	8.9	6.21	0.7
oltp_insert	4.1	3.07	0.7
oltp_read_write	9.06	11.65	1.3
oltp_update_index	4.18	3.13	0.7
oltp_update_non_index	4.18	3.07	0.7
oltp_write_only	5.67	6.21	1.1
types_delete_insert	8.43	6.55	0.8
writes_mean_multiplier			0.9

TPC-C TPS Tests	MySQL	Dolt	Multiple
tpcc-scale-factor-1	96.58	40.39	2.4
tpcc_tps_multiplier			2.4

Overall Mean Multiple	1.60