Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
According to MariaDB documentation, this query:
https://mariadb.com/kb/en/innodb-temporary-tablespaces/
SELECT FILE_NAME AS "File Name",
INITIAL_SIZE AS "Initial Size",
DATA_FREE AS "Free Space",
TOTAL_EXTENTS * EXTENT_SIZE AS "Total Size",
MAXIMUM_SIZE AS "Max"
FROM information_Schema.FILES
;
Empty set (0.000 sec)
should show some results when using explicit temporary innodb tables:
create temporary table temp_random (
id bigint primary key,
random decimal not null
) engine = innodb;
insert into temp_random(id, random) select seq, rand() from seq_0_to_2000000;
drop temporary table temp_random;
but does not. Possibly related to: https://jira.mariadb.org/browse/MDEV-26782
Attachments
Issue Links
- relates to
-
MDEV-26782 InnoDB temporary tablespace: reclaiming of free space does not work
- Closed
-
MDEV-11426 Remove InnoDB INFORMATION_SCHEMA.FILES implementation
- Closed
-
MDEV-22343 Remove SYS_TABLESPACES and SYS_DATAFILES
- Closed