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

InnoDB temporary tablespace: reclaimimg of free space does not work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.7, 10.6.4
    • Fix Version/s: 10.5, 10.6, 10.7
    • Labels:
      None
    • Environment:
      official mariadb docker image:
      Linux 3dcfdcf52f71 5.10.47-linuxkit #1 SMP Sat Jul 3 21:51:47 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

      Description

      When using InnoDB engine for temporary tables, reclaiming of free table space does not seem to work.

      Periodically performing statements that force the server to write into InnoDB temporary tablespace eventually results in the reaching of maximum size of temporary table space or even a full disk.

      I was able to reproduce this behaviour by execution of following statements more times even when the connection between the executions is dropped:

      create temporary table temp_random (
          id bigint primary key,
          random decimal not null
      );
      insert into temp_random(id, random) select seq, rand() from seq_0_to_2000000;
      drop temporary table temp_random;
      

      After each execution grow the file /var/lib/mysql/ibtmp1 in size

      Expected behaviour:
      The file /var/lib/mysql/ibtmp1 should grow in size only after first execution. After second an further execution should the file size stay eventually unchnaged as the space claimed by the first execution should be reused by the further executions.

      Last version where the expected behaviour was observed: 10.5.11

      Workarround: explicitly setting engine for temporary tables to MyISAM

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              javolek Jan Volf
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration