python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - isolation-level

Serializable and Row-based locking in MySQL

I'm trying to convert a database from MsSQL to MySQL. How exactly should the transaction configuration be done in MySQL for the Serializable isolation level that exists in MsSQL? Because MsSQL keyword...
test-img

Pınar Seçkin

mysql

database

isolation-level

rowlocking

Votes: 0

Answers: 1

Latest Answer

did you start a transaction after set isolation level? it will set transaction level only for the next transaction. you could set it for all session via "SET SESSION TRANSACTION ISOLATION LEVEL S...
test-img

Bart

Do we need to add any configuration on client side to avoid transaction retry errors in cockroach database

when there is concurrent updates happening on the same record, transaction 1 is able to update but as per the cockroach database documentation transaction t2 should be on queue, but transaction t2 is ...
test-img

DK93

spring-boot

spring-data-jpa

isolation-level

cockroachdb

Votes: 0

Answers: 2

Latest Answer

Yes, the client should handle transaction retry errors. Note that whenever possible, CockroachDB will auto-retry a transaction internally without notifying the client. CockroachDB will only send a ser...
test-img

Michael Butler CRDB

Posts

Questions

Blogs

Jobs