Transaction, incrementing and MySQL UPDATE

0 like 0 dislike
7 views
Whether is in MySQL the operation of the increment in the UPDATE transaction-safe? Possible race condition when several clients simultaneously execute a query like "UPDATE mytable SET myfield=myfield+1 WHERE id=myid"? If a thousand clients at the same time will perform the query on the line with a base value of 0, whether the end value is equal to one thousand?

Talking about InnoDB.
by | 7 views

6 Answers

0 like 0 dislike
In InnoDB row locks should not be Achtung.
by
0 like 0 dislike
Yes, will be equal to exactly 1000 at the end. regardless of the engine. In different engines this is achieved in different ways. Namprimer in innodb blokirovki a specific record. In Myisam lock the whole table for a short time.
by
0 like 0 dislike
Don't see any reason to say "no". Otherwise just defeats the purpose of a relational DBMS.
by
0 like 0 dislike
The record given by you, it is absolutely safe transaction. The line is blocked, changed, rasplachivaetsya.
by
0 like 0 dislike
View principle of operation update.
The record is locked, then update is performed and then you can only work with this record. In principle, because of this, some articles on optimizing and reducing load on the server, it is recommended not to use often update
by
0 like 0 dislike
Not the fact that the value will be 1000, especially given the fact that InnoDB is used MVCC is Given by the simultaneous implementation of 1000 queries, each of them will increase the value from zero to one.
by

Related questions

0 like 0 dislike
1 answer
Question about mysql transaction?
asked Apr 9, 2019 by vetsmen
0 like 0 dislike
3 answers
What happens with mysql transaction in case of early termination of the script?
asked Apr 1, 2019 by olegmar
0 like 0 dislike
2 answers
Not running the distributed transaction in PHP + MySQL?
asked Mar 25, 2019 by nord_ua
0 like 0 dislike
1 answer
The lock if a transaction in mysql, how it works?
asked Mar 20, 2019 by Bonch
0 like 0 dislike
1 answer
How to disable incrementing?
asked Jun 14, 2019 by Artem0071

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
32,728 users