MySQL running in the LAMP stack is a complex system, luckily there is a lot of good instrumentation for investigation into the three fundamental performance problems: high CPU load, disk bandwidth problems and internal locks contention.
This webinar will discuss how to detect MySQL IO problems on Linux on different abstraction layers:
- Using high level unix tools
- Instrumentation inside mysql
- OS level debug and tracing tools, including linux dynamic tracing framework and more usual tools