8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

10.14.4 复制源线程状态10.14.4 Replication Source Thread States

下面的列表显示了在复制源的Binlog Dump线程的State列中最常见的状态。如果在源上看不到任何Binlog Dump线程,则表示复制未运行;也就是说,目前没有副本连接。The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently connected.

在 MySQL 8.0 中,对监控指标名称进行了不兼容的更改。使用这些监控指标名称的监控工具可能会受到影响。如果这些不兼容的更改对您有影响,请将 terminology_use_previous 系统变量设置为 BEFORE_8_0_26,以使 MySQL 服务器使用前面列表中指定对象的旧名称版本。这可以使依赖旧名称的监控工具继续工作,直到它们可以更新以使用新名称为止。In MySQL 8.0, incompatible changes were made to instrumentation names. Monitoring tools that work with these instrumentation names might be impacted. If the incompatible changes have an impact for you, set the terminology_use_previous system variable to BEFORE_8_0_26 to make MySQL Server use the old versions of the names for the objects specified in the previous list. This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names.

将 terminology_use_previous 系统变量设置为会话范围以支持单独函数,或设置为全局范围以作为所有新会话的默认值。当使用全局范围时,慢查询日志包含名称的旧版本。Set the terminology_use_previous system variable with session scope to support individual functions, or global scope to be a default for all new sessions. When global scope is used, the slow query log contains the old versions of the names.

  • Finished reading one binlog; switching to next binlog Finished reading one binlog; switching to next binlog

    线程已完成读取二进制日志文件,并正在打开下一个文件以发送到副本。The thread has finished reading a binary log file and is opening the next one to send to the replica.

  • Master has sent all binlog to slave; waiting for more updates Master has sent all binlog to slave; waiting for more updates

    Source has sent all binlog to replica; waiting for more updates Source has sent all binlog to replica; waiting for more updates

    该线程已读取二进制日志中的所有剩余更新并将其发送到副本。该线程现在处于空闲状态,等待二进制日志中出现由源发生的新更新引起的新事件。The thread has read all remaining updates from the binary logs and sent them to the replica. The thread is now idle, waiting for new events to appear in the binary log resulting from new updates occurring on the source.

  • Sending binlog event to slave Sending binlog event to slave

    Sending binlog event to replica Sending binlog event to replica

    二进制日志由 事件 组成,其中事件通常是一条更新以及其他一些信息。线程已从二进制日志中读取了一个事件,现在正在将其发送到副本。Binary logs consist of events, where an event is usually an update plus some other information. The thread has read an event from the binary log and is now sending it to the replica.

  • Waiting to finalize termination Waiting to finalize termination

    在线程停止时发生的非常短暂的状态。A very brief state that occurs as the thread is stopping.