道行尚浅的道场

events_waits_summary_by_thread_by_event_name 详解

系统表介绍 events_waits_summary_by_thread_by_event_name 按事件名称与线程ID进行汇总列名含义 THREAD_ID 线程编号 ...

Posted by 道行尚浅 on September 20, 2021

events_waits_summary_by_instance 详解

系统表介绍 events_waits_summary_by_instance 按事件与对象内存地址进行汇总列名含义 EVENT_NAME 事件名称 OBJE...

Posted by 道行尚浅 on September 19, 2021

events_waits_summary_by_host_by_event_name 详解

系统表介绍 events_waits_summary_by_host_by_event_name 按客户端地址与事件名进行汇总列名含义 HOSTNAME 客户端IP ...

Posted by 道行尚浅 on September 18, 2021

events_waits_summary_by_account_by_event_name 详解

系统表介绍 events_waits_summary_by_account_by_event_name 包含所有等待事件按访客与等待事件的汇总列名含义 USER 用户名 ...

Posted by 道行尚浅 on September 17, 2021

status_by_thread 详解

系统表介绍 status_by_thread 记录了活动每个会话的状态变量列名含义 THREAD_ID 线程编号 VARIABLE_NAME 变...

Posted by 道行尚浅 on September 16, 2021

session_status 详解

系统表介绍 session_status 描述了全局各状态的值相对于Information_schema的同名表,Performance_schema 中的表不包含Com_XXX的视图列名含义 V...

Posted by 道行尚浅 on September 15, 2021

global_status 详解

系统表介绍 global_status 描述了会话各状态的值列名含义 VARIABLE_NAME 状态名称 VARIABLE_VALUE 状态值...

Posted by 道行尚浅 on September 14, 2021

variables_by_thread 详解

系统表介绍 variables_by_thread 显示线程变量信息列名含义 THREAD_ID 线程标识符 VARIABLE_NAME 变量名 ...

Posted by 道行尚浅 on September 13, 2021

session_variables 详解

系统表介绍 session_variables 当前会话变量信息列名含义 VARIABLE_NAME 变量名 VARIABLE_VALUE 变量...

Posted by 道行尚浅 on September 12, 2021

global_variables 详解

系统表介绍 GLOBAL_VARIABLES 表描述了全局系统变量列名含义 VARIABLE_NAME 变量名 VARIABLE_VALUE 变...

Posted by 道行尚浅 on September 11, 2021

table_handles 详解

系统表介绍 table_handles 显示了表锁相关信息列名含义 OBJECT_TYPE 对象类型 OBJECT_SCHEMA 对象所属模式 ...

Posted by 道行尚浅 on September 10, 2021

metadata_locks 详解

系统表介绍 MySQL 使用元数据锁来关系数据库对象的并发访问来确保数据的一致性。 metadata_locks 显示元数据锁相关信息列名含义 OBJECT_TYPE 对象类型 ...

Posted by 道行尚浅 on September 9, 2021

replication_group_member_stats 详解

系统表介绍 replication_group_member_stats 描述了组复制状态信息列名含义 CHANNEL_NAME 通道名称 VIEW_ID ...

Posted by 道行尚浅 on September 8, 2021

replication_group_members 详解

系统表介绍 replication_group_members 显示了组复制的成员信息列名含义 CHANNEL_NAME 通道名称 MEMBER_ID ...

Posted by 道行尚浅 on September 7, 2021

replication_applier_status_by_worker 详解

系统表介绍 replication_applier_status_by_worker 如果不是多元复制，此表显示应用线程状态，否则此表显示工作线程的信息。列名含义 CHANNEL_NAME ...

Posted by 道行尚浅 on September 6, 2021

replication_applier_status_by_coordinator 详解

系统表介绍 replication_applier_status_by_coordinator 显示多源复制SQL协调者信息列名含义对应show slave 项 CHANNEL_NAME...

Posted by 道行尚浅 on September 5, 2021

replication_applier_status 详解

系统表介绍 replication_applier_status 显示当前复制的事务执行状态列名含义 CHANNEL_NAME 通道名称 SERVICE_S...

Posted by 道行尚浅 on September 4, 2021

replication_applier_configuration 详解

系统表介绍 replication_applier_configuration 显示影响事务应用的参数配置信息（MASTER_DELAY）列名含义 CHANNEL_NAME 通道名称 ...

Posted by 道行尚浅 on September 3, 2021

events_statements_summary_by_host_by_event_name 详解

系统表介绍 events_statements_summary_by_host_by_event_name 列名含义 HOST 客户端IP EVENT_NAM...

Posted by 道行尚浅 on September 2, 2021

replication_connection_status 详解

系统表介绍 replication_connection_status 表描述了连接是变更的值列名含义 CHANNEL_NAME 通道名称 GROUP_NAM...

Posted by 道行尚浅 on September 2, 2021