Feedback on /admin/troubleshooting: How to investigate throttling, and why
- Dominant language
- No language data
- Stars
- 3
- Forks
- 4
- Avg merge
- 3d 18h
- Merged PRs (30d)
- 1
Description
### Documentation feedback
- Page title: Troubleshooting
- Page URL: https://cratedb.com/docs/guide/admin/troubleshooting/index.html
- Source: https://github.com/crate/cratedb-guide/blob/main/docs/admin/troubleshooting/index.md
---
In a future variant of the troubleshooting section, it could elaborate about hands-on details, like how to investigate CrateDB's throttling mechanisms.
One could enable logging to see when the related throttle mechanism kicks in by:
```sql
SET GLOBAL 'logger.io.crate.execution.engine.indexing' = 'DEBUG';
```
Or, if this creates too much noise, more concrete:
```sql
SET GLOBAL 'logger.io.crate.execution.engine.indexing.BatchIteratorBackpressureExecutor' = 'DEBUG';
```
Afterwards there should be log entries like:
```text
Pausing consumption jobId={} delayInMs={}
Resuming consumption jobId={}
```
This may help to understand if throttling is valid or not.Please note that mostly the throttling is not just kicking in because of CPU load, but also, or even more likely, because of memory/heap saturation.
Thanks, @seut.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.