innodb_defragment_frequency

Topics on this page:

Overview

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, 10.2 ES, 10.2 CS:: Do not defragment a single index more than this number of time per second.This controls the number of time defragmentation thread can request X_LOCK on an index. Defragmentation thread will check whether 1/defragment_frequency (s) has passed since it worked on this index last time, and put the index back to the queue if not enough time has passed. The actual frequency can only be lower than this given number.

In 10.6 ES, 10.5 ES, 10.4 ES:: Do not defragment a single index more than this number of time per second.This controls the number of time defragmentation thread can request X_LOCK on an index. Defragmentation thread will check whether 1/defragment_frequency (s) has passed since it worked on this index last time, and put the index back to the queue if not enough time has passed. The actual frequency can only be lower than this given number.

Command-line	--innodb_defragment_frequency=#
Configuration file	Supported
Dynamic	Yes
Scope	Global
Data Type	INT UNSIGNED
Minimum Value	1
Maximum Value	1000
Product Default Value	40

Cloud	SkySQL Topology	ES Ver	Service Default
AWS	Multi-Node Analytics	10.6	40
	Single Node Analytics	10.6	40
	Replicated Transactions	10.4	40
		10.5	40
		10.6	40
	Single Node Transactions	10.4	40
		10.5	40
		10.6	40
GCP	Multi-Node Analytics	10.6	40
	Single Node Analytics	10.6	40
	Replicated Transactions	10.4	40
		10.5	40
		10.6	40
	Single Node Transactions	10.4	40
		10.5	40
		10.6	40

Cloud	SkySQL Topology	ES Ver	Service Default
AWS	ColumnStore Data Warehouse	10.6	40
	Enterprise Server With Replica(s)	10.4	40
		10.5	40
		10.6	40
	Enterprise Server Single Node	10.4	40
		10.5	40
		10.6	40
GCP	ColumnStore Data Warehouse	10.6	40
	Enterprise Server With Replica(s)	10.4	40
		10.5	40
		10.6	40
	Enterprise Server Single Node	10.4	40
		10.5	40
		10.6	40

Release Series	History
23.08 Enterprise	Not present.
23.07 Enterprise	Removed in MariaDB Enterprise Server 23.07.0.
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.
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.

Release Series	History
23.08 Enterprise	Not present.
23.07 Enterprise	Removed in MariaDB Enterprise Server 23.07.0.
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.

Additional information on this topic may be found in the MariaDB Public Knowledge Base.