max_sort_length

Overview

The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored)

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

--max_sort_length=#

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

BIGINT UNSIGNED

Minimum Value

64

Maximum Value

8388608

Default Value

1024

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.

  • Minimum value changed in MariaDB Enterprise Server 10.5.4-2 from 4 to 8

  • Minimum value changed in MariaDB Enterprise Server 10.5.9-6 from 8 to 64

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

  • Minimum value changed in MariaDB Community Server 10.5.4 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.5.9 from 8 to 64

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Minimum value changed in MariaDB Enterprise Server 10.4.14-8 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.4.18-11 from 8 to 64

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

  • Minimum value changed in MariaDB Community Server 10.4.14 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.4.18 from 8 to 64

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

  • Minimum value changed in MariaDB Enterprise Server 10.3.24-8 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.3.28-11 from 8 to 64

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Minimum value changed in MariaDB Community Server 10.3.24 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.3.28 from 8 to 64

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

  • Minimum value changed in MariaDB Enterprise Server 10.2.33-8 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.2.37-11 from 8 to 64

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Minimum value changed in MariaDB Community Server 10.2.33 from 4 to 8

  • Minimum value changed in MariaDB Community Server 10.2.37 from 8 to 64

EXTERNAL REFERENCES