cockroachdb / cockroachdb/docs

Add info on disk spilling to Production Checklist

Open
#9,911 0 comments 0 reactions 1 assignee Assigned to @mikeCRL View on GitHub
C-doc-improvement
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Artem Ervits (dbist) commented:

## Production Checklist
Add information on disk spilling, currently only available in `cockroach start` based on `--temp-dir` which is very easy to ignore.

## Description
In times when workload includes complex queries and there's a lot of disk spill based on the `sql.distsql.temp_storage.workmem` metric, it is advisable to tune if not separate out the `--temp-dir` directory to a dedicated disk away from `--store` disk. More research is needed but this is an area worthy of investigation further.

See https://cockroachlabs.slack.com/archives/CJGSARZJR/p1614697210030500

## Outline

## Expected Audience

CC: @johnrk @a-entin @holtrdan

Jira Issue: DOC-1004

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.