Online / 6 & 7 February 2021


Linux /proc filesystem for MySQL DBAs

Sampling /proc content for troubleshooting

Tools and approaches based on /proc samp0ling (like by Tanel Poder or ad hoc scripts) allow to measure individual thread level activity in MySQL server on Linux, like thread sleep states, currently executing system calls and kernel wait locations. If needed you can drill down into CPU usage of any thread or the system as a whole. Historical data can be captured for post factum analysis, without much impact on the system and no need to install or change anything in its configuration. In this presentation I am going to summarize what's possible with /proc and show useful examples for MySQL DBAs.


Photo of Valerii Kravchuk Valerii Kravchuk