New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support SKIP LOCKED and NOWAIT #1370

Open

beihai0xff opened this issue Nov 3, 2022 · 1 comment

Labels

beihai0xff commented Nov 3, 2022

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 added the enhancement label

Member

zachmu commented Nov 3, 2022

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment