Partition pruning

Flow 08
HTTP/2HTTP/2Users3,000 req/sUsers2 req/sWide-column…4 vCPU · 4 GB
HTTP/2HTTP/2Users3,000 req/sUsers2 req/sWide-colu…4 vCPU · 4 GB

Fix the board. Turn every goal green.

Traffic
Dash2 req/s · reads onlyViews3,000 req/s · writes only
Limit
Wide-column DB answers about 120,000 reads/s
Bill
  • Wide-column DB16 USD/mo
16 of 40 USD/mo

Goals

Not tested yet

99 of 100 requests finish faster than this.99 of 100 requests finish faster than this.The share of requests that fail or get no answer.What the servers and services cost each month.

A page-view table holds 1 billion rows from two years. The dashboard asks for yesterday's totals twice each second, and each query takes 30 s. Bring dashboard p99 below 2 s, keep writes below 100 ms, stay under 40 USD/mo, and use at most 2 edits.

09:05. Dashboard queries time out at 60 s. The page-view store reads 4,000 MB/s from a 500 MB/s disk.