Announcement

Announcement Module
Collapse
No announcement yet.

How can I calculate the Read / Write ratio?

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

  • How can I calculate the Read / Write ratio?

    Hi there,

    I want to calculate the read / write ratio of a DB but I don't know how to do it. I'm using MyIsam tables without query cache. Is there a way to do it looking the server status?

    Thanks!
    Lucho

  • #2
    Try


    SHOW GLOBAL STATUS LIKE 'Com_%';


    It's basically a count of how often different types of commands are invoked. It's a lot more granular than just read and write, but it should get you there.

    Comment


    • #3
      Thanks!! That was exactly what I was looking for!!

      Comment

      Working...
      X