概述
Performance Schema 下的实例（Instance）表，主要显示被监控的对象类型。
主要包含下列的表
•cond_instances: 条件相关•file_instances: 文件实例•mutex_instances: 互斥信号量•rwlock_instances: 锁相关•socket_instances: 活动链接相关
##cond_instances
系统表介绍
cond_instances 表记录了条件（conditions）列表。 条件或条件检测对象是指一个内部的代码机制，标志发生了一个特殊的事件，线程正在等待这个事件以恢复运行。该表不允许truncate
| 列名 | 含义 |
| NAME | 监测器名称 |
| OBJECT_INSTANCE_BEGIN | 监测器内存地址 |
实例
mysql> select *from cond_instances ;
+------------------------------------------------------------+-----------------------+
| NAME | OBJECT_INSTANCE_BEGIN |
+------------------------------------------------------------+-----------------------+
| wait/synch/cond/sql/COND_manager | 34053520 |
| wait/synch/cond/sql/COND_server_started | 33969072 |
| wait/synch/cond/sql/COND_compress_gtid_table | 33968896 |
| wait/synch/cond/sql/COND_socket_listener_active | 33968784 |
| wait/synch/cond/sql/COND_start_signal_handler | 33968672 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond | 34187040 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::prep_xids_cond | 34189528 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_done | 34189808 |
| wait/synch/cond/sql/COND_thread_cache | 34180544 |
| wait/synch/cond/sql/COND_flush_thread_cache | 34180480 |
| wait/synch/cond/sql/COND_connection_count | 34028528 |
| wait/synch/cond/sql/COND_thd_list | 36691168 |
| wait/synch/cond/sql/COND_open | 34039280 |
| wait/synch/cond/sql/Query_cache::COND_cache_status_changed | 33967792 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390602639816 |
| wait/synch/cond/sql/COND_thr_lock | 140390602644352 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390535530888 |
| wait/synch/cond/sql/COND_thr_lock | 140390535535424 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390401313160 |
| wait/synch/cond/sql/COND_thr_lock | 140390401317696 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390468422024 |
| wait/synch/cond/sql/COND_thr_lock | 140390468426560 |
| wait/synch/cond/innodb/commit_cond | 34237856 |
| wait/synch/cond/myisam/keycache_thread_var::suspend | 34766912 |
| wait/synch/cond/sql/Gtid_state | 37095680 |
| wait/synch/cond/sql/Gtid_state | 37095824 |
| wait/synch/cond/sql/Master_info::data_cond | 44686904 |
| wait/synch/cond/sql/Master_info::start_cond | 44686960 |
| wait/synch/cond/sql/Master_info::stop_cond | 44687016 |
| wait/synch/cond/sql/Master_info::sleep_cond | 44687072 |
| wait/synch/cond/sql/Relay_log_info::data_cond | 45223368 |
| wait/synch/cond/sql/Relay_log_info::start_cond | 45223424 |
| wait/synch/cond/sql/Relay_log_info::stop_cond | 45223480 |
| wait/synch/cond/sql/Relay_log_info::sleep_cond | 45223536 |
| wait/synch/cond/sql/Relay_log_info::log_space_cond | 45231272 |
| wait/synch/cond/sql/Relay_log_info::pending_jobs_cond | 45233800 |
| wait/synch/cond/sql/Relay_log_info::mts_gaq_cond | 45223992 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond | 45225464 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::prep_xids_cond | 45227952 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_done | 45228232 |
| wait/synch/cond/sql/COND_queue_state | 45452336 |
| wait/synch/cond/sql/Event_scheduler::COND_state | 45452560 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 45255496 |
| wait/synch/cond/sql/COND_thr_lock | 45260032 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390200222696 |
| wait/synch/cond/sql/COND_thr_lock | 140390200227232 |
+------------------------------------------------------------+-----------------------+
46 rows in set (0.00 sec)
file_instances
系统表介绍
file_instances 表列举了在执行文件I/O操作时触发的检测器
| 列名 | 含义 |
| FILE_NAME | 文件名 |
| EVENT_NAME | 事件名 |
| OPEN_COUNT | 打开的次数 |
实例
mysql> select *from file_instances ;
+-----------------------------------------------------------------------------------------+--------------------------------------+------------+
| FILE_NAME | EVENT_NAME | OPEN_COUNT |
+-----------------------------------------------------------------------------------------+--------------------------------------+------------+
| /usr/local/mysql57/share/english/errmsg.sys | wait/io/file/sql/ERRMSG | 0 |
| /usr/local/mysql57/share/charsets/Index.xml | wait/io/file/mysys/charset | 0 |
| /data/mysql/ibdata1 | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/ib_logfile0 | wait/io/file/innodb/innodb_log_file | 2 |
| /data/mysql/ib_logfile1 | wait/io/file/innodb/innodb_log_file | 2 |
| /data/mysql/mysql/engine_cost.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/gtid_executed.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| data/mysql/mysql/help_category.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/help_keyword.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/help_relation.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/help_topic.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/innodb_index_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/innodb_table_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/plugin.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/server_cost.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/servers.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/slave_master_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/slave_relay_log_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/slave_worker_info.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/time_zone.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/time_zone_leap_second.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/time_zone_name.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/time_zone_transition.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/mysql/time_zone_transition_type.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/sys/sys_config.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /data/mysql/ibtmp1 | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/mysql/plugin.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/binlog.000002 | wait/io/file/sql/binlog | 0 |
| /data/mysql/binlog.000003 | wait/io/file/sql/binlog | 1 |
| /data/mysql/binlog.index | wait/io/file/sql/binlog_index | 1 |
| /data/mysql/auto.cnf | wait/io/file/mysys/cnf | 0 |
| /data/mysql/mysql/gtid_executed.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/binlog.000001 | wait/io/file/sql/binlog | 0 |
| /data/mysql/etlbi.pid | wait/io/file/sql/pid | 0 |
| /data/mysql/mysql/server_cost.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/engine_cost.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/user.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/user.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/user.MYD | wait/io/file/myisam/dfile | 11 |
| /data/mysql/mysql/db.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/db.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/db.MYD | wait/io/file/myisam/dfile | 4 |
| /data/mysql/mysql/proxies_priv.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/proxies_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/proxies_priv.MYD | wait/io/file/myisam/dfile | 11 |
| /data/mysql/mysql/time_zone_leap_second.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/time_zone_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/time_zone.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/time_zone_transition_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/time_zone_transition.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/tables_priv.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/tables_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/tables_priv.MYD | wait/io/file/myisam/dfile | 11 |
| /data/mysql/mysql/columns_priv.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/columns_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/columns_priv.MYD | wait/io/file/myisam/dfile | 5 |
| /data/mysql/mysql/procs_priv.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/procs_priv.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/procs_priv.MYD | wait/io/file/myisam/dfile | 11 |
| /data/mysql/mysql/servers.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/func.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/func.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/func.MYD | wait/io/file/myisam/dfile | 2 |
| /data/mysql/mysql/slave_master_info.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/slave_relay_log_info.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/slave_worker_info.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/cond_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_current.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_history.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_history_long.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_waits_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/file_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/file_summary_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/file_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/host_cache.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/mutex_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/objects_summary_global_by_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/performance_timers.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/rwlock_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/setup_actors.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/setup_consumers.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/setup_instruments.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/setup_objects.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/setup_timers.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/table_io_waits_summary_by_table.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/table_lock_waits_summary_by_table.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/threads.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_current.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_history.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_history_long.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_stages_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_current.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_history.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_history_long.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_digest.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_statements_summary_by_program.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_current.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_history.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_history_long.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/events_transactions_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/users.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/accounts.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/hosts.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/socket_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/socket_summary_by_instance.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/socket_summary_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/session_connect_attrs.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/session_account_connect_attrs.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/memory_summary_global_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/memory_summary_by_account_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/memory_summary_by_host_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/memory_summary_by_thread_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/memory_summary_by_user_by_event_name.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/table_handles.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/metadata_locks.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_connection_configuration.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_group_members.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_connection_status.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_applier_configuration.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_applier_status.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_applier_status_by_coordinator.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_applier_status_by_worker.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/replication_group_member_stats.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/prepared_statements_instances.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/user_variables_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/status_by_account.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/status_by_host.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/status_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/status_by_user.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/global_status.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/session_status.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/variables_by_thread.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/global_variables.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/performance_schema/session_variables.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/event.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/event.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/event.MYD | wait/io/file/myisam/dfile | 3 |
| /data/mysql/mysql/db.opt | wait/io/file/sql/dbopt | 0 |
| /data/mysql/performance_schema/db.opt | wait/io/file/sql/dbopt | 0 |
| /data/mysql/sys/db.opt | wait/io/file/sql/dbopt | 0 |
| /data/mysql/daozhang/db.opt | wait/io/file/sql/dbopt | 0 |
| /data/mysql/daozhang/it_task.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/daozhang/it_task.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/daozhang/it_user.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/daozhang/it_user.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/db.opt | wait/io/file/sql/dbopt | 0 |
| /data/mysql/dao/t1.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/dao/t1.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/mysql/general_log.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/general_log.CSM | wait/io/file/csv/metadata | 1 |
| /data/mysql/mysql/general_log.CSV | wait/io/file/csv/data | 2 |
| /data/mysql/mysql/help_category.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/help_keyword.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/help_relation.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/help_topic.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/innodb_index_stats.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/innodb_table_stats.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/ndb_binlog_index.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/ndb_binlog_index.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/ndb_binlog_index.MYD | wait/io/file/myisam/dfile | 9 |
| /data/mysql/mysql/proc.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/proc.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/mysql/proc.MYD | wait/io/file/myisam/dfile | 11 |
| /data/mysql/mysql/slow_log.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/mysql/slow_log.CSM | wait/io/file/csv/metadata | 1 |
| /data/mysql/mysql/slow_log.CSV | wait/io/file/csv/data | 9 |
| /data/mysql/sys/host_summary.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/host_summary_by_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/host_summary_by_file_io_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/host_summary_by_stages.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/host_summary_by_statement_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/host_summary_by_statement_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/innodb_buffer_stats_by_schema.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/innodb_buffer_stats_by_table.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/innodb_lock_waits.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/io_by_thread_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/io_global_by_file_by_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/io_global_by_file_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/io_global_by_wait_by_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/io_global_by_wait_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/latest_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/memory_by_host_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/memory_by_thread_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/memory_by_user_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/memory_global_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/memory_global_total.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/metrics.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/processlist.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/ps_check_lost_instrumentation.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_auto_increment_columns.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_index_statistics.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_object_overview.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_redundant_indexes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_table_lock_waits.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_table_statistics.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_table_statistics_with_buffer.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_tables_with_full_table_scans.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/schema_unused_indexes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/session.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/session_ssl_status.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statement_analysis.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statements_with_errors_or_warnings.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statements_with_full_table_scans.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statements_with_runtimes_in_95th_percentile.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statements_with_sorting.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/statements_with_temp_tables.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/sys_config.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/sys_config.TRG | wait/io/file/sql/file_parser | 0 |
| /data/mysql/sys/user_summary.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/user_summary_by_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/user_summary_by_file_io_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/user_summary_by_stages.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/user_summary_by_statement_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/user_summary_by_statement_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/version.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/wait_classes_global_by_avg_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/wait_classes_global_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/waits_by_host_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/waits_by_user_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/waits_global_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary_by_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary_by_file_io_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary_by_stages.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary_by_statement_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024host_summary_by_statement_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024innodb_buffer_stats_by_schema.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024innodb_buffer_stats_by_table.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024innodb_lock_waits.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024io_by_thread_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024io_global_by_file_by_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024io_global_by_file_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024io_global_by_wait_by_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024io_global_by_wait_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024latest_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024memory_by_host_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024memory_by_user_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024memory_global_by_current_bytes.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024memory_global_total.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024processlist.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024ps_digest_avg_latency_distribution.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024ps_schema_table_statistics_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_flattened_keys.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_index_statistics.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_table_lock_waits.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_table_statistics.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_table_statistics_with_buffer.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024schema_tables_with_full_table_scans.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024session.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statement_analysis.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statements_with_errors_or_warnings.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statements_with_full_table_scans.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statements_with_runtimes_in_95th_percentile.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statements_with_sorting.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024statements_with_temp_tables.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary_by_file_io.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary_by_file_io_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary_by_stages.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary_by_statement_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024user_summary_by_statement_type.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024wait_classes_global_by_avg_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024wait_classes_global_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024waits_by_host_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024waits_by_user_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/sys/x@0024waits_global_by_latency.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/dao/qb_area.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/dao/qb_area.MYI | wait/io/file/myisam/kfile | 1 |
| /data/mysql/dao/qb_area.MYD | wait/io/file/myisam/dfile | 4 |
| /data/mysql/dao/app_active_add.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/dao/app_active_add.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/articles.frm | wait/io/file/sql/FRM | 0 |
| /data/mysql/dao/articles.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_BEING_DELETED.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_BEING_DELETED_CACHE.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_CONFIG.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_DELETED.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_DELETED_CACHE.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_1.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_2.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_3.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_4.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_5.ibd | wait/io/file/innodb/innodb_data_file | 2 |
| /data/mysql/dao/FTS_0000000000000043_0000000000000052_INDEX_6.ibd | wait/io/file/innodb/innodb_data_file | 2 |
+-----------------------------------------------------------------------------------------+--------------------------------------+------------+
305 rows in set (0.00 sec)
mutex_instances
系统表介绍
mutex_instances 表记录了服务器运行时捕获的信号量。
mutex是代码中的同步控制机制中的互斥信号量，用以确保在给定时间只有一个线程可以访问某些公共资源。
| 列名 | 含义 |
| NAME | mutex监测器名称 |
| OBJECT_INSTANCE_BEGIN | 被监测的mutex地址 |
| LOCKED_BY_THREAD_ID | 如有mutex被锁定，此处为持有该锁的线程（thread）ID，其余时刻为空 |
实例
mysql> select *from mutex_instances limit 10 ;
+---------------------------------------------------+-----------------------+---------------------+
| NAME | OBJECT_INSTANCE_BEGIN | LOCKED_BY_THREAD_ID |
+---------------------------------------------------+-----------------------+---------------------+
| wait/synch/mutex/mysys/THR_LOCK_heap | 34766560 | NULL |
| wait/synch/mutex/mysys/THR_LOCK_net | 34766304 | NULL |
| wait/synch/mutex/mysys/THR_LOCK_myisam | 34766240 | NULL |
| wait/synch/mutex/mysys/THR_LOCK_malloc | 34766368 | NULL |
| wait/synch/mutex/mysys/THR_LOCK_open | 34766624 | NULL |
| wait/synch/mutex/mysys/THR_LOCK_charset | 34766688 | NULL |
| wait/synch/mutex/sql/LOCK_error_log | 34036256 | NULL |
| wait/synch/mutex/sql/LOCK_audit_mask | 33982944 | NULL |
| wait/synch/mutex/session/LOCK_srv_session_threads | 33983016 | NULL |
| wait/synch/mutex/sql/LOG::LOCK_log | 36646928 | NULL |
+---------------------------------------------------+-----------------------+---------------------+
10 rows in set (0.00 sec)
rwlock_instances
系统表介绍
rwlock_instances 表列举了服务器运行时，捕获的读写锁实例
| 列名 | 含义 |
| NAME | 锁监测器名称 |
| OBJECT_INSTANCE_BEGIN | 锁检测器内存地址 |
| WRITE_LOCKED_BY_THREAD_ID | 如有线程持有排它锁，此处为持有该锁的线程（thread）ID，其余时刻为空 |
| READ_LOCKED_BY_COUNT | 当一个线程支持有共享模式的 |
实例
+-------------------------------------------------------+-----------------------+---------------------------+----------------------+
| NAME | OBJECT_INSTANCE_BEGIN | WRITE_LOCKED_BY_THREAD_ID | READ_LOCKED_BY_COUNT |
+-------------------------------------------------------+-----------------------+---------------------------+----------------------+
| wait/synch/rwlock/session/LOCK_srv_session_collection | 33983192 | NULL | 0 |
| wait/synch/rwlock/sql/LOGGER::LOCK_logger | 34036096 | NULL | 0 |
| wait/synch/rwlock/sql/LOCK_system_variables_hash | 33969280 | NULL | 0 |
| wait/synch/rwlock/sql/LOCK_sys_init_connect | 33969408 | NULL | 0 |
| wait/synch/rwlock/sql/LOCK_sys_init_slave | 33969344 | NULL | 0 |
| wait/synch/rwlock/mysys/SAFE_HASH::lock | 34215520 | NULL | 0 |
| wait/synch/rwlock/sql/LOCK_dboptions | 34040992 | NULL | 0 |
| wait/synch/rwlock/sql/MDL_lock::rwlock | 36932952 | NULL | 0 |
| wait/synch/rwlock/sql/MDL_lock::rwlock | 36933560 | NULL | 0 |
| wait/synch/rwlock/sql/Trans_delegate::lock | 34038080 | NULL | 0 |
+-------------------------------------------------------+-----------------------+---------------------------+----------------------+
10 rows in set (0.00 sec)
socket_instances
系统表介绍
socket_instances 表提供了 当前MySQL服务器链接的实时快照。表中每一行代表一个TCP/IP or Unix socket 文件连接 。
| 列名 | 含义 |
| EVENT_NAME | 事件名称 |
| OBJECT_INSTANCE_BEGIN | 内存中唯一地址 |
| THREAD_ID | 内部线程编号 |
| SOCKET_ID | SOCKET 句柄 |
| IP | 客户端IP地址 |
| PORT | 端口号 |
| STATE | 状态 （IDLE/ ACTIVE） |
实例
mysql> SELECT * FROM performance_schema.socket_instances
-> ;
+----------------------------------------+-----------------------+-----------+-----------+----+------+--------+
| EVENT_NAME | OBJECT_INSTANCE_BEGIN | THREAD_ID | SOCKET_ID | IP | PORT | STATE |
+----------------------------------------+-----------------------+-----------+-----------+----+------+--------+
| wait/io/socket/sql/server_tcpip_socket | 44603392 | 1 | 27 | :: | 3306 | ACTIVE |
| wait/io/socket/sql/server_unix_socket | 44603712 | 1 | 34 | | 0 | ACTIVE |
| wait/io/socket/sql/client_connection | 44625152 | 346 | 66 | | 0 | ACTIVE |
+----------------------------------------+-----------------------+-----------+-----------+----+------+--------+
3 rows in set (0.00 sec)
文章转载自数据小仙，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
