Trying to understand SHOW SLAVE STATUS in MySQL
I want to understand further is the Relay_Log_File, Relay_Log_Pos and Relay_Master_Log_File.


From SHOW SLAVE STATUS\G, get two values


Relay_Log_File : Current relay log accepting new entries during replication
Relay_Log_Pos : Current position of the current relay log accepting new entries during replication
Relay_Master_Log_File : Relay log file containing the last successfully executed SQL statement on the Master that was executed on the Slave.
Master_Log_File : The log on the Master that corresponds to the current relay log file and current relay log position



  The files are in binary so not able to view them right


Yes, you can view the relay logs. Since they have the same structure as a regular binary log, just run the mysqlbinlog program. For example to view the SQL within any of you relay logs, such as the last one, do this:

mysqlbinlog mysqld-relay-bin.000056 &gt; /root/SQLForCurrentRelayLog.txt
less /root/SQLForCurrentRelayLog.txt