what is the best way to monitor read requests coming into a slave?

We’re working on switching our application code to send reads to a slave (or proxy) so its a gradual process. What’s the best way to monitor the activity on the slave to make sure that the reads are coming through?


  1. Enable the general query log; or
  2. Enable the slow query log with long_query_time=0 if you have mysql5.1 or a 5.0 Percona build; or
  3. Watch TCP traffic (mk-query-digest is handy for this).