Explanation of SHOW SLAVE STATUS

Posted on 2004-10-29
Medium Priority
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

Accepted Solution

lokus earned 200 total points
ID: 12449492

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

607 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