理解磁盘访问I/O性能||IO Workload Profiles

• Overview

  关于数据库的性能，对于column-oriented database，很多时候性能取决于计算机硬件的磁盘访问I/O性能。

• 一、Workload Profiles

• Workload Profiles

  In the most generic sense, a workload profile describes the behavior of an application, or portion of an application with respect to how it performs work;

  Workload profiles for storage systems are typically descibed and grouped by key “Workload Characteristics”;

• IO workload characteristics

  There are many characteristics of an IO workload that affect performance:

  1. IO Size

     IO size: the size of the Input or Output request.

     The smaller an IO, the less time it takes to transmit; the larger an IO, the longer it takes to transmit;

     It is the compromise that most applications need to trade-off moving data efficiently in the right size containers with as few round trips as possible.

  2. IOPS

     IOPS measures the number of Input/Output operations Per Second, this is sometimes referred to as requests per second.

     The number of vehicles that pass through the boll in one hour is analogous to the number of bytes that pass through an interface each percond - IOPS;

  3. Throughput (bandwidth)

     Throughput measures the amount of work performed in a given time period;

     Returing to the toll road example, the throughout measures the amount of cargo that passes through the toll tooths in a given period of time;
     $$IOPS\ast$$