How can I calculate the Read / Write ratio?

MySQL & MariaDB Other MySQL® Questions
1

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.

3

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