MySQL Forums
Forum List  »  MySQL & Storage

Identifying if I have IO issues on an extremely busy mysql database servers
Posted by: Ravi Malghan
Date: April 23, 2019 05:09PM

I have a moderate to high busy mysql database server (in terms of read and writes). We are having some performance issues. Trying to figure out what might be causing the bottleneck. Database definitely has significantly higher number of reads compared to writes (insert/delete/update). The server has the following specs

Total database size 1TB
RAM: 256G (planning to increase it to 512TB). innodb-buffer-pool-size is set to about 80% of the memory (200G)
24 CPU VM host
Storage is on a SAN with flash storage.

Based on what iostat is showing, read disk latency is in the range 1ms to 12ms averaging around 6ms. Write disk latency is about 1ms to 2.5ms. I have validated this value with other tools as well. Wanted to poll other users to see what kind of latency they are seeing on busy mysql servers. Are my numbers too high or normal or great.
Read throughput is in the range of 176 Mbs - 700Mbs with average about 500Mbs. Write is about 1.58 Mbs-46Mbs with average about 15Mbs.

First time I am dealing with something like this. I can provide additional details what I have provided is not sufficient.


Options: ReplyQuote

Written By
Identifying if I have IO issues on an extremely busy mysql database servers
April 23, 2019 05:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.