💾 Archived View for gemini.bortzmeyer.org › fosdem › event-11165.gmi captured on 2022-04-29 at 01:18:42. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-12-17)
-=-=-=-=-=-=-
Valerii Kravchuk
Type devroom
Sampling /proc content for troubleshooting
Starts on day 2 (2021-02-07) at 15:00 (Brussels time, UTC+1) in room Mysql (duration 00:30)
Matrix room #mysql:fosdem.org
Tools and approaches based on /proc samp0ling (like 0x.tools 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.