join_cache_level

Controls what join operations can be executed with join buffers. Odd numbers are used for plain join buffers while even numbers are used for linked buffers

See also: System Variables in 10.4, in 10.3, and in 10.2

Parameters

  • Commandline: --join_cache_level=#

  • Scope: Global, Session

  • Data Type: BIGINT UNSIGNED

  • Default Value: 2

  • Minimum Value: 0

  • Maximum Value: 8

Change History

Release Series

History

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.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

External References