In this blog post, I will look at disk utilization and saturation.
In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will look at another critical component of database performance: the storage subsystem. In this post, I will refer to the storage subsystem as “disk” (as a casual catch-all).
The most common tool for command line IO performance monitoring is
, which shows information like this:
root@ts140i:~# iostat -x nvme0n1 5 Linux 4.4.0-89-generic (ts140i) 08/05/2017 _x86_64_ (4 CPU) avg-cpu: %user %nice %system %iowait %steal %idle 0.51 0.00 2.00 9.45 0.00 88.04 Device: rrqm/s …[Read more]