溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

彪悍的人生，niubility 參數(shù) innodb_kill_idle_transaction

發(fā)布時(shí)間：2020-08-03 00:16:21 來(lái)源：網(wǎng)絡(luò) 閱讀：1536 作者：roidba 欄目：數(shù)據(jù)庫(kù)


roidba 一直推崇看官方文檔，自己做實(shí)驗(yàn)測(cè)試，只要這樣才能成為一名合格的DBA。

鍛煉自己的動(dòng)手能力。

Kill Idle Transactions (mariadb &percona server 支持)

解決開(kāi)發(fā)寫SQL不commit 問(wèn)題

This feature limits the age of idle transactions, for all transactional storage engines. If a transaction is idle for more seconds than the threshold specified, it will be killed. This prevents users from blocking InnoDB purge by mistake.

In Percona Server 5.7.17-11 this feature has been re-implemented by setting a connection socket read timeout value instead of periodically scanning the internal InnoDB transaction list.

Version Specific Information

5.7.10-1:

Feature ported from Percona Server 5.6

5.7.17-11:

Feature re-implemented using socket timeouts

System Variables

variable innodb_kill_idle_transaction

Version Info:

5.7.17-11 – Variable is now an alias of kill_idle_transaction

Scope:

GLOBAL

Config:

YES

Dynamic:

YES

Variable Type:

INTEGER

Default Value:

0 (disabled)

Units:

Seconds

To enable this feature, set this variable to the desired seconds wait until the transaction is killed. NOTE: This variable has been deprecated and it will be removed in a future major release.

variable kill_idle_transaction

Version Info:

5.7.17-11 – Variable implemented

Scope:

GLOBAL

Config:

YES

Dynamic:

YES

Variable Type:

INTEGER

Default Value:

0 (disabled)

Units:

Seconds

If non-zero, any idle transaction will be killed after being idle for this many seconds.


官網(wǎng)鏈接

https://www.percona.com/doc/percona-server/LATEST/management/innodb_kill_idle_trx.html

向AI問(wèn)一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手