select dolt_version()
. Make sure the version matches the latest as seen on the GitHub releases page.PATH
with the downloaded one. Running the install process on most platforms again will do this for you. Restart the Dolt server using dolt sql-server
to have your running server start using the latest binary.DEBUG
. This can be done by starting the server like so dolt sql-server --loglevel=DEBUG
or by setting log_level: DEBUG
in your config.yaml
.EXPLAIN
operation in order for you to see the plan for complex queries. Rearranging your query to perform fewer JOIN
s or make better use of indexes can help speed up complex queries.dolt gc
. Once the operation is complete, restart your server using dolt sql-server
.JOIN
s.merge
and requires a global write lock to perform that merge. Dolt can easily become overwhelmed with too many writes. This is an issue we will be tackling in the back half of 2022 using row level locking and other common transactional database strategies.