MySQL :: MySQL 8.4 参考手册 :: 29.12.1 Performance Schema Table 参考

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 29 MySQL Performance Schema / 29.12 Performance Schema Table Descriptions / 29.12.1 Performance Schema Table 参考

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 97%

29.12.1 性能模式表参考29.12.1 Performance Schema Table Reference

下表总结了所有可用的性能模式表。有关详细信息，请参阅各个表的描述。The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions.

表 29.1 性能模式表Table 29.1 Performance Schema Tables

表名Table Name	说明Description
`accountsaccounts`	每个客户端账户的连接统计Connection statistics per client account
`binary_log_transaction_compression_statsbinary_log_transaction_compression_stats`	二进制日志事务压缩Binary log transaction compression
`clone_progressclone_progress`	克隆操作进度Clone operation progress
`clone_status`	克隆操作状态Clone operation status
`component_scheduler_tasks`	计划任务状态Status of scheduled tasks
`cond_instancescond_instances`	同步对象实例Synchronization object instances
`data_lock_waits`	数据锁等待关系Data lock wait relationships
`data_locks`	持有和请求的数据锁Data locks held and requested
`error_logerror_log`	服务器错误日志最近条目Server error log recent entries
`events_errors_summary_by_account_by_errorevents_errors_summary_by_account_by_error`	每个账户和错误代码的错误Errors per account and error code
`events_errors_summary_by_host_by_errorevents_errors_summary_by_host_by_error`	每个主机和错误代码的错误Errors per host and error code
`events_errors_summary_by_thread_by_errorevents_errors_summary_by_thread_by_error`	每个线程和错误代码的错误Errors per thread and error code
`events_errors_summary_by_user_by_errorevents_errors_summary_by_user_by_error`	每个用户和错误代码的错误Errors per user and error code
`events_errors_summary_global_by_errorevents_errors_summary_global_by_error`	每个错误代码的错误Errors per error code
`events_stages_currentevents_stages_current`	当前阶段事件Current stage events
`events_stages_historyevents_stages_history`	每个线程的最近阶段事件Most recent stage events per thread
`events_stages_history_longevents_stages_history_long`	最近的总体阶段事件Most recent stage events overall
`events_stages_summary_by_account_by_event_nameevents_stages_summary_by_account_by_event_name`	按账户和事件名称的阶段事件Stage events per account and event name
`events_stages_summary_by_host_by_event_nameevents_stages_summary_by_host_by_event_name`	按主机名称和事件名称的阶段事件Stage events per host name and event name
`events_stages_summary_by_thread_by_event_nameevents_stages_summary_by_thread_by_event_name`	每个线程和事件名称的阶段等待Stage waits per thread and event name
`events_stages_summary_by_user_by_event_nameevents_stages_summary_by_user_by_event_name`	每个用户名和事件名称的阶段事件Stage events per user name and event name
`events_stages_summary_global_by_event_nameevents_stages_summary_global_by_event_name`	每个事件名称的阶段等待Stage waits per event name
`events_statements_currentevents_statements_current`	当前语句事件Current statement events
`events_statements_histogram_by_digestevents_statements_histogram_by_digest`	每个模式和摘要值的语句直方图Statement histograms per schema and digest value
`events_statements_histogram_globalevents_statements_histogram_global`	全局汇总的语句直方图Statement histogram summarized globally
`events_statements_historyevents_statements_history`	每个线程的最近语句事件Most recent statement events per thread
`events_statements_history_longevents_statements_history_long`	最近的所有语句事件Most recent statement events overall
`events_statements_summary_by_account_by_event_nameevents_statements_summary_by_account_by_event_name`	每个账户和事件名称的语句事件Statement events per account and event name
`events_statements_summary_by_digestevents_statements_summary_by_digest`	每个模式和摘要值的语句事件Statement events per schema and digest value
`events_statements_summary_by_host_by_event_nameevents_statements_summary_by_host_by_event_name`	每个主机名和事件名称的语句事件Statement events per host name and event name
`events_statements_summary_by_programevents_statements_summary_by_program`	每个存储程序的语句事件Statement events per stored program
`events_statements_summary_by_thread_by_event_nameevents_statements_summary_by_thread_by_event_name`	每个线程和事件名称的语句事件Statement events per thread and event name
`events_statements_summary_by_user_by_event_nameevents_statements_summary_by_user_by_event_name`	每个用户名和事件名称的语句事件Statement events per user name and event name
`events_statements_summary_global_by_event_nameevents_statements_summary_global_by_event_name`	每个事件名称的语句事件Statement events per event name
`events_transactions_currentevents_transactions_current`	当前事务事件Current transaction events
`events_transactions_historyevents_transactions_history`	每个线程最近的事务事件Most recent transaction events per thread
`events_transactions_history_longevents_transactions_history_long`	整体最近的事务事件Most recent transaction events overall
`events_transactions_summary_by_account_by_event_nameevents_transactions_summary_by_account_by_event_name`	按账号和事件名称的事务事件Transaction events per account and event name
`events_transactions_summary_by_host_by_event_nameevents_transactions_summary_by_host_by_event_name`	按主机名和事件名的事务事件Transaction events per host name and event name
`events_transactions_summary_by_thread_by_event_nameevents_transactions_summary_by_thread_by_event_name`	按线程和事件名的事务事件Transaction events per thread and event name
`events_transactions_summary_by_user_by_event_nameevents_transactions_summary_by_user_by_event_name`	按用户名和事件名的事务事件Transaction events per user name and event name
`events_transactions_summary_global_by_event_nameevents_transactions_summary_global_by_event_name`	按事件名的事务事件Transaction events per event name
`events_waits_currentevents_waits_current`	当前等待事件Current wait events
`events_waits_historyevents_waits_history`	每个线程最近的等待事件Most recent wait events per thread
`events_waits_history_longevents_waits_history_long`	整体最近的等待事件Most recent wait events overall
`events_waits_summary_by_account_by_event_nameevents_waits_summary_by_account_by_event_name`	按账户和事件名称的等待事件Wait events per account and event name
`events_waits_summary_by_host_by_event_nameevents_waits_summary_by_host_by_event_name`	按主机名和事件名统计的等待事件Wait events per host name and event name
`events_waits_summary_by_instanceevents_waits_summary_by_instance`	按实例统计的等待事件Wait events per instance
`events_waits_summary_by_thread_by_event_nameevents_waits_summary_by_thread_by_event_name`	按线程和事件名统计的等待事件Wait events per thread and event name
`events_waits_summary_by_user_by_event_nameevents_waits_summary_by_user_by_event_name`	按用户名和事件名统计的等待事件Wait events per user name and event name
`events_waits_summary_global_by_event_nameevents_waits_summary_global_by_event_name`	按事件名统计的等待事件Wait events per event name
`file_instancesfile_instances`	文件实例File instances
`file_summary_by_event_namefile_summary_by_event_name`	按事件名统计的文件事件File events per event name
`file_summary_by_instancefile_summary_by_instance`	按文件实例统计的文件事件File events per file instance
`firewall_group_allowlistfirewall_group_allowlist`	组配置文件允许列表的防火墙内存数据Firewall in-memory data for group profile allowlists
`firewall_groupsfirewall_groups`	组配置文件的防火墙内存数据Firewall in-memory data for group profiles
`firewall_membershipfirewall_membership`	组配置文件成员的防火墙内存数据Firewall in-memory data for group profile members
`global_statusglobal_status`	全局状态变量Global status variables
`global_variablesglobal_variables`	全局系统变量Global system variables
`host_cachehost_cache`	来自内部主机缓存的信息Information from internal host cache
`hostshosts`	每个客户端主机名的连接统计Connection statistics per client host name
`keyring_component_statuskeyring_component_status`	已安装密钥环组件的状态信息Status information for installed keyring component
`keyring_keyskeyring_keys`	密钥环密钥的元数据Metadata for keyring keys
`log_statuslog_status`	用于备份目的的服务器日志信息Information about server logs for backup purposes
`memory_summary_by_account_by_event_namememory_summary_by_account_by_event_name`	按账户和事件名称的内存操作Memory operations per account and event name
`memory_summary_by_host_by_event_namememory_summary_by_host_by_event_name`	按主机和事件名称的内存操作Memory operations per host and event name
`memory_summary_by_thread_by_event_namememory_summary_by_thread_by_event_name`	按线程和事件名称的内存操作Memory operations per thread and event name
`memory_summary_by_user_by_event_namememory_summary_by_user_by_event_name`	每个用户和事件名称的内存操作Memory operations per user and event name
`memory_summary_global_by_event_namememory_summary_global_by_event_name`	按事件名称统计的全局内存操作Memory operations globally per event name
`metadata_locksmetadata_locks`	元数据锁及锁请求Metadata locks and lock requests
`mutex_instancesmutex_instances`	互斥同步对象实例Mutex synchronization object instances
`ndb_sync_excluded_objectsndb_sync_excluded_objects`	无法同步的 NDB 对象NDB objects which cannot be synchronized
`ndb_sync_pending_objectsndb_sync_pending_objects`	等待同步的 NDB 对象NDB objects waiting for synchronization
`objects_summary_global_by_typeobjects_summary_global_by_type`	对象摘要Object summaries
`performance_timersperformance_timers`	可用的事件计时器Which event timers are available
`persisted_variablespersisted_variables`	mysqld-auto.cnf 文件的内容Contents of mysqld-auto.cnf file
`prepared_statements_instancesprepared_statements_instances`	预备语句实例和统计信息Prepared statement instances and statistics
`processlistprocesslist`	进程列表信息Process list information
`replication_applier_configurationreplication_applier_configuration`	副本上复制器的配置参数Configuration parameters for replication applier on replica
`replication_applier_filtersreplication_applier_filters`	当前副本上特定通道的复制过滤器Channel-specific replication filters on current replica
`replication_applier_global_filters`	当前副本上的全局复制过滤器Global replication filters on current replica
`replication_applier_status`	副本上复制执行器的当前状态Current status of replication applier on replica
`replication_applier_status_by_coordinator`	SQL 或协调线程执行器状态SQL or coordinator thread applier status
`replication_applier_status_by_workerreplication_applier_status_by_worker`	工作线程应用程序状态Worker thread applier status
`replication_asynchronous_connection_failoverreplication_asynchronous_connection_failover`	异步连接切换机制的源列表Source lists for asynchronous connection failover mechanism
`replication_asynchronous_connection_failover_managedreplication_asynchronous_connection_failover_managed`	异步连接切换机制的托管源列表Managed source lists for asynchronous connection failover mechanism
`replication_connection_configurationreplication_connection_configuration`	连接到源的配置参数Configuration parameters for connecting to source
`replication_connection_statusreplication_connection_status`	与源的连接当前状态Current status of connection to source
`replication_group_communication_informationreplication_group_communication_information`	复制组配置选项Replication group configuration options
`replication_group_configuration_versionreplication_group_configuration_version`	复制组成员操作配置的版本Version of the member actions configuration for replication group members
`replication_group_member_actionsreplication_group_member_actions`	包含在复制组成员操作配置中的成员操作Member actions that are included in the member actions configuration for replication group members
`replication_group_member_statsreplication_group_member_stats`	复制组成员统计信息Replication group member statistics
`replication_group_membersreplication_group_members`	复制组成员的网络和状态Replication group member network and status
`rwlock_instancesrwlock_instances`	锁同步对象实例Lock synchronization object instances
`session_account_connect_attrssession_account_connect_attrs`	当前会话的连接属性Connection attributes per for current session
`session_connect_attrssession_connect_attrs`	所有会话的连接属性Connection attributes for all sessions
`session_statussession_status`	当前会话的状态变量Status variables for current session
`session_variablessession_variables`	当前会话的系统变量System variables for current session
`setup_actorssetup_actors`	如何初始化新前台线程的监控How to initialize monitoring for new foreground threads
`setup_consumerssetup_consumers`	可以存储事件信息的消费者Consumers for which event information can be stored
`setup_instrumentssetup_instruments`	可以收集事件的已安装对象类别Classes of instrumented objects for which events can be collected
`setup_objectssetup_objects`	应监控哪些对象Which objects should be monitored
`setup_threadssetup_threads`	已安装线程名称和属性Instrumented thread names and attributes
`socket_instancessocket_instances`	活动连接实例Active connection instances
`socket_summary_by_event_namesocket_summary_by_event_name`	每个事件名称的套接字等待和 I/OSocket waits and I/O per event name
`socket_summary_by_instancesocket_summary_by_instance`	每个实例的套接字等待和 I/OSocket waits and I/O per instance
`status_by_accountstatus_by_account`	每个账户的会话状态变量Session status variables per account
`status_by_hoststatus_by_host`	每个主机名的会话状态变量Session status variables per host name
`status_by_threadstatus_by_thread`	每个会话的会话状态变量Session status variables per session
`status_by_userstatus_by_user`	每个用户名的会话状态变量Session status variables per user name
`table_handlestable_handles`	表锁和锁请求Table locks and lock requests
`table_io_waits_summary_by_index_usagetable_io_waits_summary_by_index_usage`	按索引的表 I/O 等待Table I/O waits per index
`table_io_waits_summary_by_tabletable_io_waits_summary_by_table`	按表的表 I/O 等待Table I/O waits per table
`table_lock_waits_summary_by_tabletable_lock_waits_summary_by_table`	按表的表锁等待Table lock waits per table
`threadsthreads`	关于服务器线程的信息Information about server threads
`tls_channel_statustls_channel_status`	每个连接接口的 TLS 状态TLS status for each connection interface
`tp_thread_group_statetp_thread_group_state`	线程池线程组状态Thread pool thread group states
`tp_thread_group_statstp_thread_group_stats`	线程池线程组统计信息Thread pool thread group statistics
`tp_thread_statetp_thread_state`	线程池线程信息Thread pool thread information
`user_defined_functionsuser_defined_functions`	已注册可加载函数Registered loadable functions
`user_variables_by_threaduser_variables_by_thread`	每个线程的用户定义变量User-defined variables per thread
`usersusers`	每个客户端用户名的连接统计信息Connection statistics per client user name
`variables_by_threadvariables_by_thread`	每个会话的会话系统变量Session system variables per session
`variables_infovariables_info`	系统变量最近是如何设置的How system variables were most recently set

首页上一级下一节