How to read queries of master that sends to slaves?

Question

I want to see queries that Master sends to slaves in Mysql ? Is there a way to see that ?

Answer 1

SEE QUERIES AS THEY HAPPEN ON THE SLAVE

On a running Slave, you should see to connections with the username system user

Login to the Slave and run this

SELECT * FROM information_schema.user WHERE user = 'system user'\G

SEE QUERIES BEFORE THE SLAVE GETS TO PROCESS THEM

On a running Master, the binary logs contains all completed SQL commands.

To the see the commands, you need to use the mysqlbinlog command utility agaunst the binary logs on the Master or you could run it against the relay logs on the Slave

Here are my earlier posts on how to apply mysqlbinlog in a variety of ways

• Feb 18, 2014 : mysqlbinlog failing with " ERROR 1032 (HY000) at line 48: Can't find record in `` " Error
• Sep 06, 2013 : MySQL : Extract SQL statements from binlog
• Sep 03, 2013 : Get missed transactions from slave
• Feb 04, 2013 : MySQL Point in Time Recovery For Just a Single Schema?
• Aug 16, 2012 : How to see what was executed in the database via binlogs for specific date?
• May 26, 2012 : Trying to understand SHOW SLAVE STATUS\G
• Oct 26, 2011 : Multi-threaded replay of master activity for load/performance testing