GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

    Thanks

  • #2
    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).

    Comment

    Working...
    X