彪悍的人生,niubility 参数 innodb

  • 时间:
  • 浏览:1
  • 来源:uu快3app赚钱_uu快3大小计划注册

0 (disabled)

Variable Type:

Default Value:

5.7.10-1:

Seconds

Version Info:

Seconds

Dynamic:

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

GLOBAL

官网链接

Dynamic:

本文转自 roidba 51CTO博客,原文链接:http://blog.51cto.com/roidba/1896257,如需转载请自行联系原作者

锻炼当事人的动手能力。

5.7.17-11 – Variable implemented

Feature ported from Percona Server 5.6

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.

GLOBAL

Config:

Units:

Version Specific Information

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

Feature re-implemented using socket timeouts

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.

Version Info:

YES

YES

INTEGER

Variable Type:

roidba 一直推崇看官方文档,当事人做实验测试,我希望原来可以成为一名合格的DBA。

Scope:

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.

Default Value:

variable kill_idle_transaction

外理开发写SQL不commit 疑问图片

System Variables

Config:

variable innodb_kill_idle_transaction

5.7.17-11:

5.7.17-11 – Variable is now an alias of kill_idle_transaction

INTEGER

Units:

YES

Scope:

0 (disabled)

YES