session_track_system_variables

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS:

Track changes in registered system variables.

In 10.2 ES, 10.2 CS:

Track changes in registered system variables. For compatibility with MySQL defaults this variable should be set to "autocommit, character_set_client, character_set_connection, character_set_results, time_zone"

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

DETAILS

PARAMETERS

Command-line

--session_track_system_variables=arg

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

VARCHAR

Default Value

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

AWS

HA (Primary/Replica)

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

AWS

Transactional Standalone

10.4

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

AWS

Transactional Standalone

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

ColumnStore Multi

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

Galera

10.4

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

Galera

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

HA (Primary/Replica)

10.4

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

HA (Primary/Replica)

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

HTAP

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

Transactional Standalone

10.4

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

Transactional Standalone

10.5

autocommit,character_set_client,character_set_connection,character_set_results,time_zone

GCP

Distributed Transactions

10.5

Not present

See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Default value changed in MariaDB Community Server 10.3.1 from "" (empty) to

    autocommit,character_set_client,character_set_connection,character_set_results,time_zone

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.2.

EXTERNAL REFERENCES