📄 limits.so
字号:
m4_comment([$Id: limits.so,v 10.38 2004/08/18 19:57:37 bostic Exp $])m4_ref_title(Transaction Subsystem, Transaction limits, @transaction limits, txn/config, sequence/intro)m4_section([Transaction IDs])m4_p([dnlTransactions are identified by 31-bit unsigned integers, which meansthere are just over two billion unique transaction IDs. When a databaseenvironment is initially created or recovery is run, the transaction IDname space is reset, and new transactions are numbered starting from0x80000000 (2,147,483,648). The IDs will wrap if the maximumtransaction ID is reached, starting again from 0x80000000. The mostrecently allocated transaction ID is the m4_arg(st_last_txnid) value inthe transaction statistics information, and can be displayed by them4_ref(db_stat) utility.])m4_section([Cursors])m4_p([dnlWhen using transactions, cursors are localized to a single transaction.That is, a cursor may not span transactions, and must be opened andclosed within a single transaction. In addition, interminglingtransaction-protected cursor operations and non-transaction-protectedcursor operations on the same database in a single thread of control ispractically guaranteed to deadlock because the locks obtained fortransactions and non-transactions can conflict.])m4_section([Multiple Threads of Control])m4_p([dnlBecause transactions must hold all their locks until commit, a singletransaction may accumulate a large number of long-term locks during itslifetime. As a result, when two concurrently running transactionsaccess the same database, there is strong potential for conflict.Although m4_db allows an application to have multiple outstandingtransactions active within a single thread of control, great care mustbe taken to ensure that the transactions do not block each other (forexample, attempt to obtain conflicting locks on the same data). If twoconcurrently active transactions in the same thread of control doencounter a lock conflict, the thread of control will deadlock so thatthe deadlock detector cannot detect the problem. In this case, thereis no true deadlock, but because the transaction on which a transactionis waiting is in the same thread of control, no forward progress can bemade.])m4_page_footer
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -