Sometimes these large lists of calculations make more sense if we see them in practice. So let's make the assumption that 20,000 users will use our application each second. This is how that would look:
- 20000 / 50 = 400
- Default queries per page = 10
- Default tables per query = 3
- 400 * 10 * 3 * 2 = 2400
- 2400 * 8 = 19200
- 19200 IOPS in drives:
- 3.5" drives: 19200 / 200 = 96
- 2.5" drives: 19200 / 150 = 128
- SSDs: 2 + (19200 / 50000) = 2.38 ~ 3
- Add 10 percent:
- 3.5" drives: 96 + 9.6 = 105.6 ~ 106
- 2.5" drives: 128 + 12.8 = 140.8 ~ 141
- SSDs: 3 + 0.3 = 3.3 ~ 4
We are not taking space into account either, which would also increase our SSD count. We will be discussing capacity soon.