Linux /proc filesystem for MySQL DBAs
summary
Shows how to use Linux /proc to sample per-thread activity in MySQL servers, including thread sleep states, current system calls and kernel wait locations, and how to drill into CPU usage for threads or the whole system. Describes tools and approaches such as Tanel Poder’s 0x.tools and ad-hoc scripts, and how to capture historical data for post‑mortem analysis with minimal impact and no configuration changes.
AI-written summary · about
related talks
21mUsing eBPF Off-CPU Sampling to See What Your DBs are Waiting For
57mPerformance Analysis and Optimization of MySQL
39mLinux Server Deep Dives
43mOptimizing MySQL without SQL or touching my.cnf
54mPerformance Analysis and Optimization of MySQL
49mMySQL monitoring and debugging: maximum insight with minimal cost
51mResolving MySQL Problems Quickly
51mLinux Systems Performance - Architecture