当前位置:网站首页>Transaction concluded
Transaction concluded
2022-08-09 06:33:00 【The strongest disciple in history】
Four characteristics of transactions:
ACID
Atomicity: As the smallest execution unit, transactions are either all executed or not executed at all.
Consistency: The execution of a transaction causes the database to transition from one correct state to another.
Isolation: Transactions do not affect each other.
Durability: After a transaction is submitted correctly, its results will be stored in the database forever, even if there are other failures after the transaction is committed, the transaction results will be saved.
Transaction isolation level:
Read uncommit: Read uncommitted transaction data.(dirty read, non-repeatable read, phantom read)
read commit : Read the data of the committed transaction.(non-repeatable read, phantom read)
repeat read : The data read multiple times is the same.(phantom reading)
searial : Serialization, the execution of one thing by one thing.
边栏推荐
猜你喜欢
报错jinja2.exceptions.UndefinedError: ‘form‘ is undefined
INSTALL_RPATH and BUILD_RPATH problem in CMake
线程的6种状态
Unity Gobang Game Design and Simple AI (2)
db.sqlite3 has no "as Data Source" workaround
中英文说明书丨TRC 交替醇(Catalogue NumberA575760)
CalBioreagents超全Id 蛋白兔单克隆抗体,助力科研
Use baidu EasyDL intelligent bin
Inception V3 闭眼检测
sql problem solving statement to create a table
随机推荐
单例模式
[HNOI2002]营业额统计
C# 利用iTextSharp画PDF
TCP segment of a reassembled PDU
Altium designer软件常用最全封装库,包含原理图库、PCB库和3D模型库
代码目录结构
如何 认识与学习BASH
Search 1688 product interface by image (item_search_img-search 1688 product by image (Politao interface) code docking tutorial
Remember a nest.js route that matches all the path problems that follow
2022-08-08: Given an array arr, it represents the height of the missiles that will appear in order from morning to night.When the cannon shoots missiles, once the cannon is set to shoot at a certain h
Go lang1.18入门精炼教程——第一章:环境搭建
ZIP压缩包文件删除密码的方法
IQ Products CMV Brite Turbo试剂盒的原理
一道很简答但是没答对的SQL题
jdepend
[GO], arrays and slices
db.sqlite3 has no "as Data Source" workaround
思维方法 解决问题的能力
输入框最前面添加放大镜&&background-image和background-color冲突问题
mongo+ycsb性能测试及线程数分析