[MDEV-11633] Make the InnoDB system tablespace optional Created: 2016-12-22  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 6
Labels: innodb, tablespace, transactions

Issue Links:
Blocks
is blocked by MDEV-11657 Cross-engine transaction metadata Open
is blocked by MDEV-11658 Simpler, faster IMPORT of InnoDB tables Open
is blocked by MDEV-11659 Move the InnoDB doublewrite buffer to... Open
is blocked by MDEV-15020 Server hangs due to InnoDB persistent... Closed
is blocked by MDEV-17567 Atomic DDL Closed
is blocked by MDEV-19506 Remove the global sequence DICT_HDR_R... Closed
is blocked by MDEV-21463 Support FULLTEXT INDEX for all storag... Open
is blocked by MDEV-22343 Remove SYS_TABLESPACES and SYS_DATAFILES Closed
is blocked by MDEV-28730 Remove internal parser usage from Inn... Open
is blocked by MDEV-29985 Remove the parameter innodb_file_per_... Stalled
Relates
relates to MDEV-15185 PARTITION files removed, but not from... Closed
relates to MDEV-21867 Unsafe writes in fil_write_flushed_lsn() Closed

 Description   

The InnoDB system tablespace is an opaque entity that contains essential system data, such as the transaction system state (undo logs could also be in separate tablespaces) and part of the data dictionary information.

Tablespaces cannot shrink in InnoDB, and the system tablespace cannot be reinitialized. If the system tablespace grows (for example, someone accidentally creates a huge table in it, or accidentally forgets to commit a transaction, causing undo logs to grow, or the change buffer grows for some reason), there is no other remedy than importing or loading the data to a newly initialized innoDB instance.

Similarly, if the system tablespace gets corrupted, it is ‘game over’.

This is an umbrella task consisting of subtasks to replace the various system objects stored in the InnoDB system tablespace. The actual work will be done in the subtasks.



 Comments   
Comment by Marko Mäkelä [ 2022-06-02 ]

MDEV-28730 removes one important use case of the InnoDB internal SQL parser.

Generated at Thu Feb 08 07:51:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.