Estimation

Performance

  • Query with index should be around 1ms ~ 2ms

  • One write should be around 5ms for SSD disk

CPU capability

  • 1 CPU core can handle 200 operation

  • Usually database server: 56 CPU cores -> 60 CPU cores or more

  • 5-10 CPU cores should be enough without cache

  • One database should be good enough to handle the load

Cache performance

  • Memcache or Rediss usually are cluster, and usually one operation takes 0.1ms or less.

    • 1 CPU cores => 5000-10000 requests

    • 20-40 CPU cores => 200K requests (one machine)

QPS and concurrency

  • Defined inside Little's law

  • For example, if a server has a QPS of 20K and 10ms average response time.

  • Then the concurrency number will be 200.

Last updated