Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27886

innodb temporay tablespace files are not shown correctly

    XMLWordPrintable

Details

    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

          Activity

            People

              greenman Ian Gilfillan
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.