Skip to main content

mz-profile

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries, high CPU/memory in Materialize. Also "slow" or "using too much memory" without explicit profile mention.

Quellinformationen

Repository
MaterializeInc/materialize
Letzte Quellaktivität
12. Oktober 2026 um 10:28
Erkannte Sprache von SKILL.md
Englisch
Sterne
6.383
Forks
515

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

SKILL.md wird angezeigt

SKILL.md
Quellanweisungen · Schreibgeschützte Vorschau
name
mz-profile
description
Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries, high CPU/memory in Materialize. Also "slow" or "using too much memory" without explicit profile mention.
# Profiling Materialize ## CPU profiling Prefer profiling with [samply](https://github.com/mstange/samply), which produces Firefox Profiler-compatible flame graphs. * Attach to a running process: `samply record -p PID` * Record environmentd from startup: `bin/environmentd --wrapper "samply record"` * Record clusterd processes from startup: `bin/environmentd -- --orchestrator-process-wrapper "samply record"` Samply opens a browser tab with an interactive flame graph when recording finishes. On macOS, enable codesigning for Instruments support: `bin/environmentd --enable-mac-codesigning` ### Continuous profiles in cloud environments Observed: Polar Signals offers on-CPU and in-use heap profiles only, no off-CPU profiles, so threads blocked on page faults or IO are invisible. Flame graph root totals are not additive across series. Take absolute load from cAdvisor's `container_cpu_usage_seconds_total` or rusage, and use the profiler only for proportions within it. ## Memory profiling Valgrind doesn't work on Materialize as it's too slow to yield results. Heaptrack works, but is slow. Run heaptrack on environmentd processes: `bin/environmentd --reset --no-default-features --wrapper "heaptrack --raw"` Run heaptrack on clusterd processes: `bin/environmentd --reset --no-default-features -- --orchestrator-process-wrapper "heaptrack --raw"` Use `heaptrack --interpret` on the `.raw.zst` file to analyze. Set `MALLOC_CHECK_=3 MALLOC_PERTURB_=123` (and compile with `--no-default-features` on Linux to use the system allocator instead of jemalloc) to detect some memory corruption issues. ## Analyze the size of binary functions `nm --demangle=rust --print-size --size-sort --radix=d BINARY` to determine the binary size of symbols in `BINARY`. Produces a potentially large output, which should be redirected and analyzed separately. Filter with `cut -d' ' -f2- | sort | sort -k3 | uniq` to just learn about the size of symbols.
Auf GitHub ansehen