系统表介绍
INNODB_SYS_DATAFILES 提供了数据文件相关的信息
| 列名 | 含义 |
|---|---|
| SPACE | 表空间编号 |
| PATH | 路径 |
实例
mysql> select * from INNODB_SYS_DATAFILES ;
+-------+---------------------------------------------------------+
| SPACE | PATH |
+-------+---------------------------------------------------------+
| 2 | ./mysql/plugin.ibd |
| 3 | ./mysql/servers.ibd |
| 4 | ./mysql/help_topic.ibd |
| 5 | ./mysql/help_category.ibd |
| 6 | ./mysql/help_relation.ibd |
| 7 | ./mysql/help_keyword.ibd |
| 8 | ./mysql/time_zone_name.ibd |
| 9 | ./mysql/time_zone.ibd |
| 10 | ./mysql/time_zone_transition.ibd |
| 11 | ./mysql/time_zone_transition_type.ibd |
| 12 | ./mysql/time_zone_leap_second.ibd |
| 13 | ./mysql/innodb_table_stats.ibd |
| 14 | ./mysql/innodb_index_stats.ibd |
| 15 | ./mysql/slave_relay_log_info.ibd |
| 16 | ./mysql/slave_master_info.ibd |
| 17 | ./mysql/slave_worker_info.ibd |
| 18 | ./mysql/gtid_executed.ibd |
| 19 | ./mysql/server_cost.ibd |
| 20 | ./mysql/engine_cost.ibd |
| 21 | ./sys/sys_config.ibd |
| 24 | ./daozhang/it_task.ibd |
| 25 | ./daozhang/it_user.ibd |
| 26 | ./dao/t1.ibd |
| 30 | ./dao/app_active_add.ibd |
| 51 | ./dao/articles.ibd |
| 52 | ./dao/FTS_0000000000000043_BEING_DELETED.ibd |
| 53 | ./dao/FTS_0000000000000043_BEING_DELETED_CACHE.ibd |
| 54 | ./dao/FTS_0000000000000043_CONFIG.ibd |
| 55 | ./dao/FTS_0000000000000043_DELETED.ibd |
| 56 | ./dao/FTS_0000000000000043_DELETED_CACHE.ibd |
| 57 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_1.ibd |
| 58 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_2.ibd |
| 59 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_3.ibd |
| 60 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_4.ibd |
| 61 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_5.ibd |
| 62 | ./dao/FTS_0000000000000043_0000000000000052_INDEX_6.ibd |
+-------+---------------------------------------------------------+
36 rows in set (0.00 sec)