Replication troubleshooting with Slave_SQL


I use Percona MySQL for a almost 5 years and I’m really satisfied, and I have a broken replication between master and slave. After troubleshooting steps I found out, that Slave_IO is working well a Slave_SQL is not working. My Percona MySQL server is latest 5.6.31.

I red Slave_IO is taking care about grabbing master bin logs and delivering to slave relay log and Slave_SQL is taking care about processing of SQLs to databases. I have to say that I see IO and SQL is working:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Anyway, when I start the completely new bin logs on master I do replication and I see all datas are transferred to relay logs on slave, the output from SHOW SLAVE STATUS\G seems to be ok. Zero seconds behind master, waiting for master to send data, slave has read all relay log; waiting for the slave I/O thread to update it, BUT the tables are not updated with a new data.

Can you please give me a hint how to get back with replication? Thank you.

Hi Pavel,

I am also facing same issue. Did you found any solution?