Transaction, incrementing and MySQL UPDATE

Question

Transaction, incrementing and MySQL UPDATE

Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274

6 Answers

Related questions

OdobenusRosmarus · Answer 1 · 2019-03-22T09:23:43+0000

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.

pentarh · Answer 2 · 2019-03-22T09:23:43+0000

Don't see any reason to say "no". Otherwise just defeats the purpose of a relational DBMS.

artoodetoo · Answer 3 · 2019-03-22T09:23:43+0000

The record given by you, it is absolutely safe transaction. The line is blocked, changed, rasplachivaetsya.

pentarh · Answer 4 · 2019-03-22T09:23:43+0000

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

pentarh · Answer 5 · 2019-03-22T09:23:43+0000

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.

Transaction, incrementing and MySQL UPDATE

Please log in or register to add a comment.

Please log in or register to answer this question.

6 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags