Command to check read/write ratio?

Question

Hello

Is there a command in MySQL that returns the read-to-write ratio of queries so that I'm able to know on what MySQL spends time, and whether the load would lower significantly by splitting data over two servers.

Thank you.

Answer 1

You can use the "show status" and check the "Com_%" variables for read/write ratios.

As for splitting the data, you'll have to check the slow query log (Google mysqlsla) and find out if those queries are amicable to being split.

-daniel