<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-disk-write-speed-aggregate">
      </a>
      25.6.17.29 The ndbinfo disk_write_speed_aggregate Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089506800">
  </a>
  <p>
   The
   <code class="literal">
    disk_write_speed_aggregate
   </code>
   table provides
        aggregated information about the speed of disk writes during
        LCP, backup, and restore operations.
  </p>
  <p>
   The
   <code class="literal">
    disk_write_speed_aggregate
   </code>
   table contains
        the following columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      Node ID of this node
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       thr_no
      </code>
     </p>
     <p>
      Thread ID of this LDM thread
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       backup_lcp_speed_last_sec
      </code>
     </p>
     <p>
      Number of bytes written to disk by backup and LCP processes
            in the last second
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redo_speed_last_sec
      </code>
     </p>
     <p>
      Number of bytes written to REDO log in the last second
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       backup_lcp_speed_last_10sec
      </code>
     </p>
     <p>
      Number of bytes written to disk by backup and LCP processes
            per second, averaged over the last 10 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redo_speed_last_10sec
      </code>
     </p>
     <p>
      Number of bytes written to REDO log per second, averaged
            over the last 10 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       std_dev_backup_lcp_speed_last_10sec
      </code>
     </p>
     <p>
      Standard deviation in number of bytes written to disk by
            backup and LCP processes per second, averaged over the last
            10 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       std_dev_redo_speed_last_10sec
      </code>
     </p>
     <p>
      Standard deviation in number of bytes written to REDO log
            per second, averaged over the last 10 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       backup_lcp_speed_last_60sec
      </code>
     </p>
     <p>
      Number of bytes written to disk by backup and LCP processes
            per second, averaged over the last 60 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redo_speed_last_60sec
      </code>
     </p>
     <p>
      Number of bytes written to REDO log per second, averaged
            over the last 10 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       std_dev_backup_lcp_speed_last_60sec
      </code>
     </p>
     <p>
      Standard deviation in number of bytes written to disk by
            backup and LCP processes per second, averaged over the last
            60 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       std_dev_redo_speed_last_60sec
      </code>
     </p>
     <p>
      Standard deviation in number of bytes written to REDO log
            per second, averaged over the last 60 seconds
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       slowdowns_due_to_io_lag
      </code>
     </p>
     <p>
      Number of seconds since last node start that disk writes
            were slowed due to REDO log I/O lag
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       slowdowns_due_to_high_cpu
      </code>
     </p>
     <p>
      Number of seconds since last node start that disk writes
            were slowed due to high CPU usage
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       disk_write_speed_set_to_min
      </code>
     </p>
     <p>
      Number of seconds since last node start that disk write
            speed was set to minimum
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_target_disk_write_speed
      </code>
     </p>
     <p>
      Actual speed of disk writes per LDM thread (aggregated)
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
