Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the general strategy for configuring for a random I/O environment?

0
Posted

What is the general strategy for configuring for a random I/O environment?

0

You want all disk spindles to be busy most of the time servicing I/O requests. Random I/O requests are small (typically 2-8 Kbytes), so it’s not efficient to split an individual request of this kind onto multiple disk drives. The interlace size doesn’t matter, because you just want to spread the data across all the disks. Any interlace value greater than the typical I/O request will do. For example, assume you have 4.2 Gbytes DBMS table space. If you stripe across four 1.05-Gbyte disk spindles, and if the I/O load is truly random and evenly dispersed across the entire range of the table space, then each of the four spindles will tend to be equally busy. The target for maximum random I/O performance on a disk is 35 percent or lower as reported by DiskSuite Tool’s performance monitor, or by iostat(1M). Disk use in excess of 65 percent on a typical basis is a problem. Disk use in excess of 90 percent is a major problem. If you have a disk running at 100 percent and you stripe the data acr

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123