CODEWITHSUNDEEP
mysqlsqlmariadb
Abdallah Sakre
Abdallah Sakre

Reputation: 915

Row locking in Maria database

I have a row in a Maria DB table that will be updated (incremented) many times by different users at the same exact time, and I don't want to miss any update. Is "row locking" enabled by default for all Maria/Mysql databases, or a configuration is needed?

Upvotes: 0

Views: 45

Answers (1)

Rick James
Rick James

Reputation: 142296

It works correctly. Period. No configuration needed; none available in InnoDB.

What is this, a Like counter or Views counter? I recommend moving such out of the main table. This is because the rapid-fire updates will make it difficult to get to the main columns. And vice versa. (Please provide more details to discuss further.)

Upvotes: 1

Related Questions