mysql命令 show slave status\G;命令输出详解

时间：2023-03-09 06:34:03
mysql命令 show slave status\G;命令输出详解

show slave status\G; 命令输出详解

mysql> show slave status\G;

*************************** . row ***************************

               Slave_IO_State: Waiting for master to send event

                  Master_Host: 10.10.118.25

                  Master_User: mysync

                  Master_Port:

                Connect_Retry:

              Master_Log_File: mysql-bin.

          Read_Master_Log_Pos:

               Relay_Log_File: mysql-relay-bin.

                Relay_Log_Pos:

        Relay_Master_Log_File: mysql-bin.

             Slave_IO_Running: Yes   #Yes表示io_thread的和主库连接正常并能实施复制工作，No则说明与主库通讯异常，多数情况是由主从间网络引起的问题；

            Slave_SQL_Running: Yes   #具体就是语句是否执行通过，常会遇到主键重复或是某个表不存在。

              Replicate_Do_DB:

          Replicate_Ignore_DB:

           Replicate_Do_Table:

       Replicate_Ignore_Table:

      Replicate_Wild_Do_Table:

  Replicate_Wild_Ignore_Table: mysql.%,test.%,information_schema.%

                   Last_Errno:

                   Last_Error:

                 Skip_Counter:

          Exec_Master_Log_Pos:

              Relay_Log_Space:

              Until_Condition: None

               Until_Log_File:

                Until_Log_Pos:

           Master_SSL_Allowed: No

           Master_SSL_CA_File:

           Master_SSL_CA_Path:

              Master_SSL_Cert:

            Master_SSL_Cipher:

               Master_SSL_Key:

        Seconds_Behind_Master: 0     #判断主动同步延时的参考值，是通过比较sql_thread执行的event的timestamp和io_thread复制好的event的timestamp(简写为ts)进行比较，而得到的这么一个差值；

Master_SSL_Verify_Server_Cert: No

                Last_IO_Errno:

                Last_IO_Error:

               Last_SQL_Errno:

               Last_SQL_Error:

  Replicate_Ignore_Server_Ids:

             Master_Server_Id:

 row in set (0.00 sec)

ERROR:

No query specified

mysql>

相关文章