How to see the queries executing by slave io thread
Posted by:
Manohar K
Date: November 05, 2014 06:11AM
We had an strange with mysql replication. We have observed huge load and io wait on server while replication is in-progress. We can know the the queries from binlog by using mysqlbinlog utility. But we would like to see on the slave server what queries it is executing in particular time. We have enabled general log to see the queries but we have commit statements only.
How to see the queries executing by replication thread??
we are using 5.6.10 for both master and slave.
Subject
Views
Written By
Posted
How to see the queries executing by slave io thread
1734
November 05, 2014 06:11AM
1096
November 06, 2014 09:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.