performance_schema_max_statement_classes

Maximum number of statement instruments.

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

--performance_schema_max_statement_classes=#

Configuration file

Supported

Dynamic

No

Scope

Global

Data Type

BIGINT UNSIGNED

Minimum Value

0

Maximum Value

256

Default Value

222

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

202 (choices: Autosized or 0)

AWS

HA (Primary/Replica)

10.5

222 (choices: Autosized or 0)

AWS

Transactional Standalone

10.4

202 (choices: Autosized or 0)

AWS

Transactional Standalone

10.5

222 (choices: Autosized or 0)

AWS

Distributed Transactions

10.5

Not present (choices: Autosized or 0)

GCP

ColumnStore

10.5

222 (choices: Autosized or 0)

GCP

ColumnStore Multi

10.5

222 (choices: Autosized or 0)

GCP

Galera

10.4

202 (choices: Autosized or 0)

GCP

Galera

10.5

222 (choices: Autosized or 0)

GCP

HA (Primary/Replica)

10.4

202 (choices: Autosized or 0)

GCP

HA (Primary/Replica)

10.5

222 (choices: Autosized or 0)

GCP

HTAP

10.5

222 (choices: Autosized or 0)

GCP

Transactional Standalone

10.4

202 (choices: Autosized or 0)

GCP

Transactional Standalone

10.5

222 (choices: Autosized or 0)

GCP

Distributed Transactions

10.5

Not present (choices: Autosized or 0)

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

  • Default value changed in MariaDB Enterprise Server 10.5.3-1 from 202 to 222

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

  • Default value changed in MariaDB Community Server 10.5.2 from 202 to 222

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.

  • Default value changed in MariaDB Community Server 10.4.1 from 200 to 201

  • Default value changed in MariaDB Community Server 10.4.2 from 201 to 202

10.3 Enterprise

  • Default value changed in MariaDB Enterprise Server 10.3.16-1 from 200 to 202

10.3 Community

  • Default value changed in MariaDB Community Server 10.3.0 from 187 to 189

  • Default value changed in MariaDB Community Server 10.3.1 from 189 to 191

  • Default value changed in MariaDB Community Server 10.3.5 from 191 to 200

10.2 Enterprise

  • Default value changed in MariaDB Enterprise Server 10.2.25-1 from 188 to 190

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Default value changed in MariaDB Community Server 10.2.2 from 181 to 184

  • Default value changed in MariaDB Community Server 10.2.3 from 184 to 185

  • Default value changed in MariaDB Community Server 10.2.4 from 185 to 187

  • Default value changed in MariaDB Community Server 10.2.7 from 187 to 188

EXTERNAL REFERENCES