INNODB_TABLESPACES_SCRUBBING¶

In 10.5 ES:: Not present
In 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:: InnoDB TABLESPACES_SCRUBBING

DETAILS¶

SCHEMA¶

CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` (
  `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0,
  `NAME` varchar(655) DEFAULT NULL,
  `COMPRESSED` int(1) unsigned NOT NULL DEFAULT 0,
  `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL,
  `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL,
  `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL,
  `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0,
  `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0,
  `ON_SSD` int(1) unsigned NOT NULL DEFAULT 0
)

CHANGE HISTORY¶

Release Series	History
10.5 Enterprise	Not present.
10.5 Community	Present starting in MariaDB Community Server 10.5.0. Removed in MariaDB Community Server 10.5.2.
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. Schema changed in MariaDB Community Server 10.4.4: ... CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` ( `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `NAME` varchar(655) DEFAULT NULL, `COMPRESSED` int(11) unsigned NOT NULL DEFAULT 0, `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL, `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL, `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL, `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `ROTATING_OR_FLUSHINGON_SSD` int(11) unsigned NOT NULL DEFAULT 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. Schema changed in MariaDB Community Server 10.3.15: ... CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` ( `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `NAME` varchar(655) DEFAULT NULL, `COMPRESSED` int(11) unsigned NOT NULL DEFAULT 0, `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL, `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL, `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL, `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `ROTATING_OR_FLUSHING` int(11) unsigned NOT NULL DEFAULT 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. Schema changed in MariaDB Community Server 10.2.2: ... CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` ( `SPACE` bigint(21) unsigned NOT NULL DEFAULT '0'0, `NAME` varchar(655) DEFAULT NULL, `COMPRESSED` int(11) unsigned NOT NULL DEFAULT '0'0, `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL, `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL, `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL, `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT '0'0, `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT '0'0 ) Schema changed in MariaDB Community Server 10.2.5: ... CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` ( `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `NAME` varchar(655) DEFAULT NULL, `COMPRESSED` int(11) unsigned NOT NULL DEFAULT 0, `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL, `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL, `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL, `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `ROTATING_OR_FLUSHING` int(11) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Community Server 10.2.24: ... CREATE TEMPORARY TABLE `INNODB_TABLESPACES_SCRUBBING` ( `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `NAME` varchar(655) DEFAULT NULL, `COMPRESSED` int(11) unsigned NOT NULL DEFAULT 0, `LAST_SCRUB_COMPLETED` datetime DEFAULT NULL, `CURRENT_SCRUB_STARTED` datetime DEFAULT NULL, `CURRENT_SCRUB_ACTIVE_THREADS` int(11) unsigned DEFAULT NULL, `CURRENT_SCRUB_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `CURRENT_SCRUB_MAX_PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `ROTATING_OR_FLUSHING` int(11) unsigned NOT NULL DEFAULT 0 )

EXTERNAL REFERENCES¶

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

Information specific to MariaDB SkySQL can be found on the INNODB_TABLESPACES_SCRUBBING page in the SkySQL Documentation.