search

dolthub / go-mysql-server

A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
Apache License 2.0
2.37k stars 211 forks source link

Support SKIP LOCKED and NOWAIT #1370

Open beihai0xff opened 2 years ago

beihai0xff commented 2 years ago

Since MySQL 8.0.1 introduces two new features SKIP LOCKED and NOWAIT to handle hot rows Locking (FOR UPDATE), could go-mysql-server support this?

The MySQL doc: MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

zachmu commented 2 years ago

We can support parsing these constructs in the short term, but the built-in in-memory database implementation is currently not even thread safe.

We're a long way from having row-level locking.