file_instances：文件实例
用户的表文件等
表中记录了系统中打开了文件的对象，包括ibdata文件，redo文件，binlog文件，用户的表文件等，比如redo日志文件：/u01/my3306/data/ib_logfile0。open_count显示当前文件打开的数目，如果重来没有打开过，不会出现在表中。
mysql> select * from file_instances;
+---------------------------------------------------------------------------------------------------+--------------------------------------+------------+
| FILE_NAME | EVENT_NAME | OPEN_COUNT |
+---------------------------------------------------------------------------------------------------+--------------------------------------+------------+
| /usr/local/mysql/share/english/errmsg.sys | wait/io/file/sql/ERRMSG | 0 |
| /usr/local/mysql/share/charsets/Index.xml | wait/io/file/mysys/charset | 0 |
| /usr/local/mysql/data/ibdata1 | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/ib_logfile0 | wait/io/file/innodb/innodb_log_file | 2 |
| /usr/local/mysql/data/ib_logfile1 | wait/io/file/innodb/innodb_log_file | 2 |
| /usr/local/mysql/data/mysql/engine_cost.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/gtid_executed.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/help_category.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/help_keyword.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/help_relation.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/help_topic.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/innodb_index_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/innodb_table_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/plugin.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/server_cost.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/servers.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/slave_master_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/slave_relay_log_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/slave_worker_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/time_zone.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/time_zone_leap_second.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/time_zone_name.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/time_zone_transition.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/mysql/time_zone_transition_type.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/sys/sys_config.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /usr/local/mysql/data/ibtmp1 | wait/io/file/innodb/innodb_data_file | 2 |
| /usr/local/mysql/data/mysql/plugin.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql-bin.000001 | wait/io/file/sql/binlog | 1 |
| /usr/local/mysql/data/mysql-bin.index | wait/io/file/sql/binlog_index | 1 |
| /usr/local/mysql/data/auto.cnf | wait/io/file/mysys/cnf | 0 |
| /usr/local/mysql/data/mysql/gtid_executed.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/localhost.localdomain.pid | wait/io/file/sql/pid | 0 |
| /usr/local/mysql/data/mysql/server_cost.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/engine_cost.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/user.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/user.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/user.MYD | wait/io/file/myisam/dfile | 5 |
| /usr/local/mysql/data/mysql/db.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/db.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/db.MYD | wait/io/file/myisam/dfile | 5 |
| /usr/local/mysql/data/mysql/proxies_priv.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/proxies_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/proxies_priv.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/time_zone_leap_second.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/time_zone_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/time_zone.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/time_zone_transition_type.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/time_zone_transition.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/tables_priv.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/tables_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/tables_priv.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/columns_priv.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/columns_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/columns_priv.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/procs_priv.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/procs_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/procs_priv.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/servers.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/func.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/func.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/func.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/slave_master_info.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/slave_relay_log_info.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/slave_worker_info.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/cond_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_current.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_history.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_history_long.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_waits_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/file_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/file_summary_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/file_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/host_cache.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/mutex_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/objects_summary_global_by_type.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/performance_timers.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/rwlock_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/setup_actors.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/setup_consumers.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/setup_instruments.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/setup_objects.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/setup_timers.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/table_io_waits_summary_by_index_usage.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/table_io_waits_summary_by_table.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/table_lock_waits_summary_by_table.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/threads.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_current.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_history.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_history_long.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_stages_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_current.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_history.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_history_long.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_digest.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_statements_summary_by_program.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_current.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_history.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_history_long.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/events_transactions_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/users.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/accounts.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/hosts.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/socket_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/socket_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/socket_summary_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/session_connect_attrs.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/session_account_connect_attrs.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/memory_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/memory_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/memory_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/memory_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/memory_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/table_handles.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/metadata_locks.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_connection_configuration.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_group_members.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_connection_status.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_applier_configuration.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_applier_status.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_applier_status_by_coordinator.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_applier_status_by_worker.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/replication_group_member_stats.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/prepared_statements_instances.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/user_variables_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/status_by_account.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/status_by_host.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/status_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/status_by_user.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/global_status.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/session_status.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/variables_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/global_variables.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/performance_schema/session_variables.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/event.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/event.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/event.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/db.opt | wait/io/file/sql/dbopt | 0 |
| /usr/local/mysql/data/performance_schema/db.opt | wait/io/file/sql/dbopt | 0 |
| /usr/local/mysql/data/sys/db.opt | wait/io/file/sql/dbopt | 0 |
| /usr/local/mysql/data/mysql/general_log.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/general_log.CSM | wait/io/file/csv/metadata | 1 |
| /usr/local/mysql/data/mysql/general_log.CSV | wait/io/file/csv/data | 4 |
| /usr/local/mysql/data/mysql/help_category.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/help_keyword.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/help_relation.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/help_topic.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/innodb_index_stats.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/innodb_table_stats.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/ndb_binlog_index.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/ndb_binlog_index.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/ndb_binlog_index.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/proc.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/proc.MYI | wait/io/file/myisam/kfile | 1 |
| /usr/local/mysql/data/mysql/proc.MYD | wait/io/file/myisam/dfile | 4 |
| /usr/local/mysql/data/mysql/slow_log.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/mysql/slow_log.CSM | wait/io/file/csv/metadata | 1 |
| /usr/local/mysql/data/mysql/slow_log.CSV | wait/io/file/csv/data | 4 |
| /usr/local/mysql/data/test/db.opt | wait/io/file/sql/dbopt | 0 |
| /usr/local/mysql/data/test/t1.frm | wait/io/file/sql/FRM | 0 |
| /usr/local/mysql/data/test/t1.ibd | wait/io/file/innodb/innodb_data_file | 2 |
+---------------------------------------------------------------------------------------------------+--------------------------------------+------------+
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
