title: Mysql slave stuck as sql and io show yes
body: <p>help me with the below issue on slave.. </p>
  
  <pre><code>mysql&gt; show slave status\G
  *************************** 1. row ***************************
                 Slave_IO_State: Waiting for master to send event
                    Master_Host: isp-db-mysql-1.be.infra
                    Master_User: slave
                    Master_Port: 3306
                  Connect_Retry: 60
                Master_Log_File: isp-db-mysql-1.052619
            Read_Master_Log_Pos: 3138691
                 Relay_Log_File: isp-db-mysql-1-relay-bin.000002
                  Relay_Log_Pos: 32861
          Relay_Master_Log_File: isp-db-mysql-1.052556
               Slave_IO_Running: Yes
              Slave_SQL_Running: Yes
                Replicate_Do_DB:
            Replicate_Ignore_DB:
             Replicate_Do_Table:
         Replicate_Ignore_Table:
        Replicate_Wild_Do_Table:
    Replicate_Wild_Ignore_Table:
                     Last_Errno: 0
                     Last_Error:
                   Skip_Counter: 0
            Exec_Master_Log_Pos: 8109731
                Relay_Log_Space: 6642282995
                Until_Condition: None
                 Until_Log_File:
                  Until_Log_Pos: 0
             Master_SSL_Allowed: No
             Master_SSL_CA_File:
             Master_SSL_CA_Path:
                Master_SSL_Cert:
              Master_SSL_Cipher:
                 Master_SSL_Key:
          Seconds_Behind_Master: 1111111
  Master_SSL_Verify_Server_Cert: No
                  Last_IO_Errno: 0
                  Last_IO_Error:
                 Last_SQL_Errno: 0
                 Last_SQL_Error:
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>relay log position is not moving, and which made the slave lag as shown above..</p>
  
  <p>i tried to pull the binlog i got this error </p>
  
  <p>@ mysqlbinlog unknown variable 'default-character-set=utf8'</p>
  
  <p>in my.cnf binlog mode is mixed</p>
  
  <p>i tried stop slave, start slave..
  nothing worked..</p>
  
  <p>need a quick help , its a issue on prod :-(</p>
  
  <p>change master to changed log,pos is the only wrk around for this ?</p>