编程知识 cdmana.com

How much do you know about database transactions? Linux operation and maintenance database learning

  MySQL Database learning , There will always be problems , In the face of problems , We usually think for ourselves 、 solve , When you can't answer it yourself , Turn to others . It's a good habit , Have the ability of self-study , There is also an attitude of asking for advice . So if you have a friend, you ask , What is a database transaction , What are the characteristics of transactions ?
   What is a database transaction ?
  ACID It's a logical set of operations , The units that make up this operation , Or all of them will succeed , Or all of them fail , This feature is transaction .
   What are the characteristics of transactions ?
   Atomicity (atomicity): All operations in the whole transaction , Or it's all done , Or not at all
   Uniformity (consistency): Things must always keep the system in a consistent state , No matter how many concurrent things there are at any given time .
   Isolation, (isolation): When multiple transactions simultaneously access the same data source , The database is able to keep each transaction accessed isolated , They don't influence each other .
   Persistence (durability): It's writing disks .
   Most of the databases used by Internet enterprises are MySQL Of , Want lots of them IT Stand out among the workers , You need to have advanced technology , Learning to add value is essential . Way of learning , It's about persistence .

版权声明
本文为[laonanhai123]所创,转载请带上原文链接,感谢
https://cdmana.com/2020/12/20201224114549512A.html

Scroll to Top