Numbers To Know hard
You have a system with 100k QPS. 50% are writes. Writes are 1KB. How much disk bandwidth do you need (ignoring WAL/replication overhead)?
- A 50 MB/s (Megabytes per second)
- B 100 MB/s (Megabytes per second)
- C 500 MB/s (Megabytes per second)
- D 1 GB/s (Gigabytes per second)
Answer: A. 50 MB/s (Megabytes per second)
To solve this, calculate the volume of write traffic: 100,000 total QPS $\times$ 50% write ratio = 50,000 writes per second. Since each write is 1 KB, the total bandwidth needed is $50,000 \times 1 \text{ KB} = 50,000 \text{ KB/s}$, or exactly 50 MB/s. While a single SSD can easily handle 50 MB/s of sequential traffic, real-world systems must also account for 'Write Amplification' (the extra writes performed by the database engine for logs and indexing) and replication overhead. In practice, this 50 MB/s of application data might result in 100-200 MB/s of actual physical disk activity.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- What is the maximum allowed downtime per year for a system targeting '99.9%' (Three Nines) availability?
- What is the typical size of a standard ASCII character (e.g., 'A')?
- What is the typical Round Trip Time (RTT) for a single network packet traveling between New York and London (Transatlantic)?
- Network bandwidth is usually denoted in **bits** per second (Gbps), while storage is in **Bytes** (GB). What is the conversion ratio?
- Storing a password using a secure algorithm like bcrypt (cost 10) or Argon2 typically consumes how much storage per user?
- How much power does a typical fully-loaded rack-mount server consume?