Explanation of SHOW SLAVE STATUS

Posted on 2004-10-29
Last Modified: 2012-08-13
Can someone please tell me what each of these fields exactly mean. The following is what I get when I do SHOW SLAVE STATUS.

mysql> show slave status \G
*************************** 1. row ***************************
          Master_Host: y5
          Master_User: repl
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File: y5-bin.003
  Read_Master_Log_Pos: 324921062
       Relay_Log_File: y2-relay-bin.002
        Relay_Log_Pos: 96655709
Relay_Master_Log_File: y5-bin.003
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
           Last_errno: 0
         Skip_counter: 0
  Exec_master_log_pos: 308084871
      Relay_log_space: 113491900
1 row in set (0.00 sec)
Question by:laylaylilom
    1 Comment
    LVL 8

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Product Review - Android Remix

    Come along for the ride with our Senior Product Manager, Brian Matis, as he reviews the Android Remix.

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    911 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now