Bug #77057 Add metadata to innodb_sys_datafiles

• Submitted: 16 May 2015 7:04
• Reporter: Daniël van Eeden (OCA)
• Status: Open
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 5.7.7-rc
• OS: Any
• CPU Architecture: Any

[16 May 2015 7:04] Daniël van Eeden

Description:
The following information is missing from innodb_sys_datafiles:
- Is autoextend enabled?
- What is the minimal size?
- Is there a max size set? What is it?
- What is the current size of the datafile?

How to repeat:
mysql [localhost] {msandbox} ((none)) > select * from information_schema.innodb_sys_tablespaces where space=0;
+-------+---------------+------+-------------+----------------------+-----------+---------------+------------+
| SPACE | NAME          | FLAG | FILE_FORMAT | ROW_FORMAT           | PAGE_SIZE | ZIP_PAGE_SIZE | SPACE_TYPE |
+-------+---------------+------+-------------+----------------------+-----------+---------------+------------+
|     0 | innodb_system |    0 | Antelope    | Compact or Redundant |     16384 |             0 | System     |
+-------+---------------+------+-------------+----------------------+-----------+---------------+------------+
1 row in set (0.01 sec)

mysql [localhost] {msandbox} ((none)) > select * from information_schema.innodb_sys_datafiles where space=0;
+-------+-----------+
| SPACE | PATH      |
+-------+-----------+
|     0 | ./ibdata1 |
+-------+-----------+
1 row in set (0.01 sec)

mysql [localhost] {msandbox} ((none)) > select @@global.innodb_data_file_path;
+------------------------------------+
| @@global.innodb_data_file_path     |
+------------------------------------+
| ibdata1:12M;ibdata2:12M:autoextend |
+------------------------------------+
1 row in set (0.01 sec)

Suggested fix:
Add more information to the I_S tables