interactive_timeout

The number of seconds the server waits for activity on an interactive connection before closing it

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

USAGE

The interactive_timeout system variable can have its default value configured via SkySQL Configuration Manager.

DETAILS

The interactive_timeout system variable sets the time in seconds that the server waits for an idle interactive connection to become active before closing it.

  • An interactive client is one that sets the CLIENT_INTERACTIVE option when it connects to the server with mysql_real_connect().

  • Some clients may be considered interactive clients when executed with some options, and non-interactive clients when executed with other options.

PARAMETERS

Dynamic

Yes

Scope

Global, Session

Data Type

BIGINT UNSIGNED

Minimum Value

1

Maximum Value

31536000

Default Value

28800

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

3600 (choices: 300, 600, 3600, 28800, 86400)

AWS

HA (Primary/Replica)

10.5

3600 (choices: 300, 600, 3600, 28800, 86400)

AWS

Transactional Standalone

10.4

3600 (choices: 300, 600, 3600, 28800, 86400)

AWS

Transactional Standalone

10.5

3600 (choices: 300, 600, 3600, 28800, 86400)

AWS

Distributed Transactions

10.5

28800 (choices: 300, 600, 3600, 28800, 86400)

GCP

ColumnStore

10.5

28800 (choices: 300, 600, 3600, 28800, 86400)

GCP

ColumnStore Multi

10.5

28800 (choices: 300, 600, 3600, 28800, 86400)

GCP

Galera

10.4

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

Galera

10.5

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

HA (Primary/Replica)

10.4

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

HA (Primary/Replica)

10.5

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

HTAP

10.5

28800 (choices: 300, 600, 3600, 28800, 86400)

GCP

Transactional Standalone

10.4

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

Transactional Standalone

10.5

3600 (choices: 300, 600, 3600, 28800, 86400)

GCP

Distributed Transactions

10.5

28800 (choices: 300, 600, 3600, 28800, 86400)

PRIVILEGES

The interactive_timeout system variable requires the SUPER privilege to dynamically set its global value at runtime.

The interactive_timeout system variable does not require any special privilege to dynamically set its session value at runtime.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES