# How can I calculate the Read / Write ratio?

**URL:** <https://forums.percona.com/t/how-can-i-calculate-the-read-write-ratio/1093>\
**Category:** Other MySQL® Questions\
**Created:** [February 24, 2009, 10:14am UTC](https://forums.percona.com/t/how-can-i-calculate-the-read-write-ratio/1093 "2009-02-24T10:14:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cizara](https://avatars.discourse-cdn.com/v4/letter/c/3e96dc/32.png) [@cizara](https://forums.percona.com/u/cizara)\
**Post date:** [February 24, 2009, 10:14am UTC](https://forums.percona.com/t/how-can-i-calculate-the-read-write-ratio/1093/1 "2009-02-24T10:14:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![vgatto](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vgatto/32/748_2.png) [@vgatto](https://forums.percona.com/u/vgatto)\
**Post date:** [February 24, 2009, 4:46pm UTC](https://forums.percona.com/t/how-can-i-calculate-the-read-write-ratio/1093/2 "2009-02-24T16:46:34Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![cizara](https://avatars.discourse-cdn.com/v4/letter/c/3e96dc/32.png) [@cizara](https://forums.percona.com/u/cizara)\
**Post date:** [February 25, 2009, 7:12am UTC](https://forums.percona.com/t/how-can-i-calculate-the-read-write-ratio/1093/3 "2009-02-25T07:12:29Z")

</div>

Thanks!! That was exactly what I was looking for!!