1

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.