select dolt_version(). Make sure the version matches the latest as seen on the GitHub releases page.
PATHwith the downloaded one. Running the install process on most platforms again will do this for you. Restart the Dolt server using
dolt sql-serverto have your running server start using the latest binary.
DEBUG. This can be done by starting the server like so
dolt sql-server --loglevel=DEBUGor by setting
log_level: DEBUGin your
EXPLAINoperation in order for you to see the plan for complex queries. Rearranging your query to perform fewer
JOINs or make better use of indexes can help speed up complex queries.
dolt gc. Once the operation is complete, restart your server using
mergeand 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.