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

I_S.INNODB_SYS_TABLESPACES doesn't have temporary tablespace information

    XMLWordPrintable

    Details

      Description

      Innodb_sys_tablespaces view in information schema doesn't show temporary tablespace
      information. The following is the output of information schema output

      select * from information_schema.innodb_sys_tablespaces;
      SPACE	NAME	FLAG	ROW_FORMAT	PAGE_SIZE	FILENAME	FS_BLOCK_SIZE	FILE_SIZE	ALLOCATED_SIZE
      0	innodb_system	21	NULL	16384	./ibdata1	4096	12582912	12582912
      1	mysql/innodb_table_stats	21	NULL	16384	./mysql/innodb_table_stats.ibd	4096	65536	65536
      2	mysql/innodb_index_stats	21	NULL	16384	./mysql/innodb_index_stats.ibd	4096	65536	65536
      3	mysql/transaction_registry	21	NULL	16384	./mysql/transaction_registry.ibd	4096	114688	114688
      5	test/t	21	NULL	16384	./test/t.ibd	4096	81920	81920
      

      Above output should include temporary tablespace information with space as 0xFFFFFFFE

        Attachments

          Activity

            People

            Assignee:
            thiru Thirunarayanan Balathandayuthapani
            Reporter:
            thiru Thirunarayanan Balathandayuthapani
            Votes:
            1 Vote for this issue
            Watchers:
            6 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.