Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2
-
Fix Version/s: 10.2.6
-
Component/s: Storage Engine - InnoDB
Description
The InnoDB temporary tablespace is only usable if innodb_read_only=OFF. It is useless to create the tablespace in read-only mode, because CREATE TEMPORARY TABLE is disallowed if innodb_read_only, and nothing can we written to the temporary tablespace if no temporary tables can be created.
(Note that in MySQL 5.7, optimizer-internal temporary tables might still use the InnoDB temporary tablespace even if innodb_read_only. In MariaDB the optimizer does not use InnoDB for its temporary tables, and MDEV-11487 removed the related InnoDB code.)
Attachments
Issue Links
- relates to
-
MDEV-12367 Upgrade from previous versions to 10.2 with innodb-read-only does not work
-
- Closed
-