MySQL Forums
Forum List  »  Replication

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to see the queries executing by slave io thread
1573
November 05, 2014 06:11AM


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.