Size Estimation

This result is a starting point of the cluster size, you should validate the sizing provided by the tool by doing a POC test and adjust the sizing based on the specific workload testing.

If node num is more than 50, the result may be unreliable or even meaningless(marked as 'N/A')!

Reference Doc: TiDBCloud Cluster Size Estimation Model

Performance Requirement

Storage Requirement

percentage of how much storage is expected to be used

{#if $compress.param === 'compression_ratio'} {:else if $compress.param === 'reduction_percent'} {/if}

This means 1 GiB data will be compressed to {$compress.param === 'compression_ratio' ? Math.ceil((1 / Number($compress.ratio)) * 100) / 100 : Math.ceil(100 - Number($compress.reductionPercent)) / 100} GiB

TiDB Estimation Result

Latency({WorkloadTypes.find((it) => it.value === $workloadType)?.label || '-'})

8 vCPU, 16 GiB

16 vCPU, 32 GiB

P95≈{$workloadType === 'point_select' ? 5 : 100}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tidb' && explainExpend?.perf === 'p95100ms'}

(explainExpend = null)} />

{/if}

P99≈{$workloadType === 'point_select' ? 10 : 300}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tidb' && explainExpend?.perf === 'p99300ms'}

(explainExpend = null)} />

{/if}

P99≈{$workloadType === 'point_select' ? 5 : 100}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tidb' && explainExpend?.perf === 'p99100ms'}

(explainExpend = null)} />

{/if}

TiKV Estimation Result

Latency({WorkloadTypes.find((it) => it.value === $workloadType)?.label || '-'})

8 vCPU, 32 GiB

16 vCPU, 64 GiB

P95≈{$workloadType === 'point_select' ? 5 : 100}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tikv' && explainExpend?.perf === 'p95100ms'}

(explainExpend = null)} />

{/if}

P99≈{$workloadType === 'point_select' ? 10 : 300}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tikv' && explainExpend?.perf === 'p99300ms'}

(explainExpend = null)} />

{/if}

P99≈{$workloadType === 'point_select' ? 5 : 100}ms

handleExplain(e.detail)} on:pick />

{#if explainExpend?.type === 'tikv' && explainExpend?.perf === 'p99100ms'}

(explainExpend = null)} />

{/if}