[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

lokus earned 200 total points
ID: 12449492

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

650 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